çµåç½ç«ååæ¶åå°ç表设计
--åç
CREATE TABLE `t_commodity_brand` (
`brand_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'åçid',
`name` char(50) DEFAULT NULL COMMENT 'åçå',
`logo` varchar(2000) DEFAULT NULL COMMENT 'åçlogoå°å',
`descript` varchar(2000) COMMENT 'ä»ç»',
`show_status` tinyint(4) DEFAULT NULL COMMENT 'æ¾ç¤ºç¶æ[0-ä¸æ¾ç¤ºï¼1-æ¾ç¤º]',
`first_letter` char(1) DEFAULT NULL COMMENT 'æ£ç´¢é¦åæ¯',
`sort` int(11) DEFAULT NULL COMMENT 'æåº',
PRIMARY KEY (`brand_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='åç';
-- åçåç±»å
³è
CREATE TABLE `t_category_brand_relation` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`brand_id` bigint(20) DEFAULT NULL COMMENT 'åçid',
`category_id` bigint(20) DEFAULT NULL COMMENT 'åç±»id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='åçåç±»å
³è';
--åç±»
CREATE TABLE `t_commodity_category` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主é®id',
`name` char(50) DEFAULT NULL COMMENT 'åç±»å称',
`parent_id` bigint(20) DEFAULT NULL COMMENT 'ç¶åç±»id',
`cat_level` int(11) DEFAULT NULL COMMENT 'å±çº§',
`show_status` tinyint(4) DEFAULT NULL COMMENT 'æ¯å¦æ¾ç¤º[0-ä¸æ¾ç¤ºï¼1æ¾ç¤º]',
`sort` int(11) DEFAULT NULL COMMENT 'æåº',
`icon` char(255) DEFAULT NULL COMMENT 'å¾æ å°å',
`product_unit` char(50) DEFAULT NULL COMMENT '计éåä½',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='åç±»';
--å±æ§å
CREATE TABLE `t_commodity_attr_name` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主é®id',
`attr_name` char(20) DEFAULT NULL COMMENT 'å±æ§å称',
`sort` int(11) DEFAULT NULL COMMENT 'æåº',
`icon` varchar(255) DEFAULT NULL COMMENT 'å¾æ ',
`category_id` bigint(20) DEFAULT NULL COMMENT 'æå±åç±»id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='å±æ§å';
--å±æ§å¼
CREATE TABLE `t_commodity_attr_value` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`attr_id` bigint(20) DEFAULT NULL COMMENT 'å±æ§åid',
`attr_value` varchar(200) DEFAULT NULL COMMENT 'å±æ§å¼',
`sort` int(11) DEFAULT NULL COMMENT '顺åº',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='å±æ§å¼';
--ååspu
CREATE TABLE `t_commodity_spu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ååid',
`spu_name` varchar(200) DEFAULT NULL COMMENT 'ååå称',
`spu_description` varchar(1000) DEFAULT NULL COMMENT 'ååæè¿°',
`catalog_id` bigint(20) DEFAULT NULL COMMENT 'æå±åç±»id',
`brand_id` bigint(20) DEFAULT NULL COMMENT 'åçid',
`sku_default_img` varchar(255) DEFAULT NULL COMMENT 'é»è®¤å¾ç',
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='spuä¿¡æ¯';
--ååsku
CREATE TABLE `t_commodity_sku` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'skuId',
`spu_id` bigint(20) DEFAULT NULL COMMENT 'spuId',
`sku_name` varchar(255) DEFAULT NULL COMMENT 'skuå称',
`sku_desc` varchar(2000) DEFAULT NULL COMMENT 'skuä»ç»æè¿°',
`category_id` bigint(20) DEFAULT NULL COMMENT 'æå±åç±»id',
`brand_id` bigint(20) DEFAULT NULL COMMENT 'åçid',
`sku_title` varchar(255) DEFAULT NULL COMMENT 'æ é¢',
`sku_subtitle` varchar(2000) DEFAULT NULL COMMENT 'å¯æ é¢',
`price` decimal(18,4) DEFAULT NULL COMMENT 'ä»·æ ¼',
`weight` decimal(18,4) DEFAULT NULL COMMENT 'ééï¼ä¸ºäºè®¡ç®è¿è´¹',
`up_shelf_status` char(1) DEFAULT '0' COMMENT 'ä¸æ¶ç¶æ 0ä¸æ¶ 1ä¸æ¶',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='skuä¿¡æ¯';
--spuå¾ç
CREATE TABLE `t_commodity_spu_images` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`spu_id` bigint(20) DEFAULT NULL COMMENT 'spu_id',
`img_name` varchar(200) DEFAULT NULL COMMENT 'å¾çå',
`img_url` varchar(255) DEFAULT NULL COMMENT 'å¾çå°å',
`img_sort` int(11) DEFAULT NULL COMMENT '顺åº',
`default_img` tinyint(4) DEFAULT NULL COMMENT 'æ¯å¦é»è®¤å¾',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='spuå¾ç';
--ååskuå±æ§è¡¨
CREATE TABLE `t_commodity_sku_attr` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`sku_id` bigint(20) DEFAULT NULL COMMENT 'sku_id',
`attr_id` bigint(20) DEFAULT NULL COMMENT 'å±æ§å表id',
`attr_value_id` bigint(200) DEFAULT NULL COMMENT 'å±æ§å¼è¡¨id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='skuå±æ§ååå±æ§å¼è¡¨';
--ååskuå¾ç
CREATE TABLE `t_commodity_sku_images` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`sku_id` bigint(20) DEFAULT NULL COMMENT 'sku_id',
`img_url` varchar(255) DEFAULT NULL COMMENT 'å¾çå°å',
`img_sort` int(11) DEFAULT NULL COMMENT 'æåº',
`default_img` int(11) DEFAULT NULL COMMENT 'é»è®¤å¾[0 - ä¸æ¯é»è®¤å¾ï¼1 - æ¯é»è®¤å¾]',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='skuå¾ç';