addresses


Columns

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

The object creator

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_addresses_account C

Reference to the associated account

contact int4 10 null
contacts.ID FK_addresses_contact C

Reference to the associated contact

type int2 5 0

0: Billing/Shipping, 1: Billing/Billing, 2: Procurement/Shipping, 3: Procurement/Billing

default int2 5 0

Use the specified address as default billing/shipping address

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_addresses_ID Primary key Asc ID
UNQ_addresses_account_contact_type Must be unique Asc/Asc/Asc account + contact + type

Relationships