Documentation/EHI_Export/docs/tables/amendments_history.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| amendment_id | INT | 10 | √ | null |
|
| amendments.amendment_id | Defined in XML | R |
|
The internal amendment id
| | amendment_note | TEXT | 65535 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comments regarding the amendment as entered by the creating user. Also contains a human readable description of the amendment status.
| | amendment_status | VARCHAR | 50 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘amendment_status’ and represents the current status of the amendment
| | created_by | INT | 10 | | | null |
|
| users.id | Defined in XML | R |
|
The id of the user that initially created this amendment
| | created_time | TIMESTAMP | 19 | √ | | NULL |
|
|
Timestamp indicating when the amendment record was created.
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| amendment_history_id | Performance | Asc | amendment_id |