Column Type Size Nulls Auto Default Children Parents Comments
ID int8 19 null

Component ID

creator int4 10 null
users.ID fk_components_creator N

Creator user ID (defaults to authenticated user on creation)

creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

item int4 10 null
items.ID fk_components_item C

Item ID (**dependency**)

component int4 10 null
items.ID fk_components_component C

Component item ID; must be distinct from item

amount float8 17,17 0

Amount (quantity)

price float8 17,17 null

Imputed price per unit

Table contained 0 rows


Constraint Name Type Sort Column(s)
pk_components Primary key Asc ID
fk_components_component Performance Asc component
u_components_item_component Must be unique Asc/Asc item + component