suppliers

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	bigint	plain			Supplier 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**)
account	integer	plain		accounts.ID	Account ID (**dependency**)
itemnum	text	main			Default: ''Supplier item number (SKU)
price	double precision	plain			Supplier price per unit
taxrate	double precision	plain			Supplier tax rate in percent
minamount	double precision	plain			Default: 0Minimum order amount (quantity)
deliverytime	smallint	plain			Expected delivery time in days
stock	double precision	plain			Expected stock/inventory amount (quantity)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_suppliers_account					gin	account
pk_suppliers					btree	ID
s_suppliers_itemnum					gin	itemnum
u_suppliers_item_account					btree	item, account

Name	Type
dc_suppliers_deliverytime	check
dc_suppliers_itemnum	check
dc_suppliers_minamount	check
dc_suppliers_taxrate	check
fk_suppliers_account	foreign_key
fk_suppliers_creator	foreign_key
fk_suppliers_item	foreign_key
pk_suppliers	primary_key
u_suppliers_item_account	unique

Loading...