| 12345678910 |
- -- 商品标签
- CREATE TABLE `goods_label` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `goods_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商品ID',
- `label_id` INT(11) NOT NULL DEFAULT '0' COMMENT '标签ID',
- PRIMARY KEY (`id`),
- INDEX `idx` (`goods_id`, `label_id`),
- INDEX `idx_goods_id` (`goods_id`),
- INDEX `idx_label_id` (`label_id`)
- ) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE='utf8mb4_unicode_ci' COMMENT='商品标签';
|
