dunning


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"dunning_ID_seq"'::regclass)
dunning2transactions.dunning FK_dunning2transactions_dunning C
ownergroup int4 10 null
groups.ID FK_dunning_ownergroup C

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

creator int4 10 null
users.ID FK_dunning_creator N

The object creator

assigneduser int4 10 null
users.ID FK_dunning_assigneduser N

The assigned user

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)

account int4 10 null
accounts.ID FK_dunning_account N

Reference to the associated account

dunningnum text 2147483647 null

A unique number for the dunning transaction

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

Unix timestamp in seconds

duedate int8 19 null

Unix timestamp in seconds

status int2 5 0

0: Draft, 1: Booked, 2: Cancelled, 3: Closed

level int2 5 0

0: Reminder, 1: Initial, 2: Intermediate, 3: Final

recipient text 2147483647 ''::text
address text 2147483647 ''::text
postalcode text 2147483647 ''::text
city text 2147483647 ''::text
region text 2147483647 ''::text
country varchar 2 ''::character varying

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_dunning_ID Primary key Asc ID
UNQ_dunning_dunningnum Must be unique Asc dunningnum

Relationships