首页推广分类表.sql 566 字节
CREATE TABLE `im_campaign_category` (
  `im_campaign_category_id` varchar(36) NOT NULL COMMENT '积分分类专场ID',
  `im_category_id` varchar(36) NOT NULL COMMENT '积分商城分类ID',
  `name` varchar(254) NOT NULL COMMENT '分类名称',
  `image_url` varchar(254) NOT NULL COMMENT '分类图片',
  `sort_index` int(11) NOT NULL COMMENT '排序号',
  `create_dt` datetime NOT NULL COMMENT '创建时间',
  `delete_flag` tinyint(4) NOT NULL DEFAULT '1' COMMENT '删除标识',
  PRIMARY KEY (`im_campaign_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;