CREATE TABLE `price_policy_object` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`policy_id` bigint DEFAULT NULL COMMENT '政策业务主键',
`object_group_id` varchar(50) DEFAULT NULL COMMENT '优惠对象组id',
`object_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '优惠对象类型(ProductCategory 、Product、Order)',
`object_code` varchar(100) DEFAULT NULL COMMENT '优惠对象编码',
`object_name` varchar(255) DEFAULT NULL COMMENT '优惠对象名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1674435604038946819 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='优惠对象表';
CREATE TABLE `price_policy_result_object` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`policy_id` bigint DEFAULT NULL COMMENT '政策业务主键',
`object_group_id` varchar(50) DEFAULT NULL COMMENT '优惠对象组id',
`result_object_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '结果对象类型(ProductCategory 、Product、Order)',
`result_object_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '结果对象编码',
`result_object_name` varchar(255) DEFAULT NULL COMMENT '结果对象名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1674435606303870979 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='政策结果对象表';
CREATE TABLE `price_policy_result` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`policy_id` bigint DEFAULT NULL COMMENT '政策业务主键',
`condition_id` bigint DEFAULT NULL COMMENT '条件表主键',
`object_group_id` varchar(50) DEFAULT NULL COMMENT '优惠对象组id',
`condition_group_id` varchar(50) DEFAULT NULL COMMENT '优惠条件组id',
`price_type` varchar(32) DEFAULT NULL COMMENT '价格类型',
`currency` varchar(32) DEFAULT NULL COMMENT '币种',
`result_type` tinyint DEFAULT NULL COMMENT '结果类型(1-数量 2-金额 3-折扣 4-单价折扣)',
`discount_result` decimal(30,10) DEFAULT NULL COMMENT '结果',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1674435611647414274 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='政策结果表';
CREATE TABLE `price_policy_condition` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`policy_id` bigint DEFAULT NULL COMMENT '政策业务主键',
`object_id` bigint DEFAULT NULL COMMENT '优惠对象表主键',
`object_group_id` varchar(50) DEFAULT NULL COMMENT '优惠对象组id',
`condition_group_id` varchar(50) DEFAULT NULL COMMENT '优惠条件组id',
`discount_condition_type` tinyint DEFAULT NULL COMMENT '优惠条件类型(1-数量 2-金额 )',
`discount_condition_start` decimal(30,10) DEFAULT NULL COMMENT '优惠条件-开始',
`discount_condition_end` decimal(30,10) DEFAULT NULL COMMENT '优惠条件-结束',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1674435608090644483 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='政策条件表';
商品优惠政策-表结构设计(精简版)
于 2023-10-30 17:19:07 首次发布