Fields (4)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | NULL | auto_increment |
| mailID | int(11) | NO | MUL | NULL | |
| mediaID | int(11) | NO | MUL | NULL | |
| shopID | int(11) | YES | MUL | 0 |
Indexes (4)
| Name | Columns | Unique |
|---|---|---|
| mailID | mailID,mediaID,shopID | Yes |
| mediaID | mediaID | No |
| PRIMARY | id | Yes |
| shopID | shopID | No |