Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| PatientContactID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for the patient contact record |
||||
| ContactType | int | 4 | √ | null |
|
|
Contact type - Foreign key linking to contact type definition (Parent, Guardian, Emergency Contact, etc.) |
||||
| ContactFirstName | varchar | 50 | null |
|
|
Contact first name - First name of the patient’s contact person |
|||||
| ContactLastName | varchar | 50 | null |
|
|
Contact last name - Last name of the patient’s contact person |
|||||
| ContactAddress | varchar | 50 | √ | null |
|
|
Contact address - Primary street address of the contact person |
||||
| ContactState | varchar | 50 | √ | null |
|
|
Contact state - State or province where the contact person resides |
||||
| ContactCity | varchar | 50 | √ | null |
|
|
Contact city - City where the contact person resides |
||||
| ContactZip | varchar | 10 | √ | null |
|
|
Contact ZIP code - Postal code for the contact person’s address |
||||
| ContactPhone | nvarchar | 128 | √ | null |
|
|
Contact phone - Primary phone number for the contact person |
||||
| ContactWorkPhone | nvarchar | 128 | √ | null |
|
|
Contact work phone - Work phone number for the contact person |
||||
| ContactWorkExt | int | 4 | √ | null |
|
|
Contact work extension - Work phone extension number |
||||
| ContactFax | nvarchar | 128 | √ | null |
|
|
Contact fax - Fax number for the contact person |
||||
| ContactCell | nvarchar | 128 | √ | null |
|
|
Contact cell phone - Mobile phone number for the contact person |
||||
| ContactBeeper | varchar | 15 | √ | null |
|
|
Contact beeper - Pager or beeper number for the contact person |
||||
| ContactComments | varchar | 1000 | √ | null |
|
|
Contact comments - Additional notes or special instructions about the contact |
||||
| PatientID | int | 4 | null |
|
|
Patient foreign key - Links to the patient this contact is associated with |
|||||
| Prim_Type | int | 4 | √ | null |
|
|
Primary type - Indicates if this is the primary contact of this type |
||||
| Legal_Type | int | 4 | √ | null |
|
|
Legal type - Indicates legal relationship or authority (Legal Guardian, Power of Attorney, etc.) |
||||
| ContactSex | varchar | 20 | √ | null |
|
|
Contact gender - Gender of the contact person |
||||
| caseID | int | 4 | √ | null |
|
|
Case foreign key - Links to specific case if contact is case-specific |
||||
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Timestamp when the contact record was created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - User ID of the person who created the contact record |
||||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update date - Timestamp when the contact record was last modified |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - User ID of the person who last modified the contact record |
||||
| ContactAddress2 | varchar | 50 | √ | null |
|
|
Contact address line 2 - Secondary address line (apartment, suite, etc.) |
||||
| varchar | 100 | √ | null |
|
|
Contact email - Email address for the contact person |
|||||
| UseAddressFromCase | bit | 1 | √ | null |
|
|
Use case address - Flag indicating whether to use the case address instead of contact-specific address |
||||
| CreateGuardianFromContact | bit | 1 | √ | null |
|
|
Create guardian flag - Flag indicating whether to automatically create a guardian record from this contact |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PatientContact | Primary key | Asc | PatientContactID |
Relationships
Close relationships within degrees of separation
