Documentation/EHI_Export/docs/tables/employer_data.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
| | | name | VARCHAR | 255 | √ | | NULL |
|
| | | street | VARCHAR | 255 | √ | | NULL |
|
| | | street_line_2 | TINYTEXT | 255 | √ | | NULL |
|
| | | postal_code | VARCHAR | 255 | √ | | NULL |
|
| | | city | VARCHAR | 255 | √ | | NULL |
|
| | | state | VARCHAR | 255 | √ | | NULL |
|
| | | country | VARCHAR | 255 | √ | | NULL |
|
| | | date | DATETIME | 19 | √ | | NULL |
|
| | | pid | BIGINT | 19 | | | 0 |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | start_date | DATETIME | 19 | √ | | NULL |
|
|
Employment start date for patient
| | end_date | DATETIME | 19 | √ | | NULL |
|
|
Employment end date for patient
| | occupation | LONGTEXT | 2147483647 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Employment Occupation fk to list_options.option_id where list_id=OccupationODH
| | industry | TEXT | 65535 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Employment Industry fk to list_options.option_id where list_id=IndustryODH
| | created_by | INT | 10 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
The id of the user that initially created this record
| | uuid | BINARY | 16 | √ | | NULL |
|
|
UUID for this employer record, for data exchange purposes
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| pid | Performance | Asc | pid |
| uuid_unique | Must be unique | Asc | uuid |