评价表
CREATE TABLE `t_rating` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`order_id` int UNSIGNED NOT NULL COMMENT '订单ID',
`sku_id` int UNSIGNED NOT NULL COMMENT '商品ID',
`img` json NULL COMMENT '买家晒图',
`rating` tinyint UNSIGNED NOT NULL COMMENT '评分',
`comment` varchar(200) NULL COMMENT '评论',
`create_time` timestamp NOT NULL DEFAULT NOW() COMMENT '添加时间',
PRIMARY KEY (`id`),
INDEX `idx_order_id`(`order_id`),
INDEX `idx_sku_id`(`sku_id`),
INDEX `idx_create_time`(`create_time`)
) COMMENT = '评价表';
供货商数据表
供货商 表
CREATE TABLE `t_supplier` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`code` varchar(200) NOT NULL COMMENT '供货商编号',
`name` varchar(200) NOT NULL COMMENT '供货商名称',
`type` tinyint UNSIGNED NOT NULL COMMENT '类型:1厂家,2代理商,3个人',
`link_man` varchar(20) NOT NULL COMMENT '联系人',
`tel` varchar(20) NOT NULL COMMENT '联系电话',
`address` varchar(200) NOT NULL COMMENT '联系地址',
`bank_name` varchar(200) NULL COMMENT '开户银行名称',
`bank_account` varchar(200) NULL COMMENT '银行账号',
`status` tinyint UNSIGNED NOT NULL COMMENT '状态:1可用,2不可用',
PRIMARY KEY (`id`),
INDEX `idx_code`(`code`),
INDEX `idx_type`(`type`),
INDEX `idx_status`(`status`),
UNIQUE INDEX `unq_code`(`code`)
) COMMENT = '供货商表';
供货商关联商品表
CREATE TABLE `t_supplier_sku` (
`supplier_id` int UNSIGNED NOT NULL COMMENT '供货商ID',
`sku_id` int UNSIGNED NOT NULL COMMENT '商品ID',
PRIMARY KEY (`supplier_id`, `sku_id`)
) COMMENT = '供货商关联商品表';