| ID |
int8 |
19 |
|
√ |
null |
|
|
Dunning-to-transaction ID |
| creator |
int4 |
10 |
√ |
|
null |
|
|
users.ID
|
fk_dunning2transactions_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) |
| dunning |
int4 |
10 |
|
|
null |
|
|
dunning.ID
|
fk_dunning2transactions_dunning C
|
|
Dunning notice ID (**dependency**) |
| transaction |
int4 |
10 |
|
|
null |
|
|
Transaction ID (**dependency**) |
| fee |
float8 |
17,17 |
|
|
0 |
|
|
Transaction-specific dunning fee |
