Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each allergy record |
|
| fkAdmitID | int | 4 | √ | null |
|
|
Admission reference - Links to the patient admission or case where this allergy was documented |
|
| AllergieName | nvarchar | 1073741823 | √ | null |
|
|
Allergy name - Name or type of the allergy (medication, food, environmental, etc.) |
|
| Description | nvarchar | 1073741823 | √ | null |
|
|
Allergy description - Detailed description of the allergy including symptoms, severity, and reactions |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date and time when the allergy record was created |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date and time of the last modification to the allergy record |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the healthcare provider who documented this allergy |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the healthcare provider who last modified this allergy record |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail and data recovery purposes |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Allergies | Primary key | Asc | pkID |
Relationships
Close relationships within degrees of separation
