dunning2transactions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID bigserial 19 nextval('"dunning2transactions_ID_seq"'::regclass)
creator int4 10 null
users.ID FK_dunning2transactions_creator N

The object creator

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

Last modification date/time (Unix timestamp in seconds)

dunning int4 10 null
dunning.ID FK_dunning2transactions_dunning C
transaction int4 10 null
transactions.ID FK_dunning2transactions_transaction C
fee float8 17,17 0

Optional dunning fee

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_dunning2transactions_ID Primary key Asc ID
UNQ_dunning2transactions_dunning_transaction Must be unique Asc/Asc dunning + transaction

Relationships