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 |
|
|
||||
dss_update_time | datetime | 16,3 | √ | null |
|
|