components

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	bigint	plain			Component ID
creator	integer	plain		users.ID	Creator user ID (defaults to authenticated user on creation)
creationdate	bigint	plain			Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint	plain			Default: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
item	integer	plain		items.ID	Item ID (**dependency**)
component	integer	plain		items.ID	Component item ID; must be distinct from `item`
amount	double precision	plain			Default: 0Amount (quantity)
price	double precision	plain			Imputed price per unit
fixed	smallint	plain			Default: 0Fixed quantity
order	integer	plain			No description provided.

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_components_component					btree	component
pk_components					btree	ID
u_components_item_component					btree	item, component

Name	Type
c_components_component	check
dc_components_amount	check
dc_components_amount	check
fk_components_component	foreign_key
fk_components_creator	foreign_key
fk_components_item	foreign_key
pk_components	primary_key
u_components_item_component	unique

Loading...