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

An arbitrary Contact Status identification number.

contactstatus varchar 16 null

Status of person, organization, or project.

statusdescription varchar 255 null

Description of the status.

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