首页推广分类表.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;