suppliers


Columns

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

The object creator

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

Last modification date/time (Unix timestamp in seconds)

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

Last modification date/time (Unix timestamp in seconds)

item int4 10 null
items.ID FK_suppliers_item C
account int4 10 null
accounts.ID FK_suppliers_account C

Reference to the associated account

itemnum text 2147483647 ''::text
price float8 17,17 null
minamount float8 17,17 0
deliverytime int2 5 null
stock float8 17,17 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_suppliers_ID Primary key Asc ID
UNQ_suppliers_item_account Must be unique Asc/Asc item + account

Relationships