Documentation/EHI_Export/docs/tables/patient_reminders.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
| | | active | BOOLEAN | 3 | | | 1 |
|
|
1 if active and 0 if not active
| | date_inactivated | DATETIME | 19 | √ | | NULL |
|
| | | reason_inactivated | VARCHAR | 31 | | | '' |
|
| list_options.option_id | Defined in XML | R |
|
Maps to list_options list rule_reminder_inactive_opt
| | due_status | VARCHAR | 31 | | | '' |
|
| list_options.option_id | Defined in XML | R |
|
Maps to list_options list rule_reminder_due_opt
| | pid | BIGINT | 19 | | | null |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | category | VARCHAR | 31 | | | '' |
|
| rule_action_item.category | Defined in XML | R |
|
Maps to the category item in the rule_action_item table
| | item | VARCHAR | 31 | | | '' |
|
| rule_action_item.item | Defined in XML | R |
|
Maps to the item column in the rule_action_item table
| | date_created | DATETIME | 19 | √ | | NULL |
|
| | | date_sent | DATETIME | 19 | √ | | NULL |
|
| | | voice_status | BOOLEAN | 3 | | | 0 |
|
|
0 if not sent and 1 if sent
| | sms_status | BOOLEAN | 3 | | | 0 |
|
|
0 if not sent and 1 if sent
| | email_status | BOOLEAN | 3 | | | 0 |
|
|
0 if not sent and 1 if sent
| | mail_status | BOOLEAN | 3 | | | 0 |
|
|
0 if not sent and 1 if sent
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| category | Performance | Asc/Asc | category + item |
| pid | Performance | Asc | pid |