Server: mysql.puroparty.com | Database: puroparty | Table: phorum_user_group_xref |
Field | Type | Null | Default |
---|---|---|---|
user_id | int(11) | No | 0 |
group_id | int(11) | No | 0 |
status | tinyint(3) | No | 1 |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 0 | user_id | |
group_id | ||||
user_id_2 | UNIQUE | 0 | user_id | |
group_id_2 | UNIQUE | 0 | group_id | |
status_2 | UNIQUE | 0 | status | |
group_id_4 | UNIQUE | 0 | group_id | |
user_id_4 | UNIQUE | 0 | user_id | |
status_3 | UNIQUE | 0 | status | |
group_id_5 | UNIQUE | 0 | group_id | |
user_id_5 | UNIQUE | 0 | user_id | |
status_5 | UNIQUE | 0 | status | |
status_7 | UNIQUE | 0 | status | |
group_id_8 | UNIQUE | 0 | group_id | |
user_id_7 | UNIQUE | 0 | user_id | |
status_9 | UNIQUE | 0 | status | |
user_id_9 | UNIQUE | 0 | user_id | |
status_10 | UNIQUE | 0 | status | |
group_id_11 | UNIQUE | 0 | group_id | |
user_id_12 | UNIQUE | 0 | user_id | |
group_id_12 | UNIQUE | 0 | group_id | |
user_id_14 | UNIQUE | 0 | user_id | |
group_id_14 | UNIQUE | 0 | group_id | |
status_13 | UNIQUE | 0 | status | |
status_14 | UNIQUE | 0 | status | |
status_15 | UNIQUE | 0 | status | |
user_id_15 | UNIQUE | 0 | user_id | |
user_id_16 | UNIQUE | 0 | user_id | |
user_id | INDEX | None | user_id | |
group_id | INDEX | None | group_id | |
status | INDEX | None | status | |
group_id_3 | INDEX | None | group_id | |
user_id_3 | INDEX | None | user_id | |
status_4 | INDEX | None | status | |
group_id_6 | INDEX | None | group_id | |
user_id_6 | INDEX | None | user_id | |
status_6 | INDEX | None | status | |
group_id_7 | INDEX | None | group_id | |
user_id_8 | INDEX | None | user_id | |
status_8 | INDEX | None | status | |
group_id_9 | INDEX | None | group_id | |
group_id_10 | INDEX | None | group_id | |
user_id_10 | INDEX | None | user_id | |
user_id_11 | INDEX | None | user_id | |
status_11 | INDEX | None | status | |
user_id_13 | INDEX | None | user_id | |
group_id_13 | INDEX | None | group_id | |
status_12 | INDEX | None | status | |
group_id_15 | INDEX | None | group_id | |
status_16 | INDEX | None | status |
Space usage :
|
Row Statistic :
|