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

Pricelist-to-account ID

creator int4 10 null
users.ID fk_pricelists2accounts_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)

pricelist int4 10 null
pricelists.ID fk_pricelists2accounts_pricelist C

Price list ID (**dependency**)

account int4 10 null
accounts.ID fk_pricelists2accounts_account C

Account ID (**dependency**)

Table contained 0 rows


Constraint Name Type Sort Column(s)
pk_pricelists2accounts Primary key Asc ID
fk_pricelists2accounts_account Performance Asc account
u_pricelists2accounts_pricelist_account Must be unique Asc/Asc pricelist + account