Fields (6)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| articleId | int(11) unsigned | NO | MUL | NULL | |
| shopId | int(11) unsigned | NO | NULL | ||
| date | date | NO | 0000-00-00 | ||
| impressions | int(11) | NO | NULL | ||
| deviceType | varchar(50) | NO | desktop |
Indexes (3)
| Name | Columns | Unique |
|---|---|---|
| articleId | articleId | No |
| articleId_2 | articleId,shopId,date,deviceType | Yes |
| PRIMARY | id | Yes |