etrade / dili-xtrade · Files

USE `dili_etrade`;

DROP TABLE IF EXISTS `product_category_preset_price`;
CREATE TABLE `product_category_preset_price` (
    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `creator_id` bigint NOT NULL COMMENT '创建人',
    `creator_name` varchar(60) NOT NULL COMMENT '创建人名称',
    `market_id` bigint NOT NULL COMMENT '市场id',
    `category_id` bigint NOT NULL COMMENT '品类id',
    `min_price` bigint NOT NULL COMMENT '最小价格（单位:分）',
    `max_price` bigint NOT NULL COMMENT '最大价格（单位:分）',
    `sort` tinyint NOT NULL COMMENT '排序值',
    `version` int NOT NULL DEFAULT '1' COMMENT '版本号',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `idx_category_id` (`category_id`) USING BTREE
) ENGINE=InnoDB COMMENT='商品模块：品类-预设价格';