（七）购物券设计

购物券设计

购物券表

CREATE TABLE `t_voucher`(
  `id` int UNSIGNED AUTO_INCREMENT COMMENT '主键',
  `deno` decimal(10, 2) UNSIGNED NOT NULL COMMENT '面值',
  `condition` decimal(10, 2) UNSIGNED NOT NULL COMMENT '订单满多少钱可以使用',
  `start_date` date COMMENT '起始日期',
  `end_date` date COMMENT '截止日期',
  `max_num` int COMMENT '代金券发放最大数量',
  PRIMARY KEY (`id`)
) COMMENT = '购物券表';

 

 

 客户、购物券 关联表

CREATE TABLE `t_voucher_customer`  (
  `id` int UNSIGNED PRIMARY KEY AUTO_INCREMENT COMMENT '主键',
  `voucher_id` int UNSIGNED NOT NULL COMMENT '购物券ID',
  `customer_id` int UNSIGNED NOT NULL COMMENT '客户ID'
) COMMENT = '客户关联购物券数据表';