Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CreatedBy | Unknown | 0 | null |
|
|
Creator user ID - User who created the association |
||
| DateCreated | Unknown | 0 | null |
|
|
Creation timestamp - When the association was created |
||
| DiagId | int | 4 | √ | null |
|
|
Diagnosis identifier - Alternative identifier for the diagnosis |
|
| DiagnosisId | Unknown | 0 | null |
|
|
Diagnosis reference - Reference to the patient diagnosis |
||
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each diagnosis-service association |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if association is currently active |
||
| PatientId | Unknown | 0 | null |
|
|
Patient reference - Reference to the patient |
||
| ServiceTypeId | int | 4 | √ | null |
|
|
Service type reference - Reference to the associated service type |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__PatientD__3214EC275A846E65 | Primary key | Asc | ID |