direct_message_log

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

Relationships

Close relationships within degrees of separation