Messaging.messages_access_new
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| mxs_id | int(11) | NO | PRI | auto_increment | ||
| mxs_cus_id | int(11) | NO | MUL | |||
| mxs_cli_id | int(11) | NO | MUL | |||
| mxs_usr_id | int(11) | NO | MUL | |||
| mxs_usr_type | char(1) | NO | MUL | |||
| mxs_msg_id | int(11) | NO | MUL | |||
| mxs_thread_id | int(11) | NO | MUL | |||
| mxs_ml_id | int(11) | NO | MUL | |||
| mxs_comp_type | int(11) | NO | MUL | |||
| mxs_grp_id | int(11) | NO | MUL | |||
| mxs_mrt_type | int(11) | NO | MUL | |||
| mxs_starred | char(1) | NO | MUL | |||
| mxs_deleted | char(1) | NO | MUL | |||
| mxs_read | char(1) | NO | MUL | |||
| mxs_time | varchar(45) | NO | ||||
| mxs_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| mxs_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References |
|---|