pricelists


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null
pricelists2accounts.pricelist fk_pricelists2accounts_pricelist C
prices.pricelist fk_prices_pricelist C

Price list ID
ownergroup int4 10 √ null
groups.ID fk_pricelists_ownergroup C

Owner group ID (null=PUBLIC)
creator int4 10 √ null
users.ID fk_pricelists_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)
activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
name text 2147483647 null

Name
type int2 5 0

Price list type (0=BILLING_MIN, 1=BILLING_MAX, 2=PROCUREMENT_MIN, 3=PROCUREMENT_MAX)
currency varchar 3 null

Currency code (ISO 4217) (Pattern: ^[A-Z]{3}$)
datefrom int8 19 √ null

Start date as a Unix time stamp; must be less than or equal to dateto
dateto int8 19 √ null

End date as a Unix time stamp; must be greater than or equal to datefrom
applytoall int2 5 0

Apply to all accounts regardless of association via pricelists2accounts
description text 2147483647 ''::text

Detailed general description

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_pricelists Primary key Asc ID
i_pricelists_noowner Performance Asc ownergroup
i_pricelists_owner Performance Asc ownergroup
s_pricelists Performance Asc name

Relationships

Close relationships within degrees of separation