pricelists2accounts

Module: pricelists

Junction table linking price lists to accounts.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Pricelist-to-account 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		EXTRACT(epoch FROM now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
pricelist pricelists.ID	integer			Price list ID (**dependency**)
account accounts.ID	integer			Account ID (**dependency**)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_pricelists2accounts_account					btree	account
pk_pricelists2accounts					btree	ID
u_pricelists2accounts_pricelist_account					btree	pricelist, account

Name	Type
fk_pricelists2accounts_account	foreign_key
fk_pricelists2accounts_pricelist	foreign_key
pk_pricelists2accounts	primary_key
u_pricelists2accounts_pricelist_account	unique

Loading...