Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each medical condition record |
|
| fkAdmitID | int | 4 | √ | null |
|
|
Admission reference - Links to PatientAdministration table for the patient case |
|
| MedicalName | nvarchar | 1073741823 | √ | null |
|
|
Medical condition name - Name or title of the medical condition or diagnosis |
|
| Description | nvarchar | 1073741823 | √ | null |
|
|
Condition description - Detailed description of the medical condition, symptoms, or diagnostic information |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - Date and time when the medical condition record was created |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update timestamp - Date and time when the medical condition record was last modified |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the healthcare provider who created this record |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updater reference - Links to AccessUser table for the healthcare provider who last updated this record |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - Date and time when the medical condition record was deleted |
|
| Link | nvarchar | 1073741823 | √ | null |
|
|
Related links - URLs or references to additional medical information, resources, or documentation |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_MedicalConditions | Primary key | Asc | pkID |
Relationships
Close relationships within degrees of separation
