addresses


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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
accounts.ID fk_addresses_account C

Account ID (**dependency**)
contact int4 10 null
contacts.ID fk_addresses_contact C

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

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_addresses Primary key Asc ID
fk_addresses_contact Performance Asc contact
u_addresses_account_contact_type Must be unique Asc/Asc/Asc/Asc account + contact + type + default

Relationships

Close relationships within degrees of separation