pricelists


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"pricelists_ID_seq"'::regclass)
pricelists2accounts.pricelist FK_pricelists2accounts_pricelist C
prices.pricelist FK_prices_pricelist C
ownergroup int4 10 null
groups.ID FK_pricelists_ownergroup C

The owner group (if owneruser and ownergroup are NULL, the element is public)

creator int4 10 null
users.ID FK_pricelists_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)

activity int2 5 0

0: Active, 1: Deactivated

name text 2147483647 null
type int2 5 0

0: Billing minimum, 1: Billing maximum, 2: Procurement minimum, 3: Procurement maximum

currency varchar 3 null
datefrom int8 19 null

Unix timestamp in seconds

dateto int8 19 null

Unix timestamp in seconds

applytoall int2 5 0

Apply prices to all accounts

description text 2147483647 ''::text

The general description field

Table contained 0 rows

Indexes

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

Relationships