Tables [dbo].[Person_Phone]
This table contains the various telephone numbers associated to Patient, Provider and Users
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Person_Phone_ID_PhoneType: ID\PhoneTypeIndexes TWstat_Person_Phone_PhoneArea_ID_PhoneLast4, TWstat_Person_Phone_PhoneExchange_ID_PhoneLast4, TWstat_Person_Phone_PhoneInternational_ID_PhoneLast4, TWstat_Person_Phone_PhoneLast4_ID, TWstat_Person_Phone_PhoneType_ID_PhoneLast4(5)Foreign Keys FK_Person_Phone_ID_Person_ID: [dbo].[Person].IDIDnumeric(16,0)9NOT NULLIdentifier 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
Cluster Primary Key PK_Person_Phone_ID_PhoneType: ID\PhoneTypeIndexes TWstat_Person_Phone_PhoneType_ID_PhoneLast4Check 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')PhoneTypevarchar(10)10NOT NULLThis contains the type of telephone number ([PhoneType]='Cell' OR [PhoneType]='Mailing' OR [PhoneType]='Fax' OR [PhoneType]='Work' OR [PhoneType]='Home')
Indexes NIX_Person_Phone_PhoneLast4_INC_PhoneArea_PhoneExchange, TWstat_Person_Phone_PhoneArea_ID_PhoneLast4(2)PhoneAreasmallint2NOT NULLthis contains the telephone area code
Indexes NIX_Person_Phone_PhoneLast4_INC_PhoneArea_PhoneExchange, TWstat_Person_Phone_PhoneExchange_ID_PhoneLast4(2)PhoneExchangesmallint2NOT NULLthis contains the telephone exchange
Indexes NIX_Person_Phone_PhoneLast4_INC_PhoneArea_PhoneExchange, TWstat_Person_Phone_PhoneArea_ID_PhoneLast4, TWstat_Person_Phone_PhoneExchange_ID_PhoneLast4, TWstat_Person_Phone_PhoneInternational_ID_PhoneLast4, TWstat_Person_Phone_PhoneLast4_ID, TWstat_Person_Phone_PhoneType_ID_PhoneLast4(6)PhoneLast4smallint2NOT NULLThis contains the last 4 digits of the telephone number
PhoneExtensionvarchar(8)8NOT NULLThis contains the extension for anumber that is located in an office
Indexes TWstat_Person_Phone_PhoneInternational_ID_PhoneLast4PhoneInternational[dbo].[int_phone]21NOT NULL('')This contains an international telephone number