dunning


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null
dunning2transactions.dunning fk_dunning2transactions_dunning C

Dunning notice ID
ownergroup int4 10 √ null
groups.ID fk_dunning_ownergroup C

Owner group ID (null=PUBLIC)
creator int4 10 √ null
users.ID fk_dunning_creator N

Creator user ID (defaults to authenticated user on creation)
assigneduser int4 10 √ null
users.ID fk_dunning_assigneduser N

Assigned user ID
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)
account int4 10 √ null
accounts.ID fk_dunning_account N

Account ID
dunningnum text 2147483647 null

Dunning number
date int8 19 date_part('epoch'::text, now())

Designated date and time as a Unix time stamp (defaults to current date and time on creation)
duedate int8 19 √ null

Due date as a Unix time stamp
status int2 5 0

Status (0=DRAFT, 1=BOOKED, 2=CANCELLED, 3=CLOSED)
level int2 5 0

Dunning level (0=REMINDER, 1=INITIAL, 2=INTERMEDIATE, 3=FINAL)
recipient text 2147483647 ''::text

Recipient
address text 2147483647 ''::text

Address (street and building/suite number)
postalcode text 2147483647 ''::text

Postal or ZIP code
city text 2147483647 ''::text

City or municipality
region text 2147483647 ''::text

Region or state
country varchar 2 ''::character varying

Country code (ISO 3166-1 alpha-2) (Pattern: ^([A-Z]{2})?$)

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_dunning Primary key Asc ID
fk_dunning_account Performance Asc account
i_dunning_date_ID Performance Desc/Desc date + ID
i_dunning_noowner Performance Asc ownergroup
i_dunning_owner Performance Asc/Asc ownergroup + assigneduser
s_dunning Performance Asc dunningnum
u_dunning_dunningnum Must be unique Asc dunningnum

Relationships

Close relationships within degrees of separation