Fields
Schema summary
DESCRIBE category;
+----------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+------------------+------+-----+---------+----------------+
| category_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| parent_id | int(10) unsigned | NO | | 0 | |
| category_lang | varchar(2) | NO | MUL | NULL | |
| category | varchar(100) | NO | | NULL | |
| category_description | varchar(255) | NO | | NULL | |
+----------------------+------------------+------+-----+---------+----------------+
Indices
SHOW INDEX IN category;
+--------------+------------+--------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+--------------+------------+--------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_category | 0 | PRIMARY | 1 | category_id | A | 11 | NULL | NULL | | BTREE | | |
| dev_category | 0 | idx_category | 1 | category_lang | A | 5 | NULL | NULL | | BTREE | | |
| dev_category | 0 | idx_category | 2 | category | A | 11 | NULL | NULL | | BTREE | | |
+--------------+------------+--------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+