Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| amc_id | VARCHAR | 31 | '' |
|
|
Unique and maps to list_options list clinical_rules |
||
| pid | BIGINT | 19 | √ | NULL |
|
|
||
| map_category | VARCHAR | 255 | '' |
|
|
Maps to an object category (such as prescriptions etc.) |
||
| map_id | BIGINT | 19 | 0 |
|
|
Maps to an object id (such as prescription id etc.) |
||
| date_created | DATETIME | 19 | √ | NULL |
|
|
||
| date_completed | DATETIME | 19 | √ | NULL |
|
|
||
| soc_provided | DATETIME | 19 | √ | NULL |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| amc_id | Performance | Asc/Asc/Asc | amc_id + pid + map_id |