Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| clientdiagnosisid | int | 4 | √ | null |
|
|
||||
| facilityid | int | 4 | √ | null |
|
|
||||
| patientid | int | 4 | √ | null |
|
|
||||
| diagnosiscode | varchar | 15 | √ | null |
|
|
||||
| diagnosisdesc | varchar | 255 | √ | null |
|
|
||||
| classification | varchar | 254 | √ | null |
|
|
||||
| rank | varchar | 254 | √ | null |
|
|
||||
| onsetdate | datetime | 16,3 | √ | null |
|
|
||||
| resolveddate | datetime | 16,3 | √ | null |
|
|
||||
| struckout | varchar | 1 | √ | null |
|
|
||||
| createdby | varchar | 60 | √ | null |
|
|
||||
| createddate | datetime | 16,3 | √ | null |
|
|
||||
| revisionby | varchar | 60 | √ | null |
|
|
||||
| revisiondate | datetime | 16,3 | √ | null |
|
|
||||
| deleted | char | 1 | √ | null |
|
|
||||
| deletedby | varchar | 60 | √ | null |
|
|
||||
| deleteddate | datetime | 16,3 | √ | null |
|
|
||||
| icdversion | varchar | 50 | √ | null |
|
|
||||
| convertedfromdiagnosisid | int | 4 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
