Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (5)![Foreign Keys FK_Person_Phone_ID_Person_ID: [dbo].[Person].ID Foreign Keys FK_Person_Phone_ID_Person_ID: [dbo].[Person].ID](../../../../Images/fk.png) | ID | numeric(16,0) | 9 | NOT NULL | | Identifier for this record that points to the ID in the Person table. This value combined with the PhoneType form a unique key for the record |
  ![Check Constraints CK_Person_Phone_PhoneType_PhoneType : ([PhoneType]='Perm Cell' OR [PhoneType]='Perm Fax' OR [PhoneType]='Perm Work' OR [PhoneType]='Perm Home' OR [PhoneType]='Home' OR [PhoneType]='Work' OR [PhoneType]='Fax' OR [PhoneType]='Mailing' OR [PhoneType]='Cell') Check Constraints CK_Person_Phone_PhoneType_PhoneType : ([PhoneType]='Perm Cell' OR [PhoneType]='Perm Fax' OR [PhoneType]='Perm Work' OR [PhoneType]='Perm Home' OR [PhoneType]='Home' OR [PhoneType]='Work' OR [PhoneType]='Fax' OR [PhoneType]='Mailing' OR [PhoneType]='Cell')](../../../../Images/c-constraint.png) | PhoneType | varchar(10) | 10 | NOT NULL | | This contains the type of telephone number ([PhoneType]='Cell' OR [PhoneType]='Mailing' OR [PhoneType]='Fax' OR [PhoneType]='Work' OR [PhoneType]='Home') |
(2) | PhoneArea | smallint | 2 | NOT NULL | | this contains the telephone area code |
(2) | PhoneExchange | smallint | 2 | NOT NULL | | this contains the telephone exchange |
(6) | PhoneLast4 | smallint | 2 | NOT NULL | | This contains the last 4 digits of the telephone number |
| PhoneExtension | varchar(8) | 8 | NOT NULL | | This contains the extension for anumber that is located in an office |
 | PhoneInternational | [dbo].[int_phone] | 21 | NOT NULL | ('') | This contains an international telephone number |