| 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 | '' |
|
|
Maps to list_options list rule_reminder_inactive_opt |
|||||
| due_status | VARCHAR | 31 | '' |
|
|
Maps to list_options list rule_reminder_due_opt |
|||||
| pid | BIGINT | 19 | null |
|
|
The internal patient identifier |
|||||
| category | VARCHAR | 31 | '' |
|
|
Maps to the category item in the rule_action_item table |
|||||
| item | VARCHAR | 31 | '' |
|
|
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 |
Showing 1 to 14 of 14 entries