Fields (4)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| articleID | int(11) unsigned | NO | MUL | NULL | |
| categoryID | int(11) unsigned | NO | MUL | NULL | |
| parentCategoryID | int(11) unsigned | NO | NULL |
Indexes (7)
| Name | Columns | Unique |
|---|---|---|
| articleID | articleID,categoryID,parentCategoryID | Yes |
| articleID_2 | articleID | No |
| categoryID | categoryID | No |
| categoryID_2 | categoryID,parentCategoryID | No |
| category_id_by_article_id | articleID,id | No |
| elastic_search | categoryID,articleID | No |
| PRIMARY | id | Yes |