Area CodeExtension NumLine NumPhone Country CodePhone NumSpeed Dial NumTelephone Equipment TypeTelephone Exchange Code
| Business Data Model Data Model |
| Description | Information that is needed to contact any type of telephone device such as land line, cell phone or pager. |
| Attributes | |
| Area Code |
|
| Extension Num |
|
| Line Num |
|
| Phone Country Code |
|
| Phone Num |
|
| Speed Dial Num |
|
| Telephone Equipment Type |
|
| Telephone Exchange Code |
|
| Relationship | |
 Phone_User_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Area Code
| Description | Indicates the area code for the telephone, cell, or pager number. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Extension Num
| Description | A suffix for a telephone number to reach a specific phone in a main telephone network |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Line Num
| Description | Represents the telephone line number for the telephone, cell, or pager number. For US telephone numbers the line number refers to the last 4 digits of the local number (xxx-NNNN). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Phone Country Code
| Description | Indicates the country code for the telephone, cell, or pager number. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Phone Num
| Description | Represents the actual number (without formatting) for the telephone, cell, or pager number. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Speed Dial Num
| Description | The characters established within a company's internal telephone system used in place of the (external) telephone number to facilitate calling because its length is shorter than that of the telephone number. Note that digits, as well as special characters (for example, *, #) may be used. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Telephone Equipment Type
| Description | Indicates the kind of telephone represented by the number. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Telephone Exchange Code
| Description | Indicates the telephone exchange code for the telephone, cell, or pager number. For US telephone numbers the exchange code or Central Office Code refers to the first 3 digits of the local number (NNN-xxxx). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Phone_User_FK
| Is Identifying Relationship | false |
| Child Table | Phone |
| Child Role Name | is contact phone |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | User |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |