Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PatientID | int | 4 | null |
|
|
Patient identifier - Unique identifier for the patient |
||
| patientName | varchar | 102 | √ | null |
|
|
Patient full name - Formatted patient name (Last, First) |
|
| patientStatus | varchar | 30 | √ | null |
|
|
Patient status - Current status of the patient in the system |
|
| admitID | int | 4 | null |
|
|
Admission identifier - Links to PatientAdministration for the patient case |
||
| caseID | int | 4 | √ | null |
|
|
Case identifier - Identifier for the patient case |
|
| CaseName | varchar | 255 | √ | null |
|
|
Case name - Descriptive name for the patient case |
|
| programTypeID | int | 4 | √ | null |
|
|
Program type reference - Links to the program type for this patient |
|
| caseOpenClosed | varchar | 10 | √ | null |
|
|
Case status - Indicates whether the case is open or closed |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when the patient case was created |
|
| siteID | int | 4 | √ | null |
|
|
Site reference - Links to the site where services are provided |
|
| patientLName | varchar | 50 | √ | null |
|
|
Patient last name - Patient’s last name for sorting and searching |
|
| patientFName | varchar | 50 | √ | null |
|
|
Patient first name - Patient’s first name for sorting and searching |
Relationships
Close relationships within degrees of separation
