mysql.puroparty.com
puroparty
phorum_subscribers
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: phorum_subscribers
|
| Field | Type | Null | Default |
|---|---|---|---|
| user_id | int(10) | No | 0 |
| forum_id | int(10) | No | 0 |
| sub_type | int(10) | No | 0 |
| thread | int(10) | No | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 0 | user_id | |
| forum_id | ||||
| thread | ||||
| user_id_2 | UNIQUE | 0 | user_id | |
| forum_id_3 | UNIQUE | 0 | forum_id | |
| sub_type_2 | UNIQUE | 0 | sub_type | |
| thread_2 | UNIQUE | 0 | thread | |
| sub_type_3 | UNIQUE | 0 | sub_type | |
| forum_id_4 | UNIQUE | 0 | forum_id | |
| user_id_4 | UNIQUE | 0 | user_id | |
| thread_4 | UNIQUE | 0 | thread | |
| thread_5 | UNIQUE | 0 | thread | |
| forum_id_6 | UNIQUE | 0 | forum_id | |
| sub_type_5 | UNIQUE | 0 | sub_type | |
| user_id_6 | UNIQUE | 0 | user_id | |
| forum_id_8 | UNIQUE | 0 | forum_id | |
| sub_type_7 | UNIQUE | 0 | sub_type | |
| user_id_8 | UNIQUE | 0 | user_id | |
| thread_8 | UNIQUE | 0 | thread | |
| sub_type_10 | UNIQUE | 0 | sub_type | |
| user_id_9 | UNIQUE | 0 | user_id | |
| forum_id_11 | UNIQUE | 0 | forum_id | |
| thread_11 | UNIQUE | 0 | thread | |
| forum_id_13 | UNIQUE | 0 | forum_id | |
| sub_type_11 | UNIQUE | 0 | sub_type | |
| user_id_12 | UNIQUE | 0 | user_id | |
| user_id_14 | UNIQUE | 0 | user_id | |
| forum_id_15 | UNIQUE | 0 | forum_id | |
| sub_type_13 | UNIQUE | 0 | sub_type | |
| thread_13 | UNIQUE | 0 | thread | |
| thread_14 | UNIQUE | 0 | thread | |
| forum_id_16 | UNIQUE | 0 | forum_id | |
| forum_id_18 | UNIQUE | 0 | forum_id | |
| forum_id | INDEX | None | forum_id | |
| thread | ||||
| sub_type | ||||
| user_id | INDEX | None | user_id | |
| forum_id_2 | INDEX | None | forum_id | |
| sub_type | INDEX | None | sub_type | |
| thread | INDEX | None | thread | |
| user_id_3 | INDEX | None | user_id | |
| forum_id_5 | INDEX | None | forum_id | |
| thread_3 | INDEX | None | thread | |
| sub_type_4 | INDEX | None | sub_type | |
| user_id_5 | INDEX | None | user_id | |
| forum_id_7 | INDEX | None | forum_id | |
| sub_type_6 | INDEX | None | sub_type | |
| thread_6 | INDEX | None | thread | |
| thread_7 | INDEX | None | thread | |
| forum_id_9 | INDEX | None | forum_id | |
| user_id_7 | INDEX | None | user_id | |
| sub_type_8 | INDEX | None | sub_type | |
| forum_id_10 | INDEX | None | forum_id | |
| thread_9 | INDEX | None | thread | |
| sub_type_9 | INDEX | None | sub_type | |
| thread_10 | INDEX | None | thread | |
| user_id_10 | INDEX | None | user_id | |
| forum_id_12 | INDEX | None | forum_id | |
| user_id_11 | INDEX | None | user_id | |
| user_id_13 | INDEX | None | user_id | |
| forum_id_14 | INDEX | None | forum_id | |
| sub_type_12 | INDEX | None | sub_type | |
| thread_12 | INDEX | None | thread | |
| sub_type_14 | INDEX | None | sub_type | |
| thread_15 | INDEX | None | thread | |
| user_id_15 | INDEX | None | user_id | |
| forum_id_17 | INDEX | None | forum_id | |
| thread_16 | INDEX | None | thread | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||