Documentation/EHI_Export/docs/tables/shared_attributes.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pid | BIGINT | 19 | null |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | encounter | BIGINT | 19 | | | null |
|
| form_encounter.encounter | Defined in XML | R |
|
0 if patient attribute, else this is an encounter attribute and references the form_encounter.encounter property
| | field_id | VARCHAR | 31 | | | null |
|
| layout_options.field_id | Defined in XML | R |
|
references layout_options.field_id and is the unique property name of this shared attribute
| | last_update | DATETIME | 19 | | | null |
|
|
time of last update
| | user_id | BIGINT | 19 | | | null |
|
| users.id | Defined in XML | R |
|
User who last updated this shared attribute
| | field_value | TEXT | 65535 | √ | | NULL |
|
| |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc | pid + encounter + field_id |