Back to Openemr

direct_message_log

Documentation/EHI_Export/docs/tables/direct_message_log.html

latest1.1 KB
Original Source

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idBIGINT19null

|

| | | 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 NameTypeSortColumn(s)
PRIMARYPrimary keyAscid
msg_idPerformanceAscmsg_id
patient_idPerformanceAscpatient_id

Relationships

Close relationships within degrees of separation