Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each custom user-patient relationship record |
|
| fkAccessUserPatientID | int | 4 | null |
|
|
User-patient assignment reference - Links to AccessUserPatient table for the base assignment relationship |
||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - Date and time when the custom relationship record was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this custom relationship record |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update timestamp - Date and time of the most recent update to the relationship record |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified this relationship record |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - Soft delete date for audit trail and data recovery purposes |
|
| PrimaryGuardian | bit | 1 | √ | null |
|
|
Primary guardian flag - Boolean indicator if this person is the primary guardian or decision-maker for the patient |
|
| Paysource | bit | 1 | √ | null |
|
|
Payment responsibility flag - Boolean indicator if this person is responsible for payment or billing matters |
|
| Relationship | nvarchar | 200 | √ | null |
|
|
Relationship type - Description of the relationship between the user and patient (parent, guardian, caregiver, etc.) |
|
| AllowToPickup | bit | 1 | √ | null |
|
|
Pickup authorization - Boolean flag indicating if this person is authorized to pick up the patient from services |
|
| EmergencyContact | bit | 1 | √ | null |
|
|
Emergency contact flag - Boolean indicator if this person should be contacted in case of emergencies |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AccessUserPatientCustom | Primary key | Asc | pkID |
Relationships
Close relationships within degrees of separation
