relateditems

Module: inventory

Related item associations for cross-selling.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Component ID
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		EXTRACT(epoch FROM now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		EXTRACT(epoch FROM now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
item items.ID	integer			Item ID (**dependency**)
relateditem items.ID	integer			Related item ID; must be distinct from `item`
relation	text		''	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_item	foreign_key
fk_relateditems_relateditem	foreign_key
pk_relateditems	primary_key
u_relateditems_item_relateditem	unique

Loading...