==================================================20240831
|
ALTER TABLE `t_order` ADD `member_coupon_id` varchar(50) COMMENT '用户优惠券id';
|
ALTER TABLE `t_order` ADD `member_coupon_code` varchar(50) COMMENT '优惠券编码';
|
ALTER TABLE `t_order` ADD `member_coupon_name` varchar(50) COMMENT '优惠券名称';
|
ALTER TABLE `t_order` ADD `member_coupon_amount` DECIMAL(11,2) COMMENT '优惠券金额';
|
ALTER TABLE `t_order` ADD `member_id` bigint(25) COMMENT '会员等级id';
|
ALTER TABLE `t_order` ADD `member_name` varchar(50) COMMENT '会员等级名称';
|
ALTER TABLE `t_order` ADD `member_discount_type` varchar(50) COMMENT '折扣类型（discount_type）';
|
ALTER TABLE `t_order` ADD `member_discount_ratio` DECIMAL(11,2) COMMENT '会员折扣';
|
ALTER TABLE `t_order` ADD `member_discount_amount` DECIMAL(11,2) COMMENT '优惠金额（每扎）';
|
|
ALTER TABLE `t_order_item` ADD `coupon_amount` DECIMAL(11,2) COMMENT '优惠券金额/扎';
|
ALTER TABLE `t_order_item` ADD `original_price` DECIMAL(11,2) COMMENT '优惠前售价/扎';
|
ALTER TABLE `t_order_item` ADD `real_price` DECIMAL(11,2) COMMENT '真实成交价格/每扎';
|
