huahuibao/sql/20260714_goods_use_case.sql

CREATE TABLE `xhGoodsUseCase` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mainId` int(11) NOT NULL DEFAULT 0 COMMENT '中央id',
  `sjId` int(11) NOT NULL DEFAULT 0 COMMENT '商家id',
  `useCaseName` varchar(50) NOT NULL DEFAULT '' COMMENT '场景名称',
  `inTurn` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态',
  `delStatus` tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除状态',
  `addTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`), KEY `mainId` (`mainId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `xhGoodsUseCaseRelation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mainId` int(11) NOT NULL DEFAULT 0,
  `goodsId` int(11) NOT NULL DEFAULT 0,
  `useCaseId` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`), UNIQUE KEY `goods_use_case` (`goodsId`,`useCaseId`), KEY `mainId` (`mainId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;