suppliers


Columns

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

Supplier ID
creator int4 10 √ null
users.ID fk_suppliers_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)
lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
item int4 10 null
items.ID fk_suppliers_item C

Item ID (**dependency**)
account int4 10 null
accounts.ID fk_suppliers_account C

Account ID (**dependency**)
itemnum text 2147483647 ''::text

Supplier item number (SKU)
price float8 17,17 √ null

Supplier price per unit
minamount float8 17,17 0

Minimum order amount (quantity)
deliverytime int2 5 √ null

Expected delivery time in days
stock float8 17,17 √ null

Expected stock/inventory amount (quantity)

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_suppliers Primary key Asc ID
fk_suppliers_account Performance Asc account
s_suppliers Performance Asc itemnum
u_suppliers_item_account Must be unique Asc/Asc item + account

Relationships

Close relationships within degrees of separation