Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| created_by | Unknown | 0 | null |
|
|
The user that created this record |
|||||
| id | BIGINT | 19 | √ | null |
|
|
|||||
| list_id | BIGINT | 19 | √ | null |
|
|
The internal lists identifier |
||||
| drug_dosage_instructions | LONGTEXT | 2147483647 | √ | null |
|
|
Free text dosage instructions for taking the drug |
||||
| usage_category | VARCHAR | 100 | √ | null |
|
|
option_id in list_options.list_id=medication-usage-category |
||||
| usage_category_title | VARCHAR | 255 | null |
|
|
title in list_options.list_id=medication-usage-category |
|||||
| request_intent | VARCHAR | 100 | √ | null |
|
|
option_id in list_options.list_id=medication-request-intent |
||||
| request_intent_title | VARCHAR | 255 | null |
|
|
title in list_options.list_id=medication-request-intent |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| lists_med_request_intent_idx | Performance | Asc | request_intent |
| lists_med_usage_category_idx | Performance | Asc | usage_category |
| lists_medication_list_idx | Performance | Asc | list_id |