relateditems

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: EXTRACT(epoch FROM now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint	plain			Default: EXTRACT(epoch FROM now())Last modification date and time as a Unix timestamp (auto-reset on modification)
item	integer	plain		items.ID	Item ID (**dependency**)
relateditem	integer	plain		items.ID	Related item ID; must be distinct from `item`
relation	text	extended			Default: ''Relation

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_relateditems_relateditem					btree	relateditem
pk_relateditems					btree	ID
u_relateditems_item_relateditem					btree	item, relateditem

Name	Type
c_relateditems_relateditem	check
dc_relateditems_relation	check
fk_relateditems_creator	foreign_key
fk_relateditems_item	foreign_key
fk_relateditems_relateditem	foreign_key
pk_relateditems	primary_key
u_relateditems_item_relateditem	unique

Loading...