prices


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID bigserial 19 nextval('"prices_ID_seq"'::regclass)
creator int4 10 null
users.ID FK_prices_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_prices_item C
pricelist int4 10 null
pricelists.ID FK_prices_pricelist C
price float8 17,17 null
rebate float8 17,17 0

Absolute rebate on an item

discount float8 17,17 0

Relative discount on an item

minamount float8 17,17 0

Minimum amount to qualify for the rebate/discount

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_prices_ID Primary key Asc ID

Relationships