Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (6)![Foreign Keys FK_Patient_Contact_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Patient_Contact_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | Patient. Link to Person.ID |
 ![Foreign Keys FK_Patient_Contact_RelationshipDE_Relationship_DE_ID: [dbo].[Relationship_DE].RelationshipDE Foreign Keys FK_Patient_Contact_RelationshipDE_Relationship_DE_ID: [dbo].[Relationship_DE].RelationshipDE](../../../../Images/fk.png) | RelationshipDE | [dbo].[dict_id] | 5 | NOT NULL | | The relationship to the Patient - FK to the Relationship_DE.ID |
 | LastName | varchar(35) | 35 | NOT NULL | | The last name of the Contact |
 | FirstName | varchar(35) | 35 | NOT NULL | | The First name of the Contact |
| HomePhoneArea | smallint | 2 | NULL allowed | | The Home telephone Area Code |
| HomePhoneExchange | smallint | 2 | NULL allowed | | The Home telephone 3 digit exchange |
 | HomePhoneLast4 | smallint | 2 | NULL allowed | | The Home telephone last 4 digits |
| HomePhoneInternational | [dbo].[int_phone] | 21 | NULL allowed | | Internation Home telephone number if contact is international |
| WorkPhoneArea | smallint | 2 | NULL allowed | | The Work telephone Area Code |
 | WorkPhoneExchange | smallint | 2 | NULL allowed | | The Work telephone 3 digit exchange |
| WorkPhoneLast4 | smallint | 2 | NULL allowed | | The Work telephone last 4 digits |
| WorkPhoneInternational | [dbo].[int_phone] | 21 | NULL allowed | | Internation Work telephone number if contact is international |
| WorkPhoneExtension | [dbo].[extension] | 5 | NULL allowed | | The Work telephone Extension |
| AddressLine1 | varchar(255) | 255 | NULL allowed | | The First address Line |
| AddressLine2 | varchar(255) | 255 | NULL allowed | | The second address line |
 (6) | ContactType | varchar(1) | 1 | NOT NULL | | Contact type of E = Emergency G = Guarantor). The ContactType and the PatientID make up the PK for the record |
| DateofBirth | datetime | 8 | NOT NULL | ('1/1/1900') | Contact date of Birth |
 ![Foreign Keys FK_Patient_Contact_Sex_DE: [dbo].[Sex_DE].SexDE Foreign Keys FK_Patient_Contact_Sex_DE: [dbo].[Sex_DE].SexDE](../../../../Images/fk.png) | SexDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Contact Gender - FK Sex_DE.ID |
| SSN | varchar(11) | 11 | NOT NULL | ('') | Contact Social Security Number |
| City | varchar(35) | 35 | NOT NULL | ('') | Contact City |
| State | varchar(15) | 15 | NOT NULL | ('') | Contact State |
| Zip | varchar(10) | 10 | NOT NULL | ('') | Contact Zipcode |
| HomePhoneExtension | [dbo].[extension] | 5 | NULL allowed | | The Home telephone number extension |