pricelists2accounts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID bigserial 19 nextval('"pricelists2accounts_ID_seq"'::regclass)
creator int4 10 null
users.ID FK_pricelists2accounts_creator N

The object creator

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

pricelist int4 10 null
pricelists.ID FK_pricelists2accounts_pricelist C
account int4 10 null
accounts.ID FK_pricelists2accounts_account C

Reference to the associated account

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_pricelists2accounts_ID Primary key Asc ID
UNQ_pricelists2accounts_pricelist_account Must be unique Asc/Asc pricelist + account

Relationships