| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| amendment_id | INT | 10 | √ | null |
|
|
Primary key for the amendment record. It uniquely identifies each amendment. |
||||
| amendment_date | DATE | 10 | null |
|
|
The date when the amendment request was made. |
|||||
| amendment_by | VARCHAR | 50 | null |
|
|
Comes from the list_options.list_id=‘amendment_from’ and represents who is requesting the amendment |
|||||
| amendment_status | VARCHAR | 50 | √ | NULL |
|
|
Comes from the list_options.list_id=‘amendment_status’ and represents the current status of the amendment |
||||
| pid | BIGINT | 19 | null |
|
|
The internal patient identifier |
|||||
| amendment_desc | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
Detailed information about the amendment, including any additional notes or changes. |
||||
| created_by | INT | 10 | null |
|
|
The id of the user that initially created this amendment |
|||||
| modified_by | INT | 10 | √ | NULL |
|
|
The id of the user that last modified this amendment |
||||
| created_time | TIMESTAMP | 19 | √ | NULL |
|
|
Timestamp indicating when the amendment record was created. |
||||
| modified_time | TIMESTAMP | 19 | √ | NULL |
|
|
Timestamp indicating when the amendment record was last modified. |
Showing 1 to 10 of 10 entries