contactstatuses

7 rows


Description

Lookup table of Contact Statuses. Table is referenced by the Contacts table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contactstatusid serial 10 nextval('ndb.seq_contactstatuses_contactstatusid'::regclass)
contacts.contactstatusid fk_contacts_contactstatusesN
contactstatus varchar 16 null
statusdescription varchar 255 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
contactstatuses_pkey Primary key Asc contactstatusid

Relationships