Documentation/EHI_Export/docs/tables/rule_action_item.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| category | VARCHAR | 31 | '' |
| patient_reminders.category | Defined in XML | R | | rule_patient_data.category | Defined in XML | R |
|
| list_options.option_id | Defined in XML | R |
|
Maps to list_options list rule_action_category
| | item | VARCHAR | 31 | | | '' |
| patient_reminders.item | Defined in XML | R | | rule_patient_data.item | Defined in XML | R |
|
| list_options.option_id | Defined in XML | R |
|
Maps to list_options list rule_action
| | clin_rem_link | VARCHAR | 255 | | | '' |
|
|
Custom html link in clinical reminder widget
| | reminder_message | TEXT | 65535 | √ | | NULL |
|
|
Custom message in patient reminder
| | custom_flag | BOOLEAN | 3 | | | 0 |
|
|
1 indexed to rule_patient_data, 0 indexed within main schema
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | category + item |