mysql.puroparty.com
puroparty
phorum_pm_xref
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: phorum_pm_xref
|
| Field | Type | Null | Default |
|---|---|---|---|
| pm_xref_id | int(10) | No | |
| user_id | int(10) | No | 0 |
| pm_folder_id | int(10) | No | 0 |
| special_folder | varchar(10) | Yes | NULL |
| pm_message_id | int(10) | No | 0 |
| read_flag | tinyint(1) | No | 0 |
| reply_flag | tinyint(1) | No | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 0 | pm_xref_id | |
| pm_xref_id_2 | UNIQUE | 0 | pm_xref_id | |
| user_id_2 | UNIQUE | 0 | user_id | |
| pm_folder_id_2 | UNIQUE | 0 | pm_folder_id | |
| pm_message_id_2 | UNIQUE | 0 | pm_message_id | |
| read_flag_3 | UNIQUE | 0 | read_flag | |
| reply_flag_2 | UNIQUE | 0 | reply_flag | |
| reply_flag_3 | UNIQUE | 0 | reply_flag | |
| user_id_4 | UNIQUE | 0 | user_id | |
| pm_folder_id_3 | UNIQUE | 0 | pm_folder_id | |
| pm_message_id_4 | UNIQUE | 0 | pm_message_id | |
| pm_xref_id_4 | UNIQUE | 0 | pm_xref_id | |
| read_flag_5 | UNIQUE | 0 | read_flag | |
| pm_message_id_5 | UNIQUE | 0 | pm_message_id | |
| read_flag_6 | UNIQUE | 0 | read_flag | |
| pm_folder_id_6 | UNIQUE | 0 | pm_folder_id | |
| user_id_6 | UNIQUE | 0 | user_id | |
| reply_flag_6 | UNIQUE | 0 | reply_flag | |
| pm_xref_id_6 | UNIQUE | 0 | pm_xref_id | |
| pm_message_id_7 | UNIQUE | 0 | pm_message_id | |
| user_id_7 | UNIQUE | 0 | user_id | |
| reply_flag_7 | UNIQUE | 0 | reply_flag | |
| pm_folder_id_8 | UNIQUE | 0 | pm_folder_id | |
| read_flag_9 | UNIQUE | 0 | read_flag | |
| pm_xref_id_8 | UNIQUE | 0 | pm_xref_id | |
| user_id_9 | UNIQUE | 0 | user_id | |
| special_folder_2 | UNIQUE | None | special_folder | |
| special_folder_5 | UNIQUE | None | special_folder | |
| special_folder_8 | UNIQUE | None | special_folder | |
| special_folder_10 | UNIQUE | None | special_folder | |
| xref | INDEX | None | user_id | |
| pm_folder_id | ||||
| pm_message_id | ||||
| read_flag | INDEX | None | read_flag | |
| pm_xref_id | INDEX | None | pm_xref_id | |
| user_id | INDEX | None | user_id | |
| pm_folder_id | INDEX | None | pm_folder_id | |
| special_folder | INDEX | None | special_folder | |
| pm_message_id | INDEX | None | pm_message_id | |
| read_flag_2 | INDEX | None | read_flag | |
| reply_flag | INDEX | None | reply_flag | |
| pm_xref_id_3 | INDEX | None | pm_xref_id | |
| read_flag_4 | INDEX | None | read_flag | |
| pm_message_id_3 | INDEX | None | pm_message_id | |
| user_id_3 | INDEX | None | user_id | |
| pm_folder_id_4 | INDEX | None | pm_folder_id | |
| special_folder_6 | INDEX | None | special_folder | |
| reply_flag_4 | INDEX | None | reply_flag | |
| pm_xref_id_5 | INDEX | None | pm_xref_id | |
| special_folder_7 | INDEX | None | special_folder | |
| user_id_5 | INDEX | None | user_id | |
| pm_folder_id_5 | INDEX | None | pm_folder_id | |
| reply_flag_5 | INDEX | None | reply_flag | |
| pm_message_id_6 | INDEX | None | pm_message_id | |
| read_flag_7 | INDEX | None | read_flag | |
| pm_folder_id_7 | INDEX | None | pm_folder_id | |
| pm_message_id_8 | INDEX | None | pm_message_id | |
| read_flag_8 | INDEX | None | read_flag | |
| user_id_8 | INDEX | None | user_id | |
| pm_xref_id_7 | INDEX | None | pm_xref_id | |
| special_folder_12 | INDEX | None | special_folder | |
| reply_flag_8 | INDEX | None | reply_flag | |
| special_folder_3 | INDEX | None | special_folder | |
| special_folder_4 | INDEX | None | special_folder | |
| special_folder_9 | INDEX | None | special_folder | |
| special_folder_11 | INDEX | None | special_folder | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||