设计评价表

-- 评价表
DROP TABLE IF EXISTS `t_comment`;
CREATE TABLE `t_comment (
  `id` BIGINT(20) UNSIGNED NOT NULL COMMENT '评价编码',
  `shopid` BIGINT(20) UNSIGNED NOT NULL COMMENT '门店编码',
  `orderid` BIGINT(20) UNSIGNED NOT NULL COMMENT '订单编码',
  `skuid` BIGINT(20) UNSIGNED NOT NULL COMMENT '商品编码',
  `media` JSON NULL COMMENT '买家晒图或视频',
  `rating` TINYINT(1) UNSIGNED NOT NULL DEFAULT '5' COMMENT '评分',
  `comment` VARCHAR(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '评论内容',
  `isdeleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '逻辑删除 0：正常；1：已删除',
  `createtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updatetime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_orderid`(`orderid`) USING BTREE,
  INDEX `idx_skuid`(`skuid`) USING BTREE,
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT = '评价表';

---

感谢支持

更多内容，请移步《超级个体》。