Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||
| msg_type | CHAR | 1 | null |
|
|
S=sent,R=received |
||
| msg_id | VARCHAR | 127 | null |
|
|
|||
| sender | VARCHAR | 255 | null |
|
|
|||
| recipient | VARCHAR | 255 | null |
|
|
|||
| create_ts | TIMESTAMP | 19 | current_timestamp() |
|
|
|||
| status | CHAR | 1 | null |
|
|
Q=queued,D=dispatched,R=received,F=failed |
||
| status_info | VARCHAR | 511 | √ | NULL |
|
|
||
| status_ts | TIMESTAMP | 19 | √ | NULL |
|
|
||
| patient_id | BIGINT | 19 | √ | NULL |
|
|
||
| user_id | BIGINT | 19 | √ | NULL |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| msg_id | Performance | Asc | msg_id |
| patient_id | Performance | Asc | patient_id |