components

Module: inventory

Bill of materials linking parent items to component items.

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

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_order	check
fk_components_component	foreign_key
fk_components_item	foreign_key
pk_components	primary_key
u_components_item_component	unique

Loading...