prices


Columns

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

Price ID
creator int4 10 √ null
users.ID fk_prices_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_prices_item C

Item ID (**dependency**)
pricelist int4 10 null
pricelists.ID fk_prices_pricelist C

Price list ID (**dependency**)
price float8 17,17 √ null

Price per unit (null=item.sellingprice for billing or null=item.purchaseprice for procurement)
rebate float8 17,17 0

Absolute rebate per unit (applied before discount)
discount float8 17,17 0

Relative discount in percent (applied after rebate)
minamount float8 17,17 0

Minimum amount (quantity)

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_prices Primary key Asc ID
fk_prices_item Performance Asc item
fk_prices_pricelist Performance Asc pricelist

Relationships

Close relationships within degrees of separation