ID |
int8 |
19 |
|
√ |
null |
|
|
Address ID |
creator |
int4 |
10 |
√ |
|
null |
|
users.ID
|
fk_addresses_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) |
account |
int4 |
10 |
|
|
null |
|
|
Account ID (**dependency**) |
contact |
int4 |
10 |
|
|
null |
|
|
Contact ID |
type |
int2 |
5 |
|
|
0 |
|
|
Address type (0 =BILLING_SHIPPING, 1 =BILLING_BILLING, 2 =PROCUREMENT_SHIPPING, 3 =PROCUREMENT_BILLING) |
default |
int2 |
5 |
|
|
0 |
|
|
Default for this address type |