Fields (13)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | NULL | auto_increment |
| articleID | int(11) | YES | MUL | NULL | |
| img | varchar(255) | YES | NULL | ||
| main | int(1) | NO | NULL | ||
| description | varchar(255) | NO | NULL | ||
| position | int(11) | NO | NULL | ||
| width | int(11) | NO | NULL | ||
| height | int(11) | NO | NULL | ||
| relations | mediumtext | NO | NULL | ||
| extension | varchar(255) | NO | NULL | ||
| parent_id | int(10) unsigned | YES | MUL | NULL | |
| article_detail_id | int(10) unsigned | YES | MUL | NULL | |
| media_id | int(10) unsigned | YES | MUL | NULL |
Indexes (7)
| Name | Columns | Unique |
|---|---|---|
| article_cover_image_query | articleID,main,position | No |
| article_detail_id | article_detail_id | No |
| article_images_query | articleID,position | No |
| artikel_id | articleID | No |
| media_id | media_id | No |
| parent_id | parent_id | No |
| PRIMARY | id | Yes |