Documentation/EHI_Export/docs/tables/form_CAMOS.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
| | | date | DATETIME | 19 | √ | | NULL |
|
| | | pid | BIGINT | 19 | √ | | NULL |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | user | VARCHAR | 255 | √ | | NULL |
|
| | | groupname | VARCHAR | 255 | √ | | NULL |
|
| | | authorized | TINYINT | 3 | √ | | NULL |
|
| | | activity | TINYINT | 3 | √ | | NULL |
|
| | | category | TEXT | 65535 | √ | | NULL |
|
| form_CAMOS_category.category | Defined in XML | R |
|
The category that this note is based upon
| | subcategory | TEXT | 65535 | √ | | NULL |
|
| form_CAMOS_item.item | Defined in XML | R |
|
The CAMOS subcategory template that this note is based on
| | item | TEXT | 65535 | √ | | NULL |
|
| form_CAMOS_item.item | Defined in XML | R |
|
The CAMOS item template that this note is based on
| | content | TEXT | 65535 | √ | | NULL |
|
|
The actual chart note text that was entered in for the patient
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |