PHONENUMBER
The PHONENUMBER table contains a contact's phone number.
This table is used by the following domain.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| PHONE_NUMBER_ID | A unique, system-generated key that identifies a phone number in the system. | BIGINT | Not Null | Yes |
| COUNTRY_CODE | The part of the phone number that represents the country. | VARCHAR(4) | Null | No |
| AREA_CODE | The part of the phone number that represents the area (finer grained than country). In North America, for example, it would be the '905' portion of (905) 555-1234. Germany can have 2 to 5 digits in their area code. | VARCHAR(6) | Null | No |
| EXCHANGE | The part of the phone number that represents the exchange (finer grained area than the area code). In North America, for example, it would be the '555' portion of (905) 555-1234. | VARCHAR(6) | Null | No |
| PH_NUMBER | The part of the phone number that represents the local number. In North America, for example, it would be the '1234' portion of (905) 555-1234. | VARCHAR(20) | Null | No |
| EXTENSION | The part of the phone number that represents the extension (typically applicable for business phone numbers). It would be the '56789' portion of (905) 555-1234 ext. 56789. | VARCHAR(8) | Null | No |
| LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
| LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
| LAST_UPDATE_TX_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |
| CONTACT_METHOD_ID | A unique, system-generated key that identifies a contact method in the system. | BIGINT | Not Null | No |