Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each special condition record |
|
| fkAdmitID | int | 4 | √ | null |
|
|
Admission reference - Links to patient admission or case that has this special condition |
|
| SpecialConditionName | nvarchar | 1073741823 | √ | null |
|
|
Condition name - Name or title of the special condition or accommodation |
|
| Description | nvarchar | 1073741823 | √ | null |
|
|
Condition description - Detailed description of the special condition, requirements, or accommodations needed |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the special condition was documented |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update date - Date when the special condition was last modified |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who documented the special condition |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the special condition |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the special condition was deleted (soft delete) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_SpecialConditions | Primary key | Asc | pkID |
Relationships
Close relationships within degrees of separation
