Documentation/EHI_Export/docs/tables/issue_encounter.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
| | | pid | BIGINT | 19 | | | null |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | list_id | INT | 10 | | | null |
|
| lists.id | Defined in XML | R |
|
Represents the specific medical issue (allergy,surgery,etc) this encounter is linked to
| | encounter | INT | 10 | | | null |
|
| form_encounter.encounter | Defined in XML | R |
|
References form_encounter.encounter, representing the encounter that is connected to the issue
| | resolved | BOOLEAN | 3 | | | null |
|
|
0=Issue not resolved,1=Issue is resolved
| | uuid | BINARY | 16 | √ | | NULL |
|
|
UUID for this issue encounter record, for data exchange purposes
| | created_by | BIGINT | 19 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
fk to users.id for the user that entered in the issue encounter data
| | updated_by | BIGINT | 19 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
fk to users.id for the user that last updated the issue encounter data
| | created_at | DATETIME | 19 | √ | | current_timestamp() |
|
|
timestamp when this issue encounter record was created
| | updated_at | DATETIME | 19 | √ | | current_timestamp() |
|
|
timestamp when this issue encounter record was last updated
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| uniq_issue_key | Must be unique | Asc/Asc/Asc | pid + list_id + encounter |
| uuid_unique | Must be unique | Asc | uuid |