Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | null |
|
|
||||||
date | DATETIME | 19 | √ | null |
|
|
|||||
pid | BIGINT | 19 | √ | null |
|
|
The internal patient identifier |
||||
encounter | VARCHAR | 255 | √ | null |
|
|
|||||
user | VARCHAR | 255 | √ | null |
|
|
|||||
groupname | VARCHAR | 255 | √ | null |
|
|
|||||
TINYINT | 3 | √ | null |
|
|
||||||
activity | TINYINT | 3 | √ | null |
|
|
|||||
code | VARCHAR | 255 | √ | null |
|
|
|||||
codetext | TEXT | 65535 | √ | null |
|
|
|||||
description | TEXT | 65535 | √ | null |
|
|
|||||
external_id | VARCHAR | 30 | √ | null |
|
|
|||||
care_plan_type | VARCHAR | 30 | √ | null |
|
|
|||||
TEXT | 65535 | √ | null |
|
|
||||||
date_end | DATETIME | 19 | √ | null |
|
|
|||||
reason_code | VARCHAR | 31 | √ | null |
|
|
|||||
reason_description | TEXT | 65535 | √ | null |
|
|
|||||
reason_date_low | DATETIME | 19 | √ | null |
|
|
The date the reason was recorded |
||||
reason_date_high | DATETIME | 19 | √ | null |
|
|
The date the explanation reason for the care plan entry value ends |
||||
reason_status | VARCHAR | 31 | √ | null |
|
|