app.project_capabilities

Vista

Capabilities: capability statements with direction Provide.

Columnas de app.project_capabilities
Columna	Tipo	Admite nulos	Descripción
id	uuid	Sí	Primary key, UUID v7.
org_id	uuid	Sí	Owning org, derived from app.projects on insert; never accepted from the caller and never changed.
project_id	uuid	Sí	Project.
direction	app.capability_direction	Sí	Require or Provide.
urid	text	Sí	Category required or provided.
description	text	Sí	What is required or provided.
quantity	numeric	Sí	Quantity, when countable.
unit_basis	text	Sí	Unit of the quantity.
is_critical	boolean	Sí	True for a critical requirement; an Unknown against it is a gate 3 gap.
assertion_domain	text	Sí	Always capability: the assertion family of the word.
assertion_word	text	Sí	CERTIFIED, DOCUMENTED, CLAIMED, INFERRED or UNKNOWN.
venue_id	uuid	Sí	Venue that provides a capability.
counterparty_id	uuid	Sí	Vendor or other counterparty that provides a capability.
deleted_at	timestamp with time zone	Sí	Soft delete time. A row with deleted_at set is ignored by every access helper.
created_at	timestamp with time zone	Sí	When the row was inserted. Set by the database.
created_by	uuid	Sí	Person who inserted the row, or null for a platform process. Set by the database.
updated_at	timestamp with time zone	Sí	When the row last changed. Set by the database.
updated_by	uuid	Sí	Person who last changed the row, or null for a platform process. Set by the database.