medex_outgoing

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
msg_uid	INT	10		√	null

|

| | | msg_pid | INT | 10 | | | null |

|

| | | msg_pc_eid | VARCHAR | 11 | | | null |

|

| | | campaign_uid | INT | 10 | | | 0 |

|

| | | msg_date | TIMESTAMP | 19 | | | current_timestamp() |

|

| | | msg_type | VARCHAR | 50 | | | null |

|

| | | msg_reply | VARCHAR | 50 | √ | | NULL |

|

| | | msg_extra_text | TEXT | 65535 | √ | | NULL |

|

| | | medex_uid | INT | 10 | √ | | NULL |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	msg_uid
msg_eid	Must be unique	Asc/Asc/Asc	msg_uid + msg_pc_eid + medex_uid

Relationships

Close relationships within degrees of separation