Fields
Schema summary
DESCRIBE usergroup_member;
6.0
+----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| group_id | int(10) unsigned | NO | PRI | 0 | |
| user_id | int(10) unsigned | NO | PRI | 0 | |
+----------+------------------+------+-----+---------+-------+
Indices
SHOW INDEX IN usergroup_member;
+------------------------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wacko_usergroup_member | 0 | idx_group_id | 1 | group_id | A | 2 | NULL | NULL | | BTREE | | |
| wacko_usergroup_member | 0 | idx_group_id | 2 | user_id | A | 8 | NULL | NULL | | BTREE | | |
+------------------------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+