You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

Table

cm_telephone_numbers

Description

Telephone Numbers

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement

 

number

varchar(64)

Telephone number

X.520 via RFC 4519 person

 

type

varchar(2)

Type of telephone, as enumerated

  • F: Fax
  • H: Home
  • M: Mobile
  • O: Office

 

co_person_id

integer, foreign key

CO Person Record ID

cm_co_people:id

Only one of co_person_id or org_person_id may be specified

org_person_id

integer, foreign key

Org Person Record ID

cm_org_identities:id

Only one of co_person_id or org_person_id may be specified

  • No labels