|
/**
|
* 奖品设置表
|
* @author yourName
|
* @date 2021-03-31 16:57
|
*/
|
CREATE TABLE activity_sign_award_set(
|
create_by varchar(100) NOT NULL COMMENT '创建人',
|
create_time datetime NOT NULL COMMENT '创建时间',
|
update_by varchar(100) NOT NULL COMMENT '更新人',
|
update_time datetime NOT NULL COMMENT '更新时间',
|
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
|
award_type int(4) COMMENT '奖项类型（1：自定义产品2：积分3：优惠券4：店铺商品）',
|
|
award_rule int(4) COMMENT '奖项规则（1：每日奖励（默认）2：累计签到天数）',
|
|
cumulative_day int(4) COMMENT '签到累计天数',
|
|
award_name varchar(100) COMMENT '奖项名称',
|
|
introduce_img varchar(500) COMMENT '图片介绍',
|
|
introduce_tip varchar(500) COMMENT '文字介绍',
|
|
award_inventory_cnt int(4) COMMENT '奖项库存数量',
|
|
award_distribute_cnt int(4) COMMENT '已派发数量',
|
|
award_way int(4) COMMENT '兑奖方式（1：线下兑换2：物流配送3：客服兑换）',
|
|
operation_tip varchar(500) COMMENT '操作提示',
|
|
prize_address varchar(500) COMMENT '兑奖地址',
|
|
prize_start_time datetime COMMENT '兑奖期限开始日期',
|
|
prize_end_time datetime COMMENT '兑奖期限结束日期',
|
|
wechat_img varchar(500) COMMENT '客服微信',
|
|
score_cnt int(4) COMMENT '积分数量',
|
|
coupon_id varchar(100) COMMENT '优惠券ID',
|
|
goods_id varchar(100) COMMENT '商品ID',
|
|
activity_id bigint(20) COMMENT '活动主表ID',
|
|
company_id bigint(20) COMMENT '公司ID',
|
|
PRIMARY KEY(id)
|
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='奖品设置表';
|
|
|
|
/**
|
* 领
|
* @author yourName
|
* @date 2021-03-31 16:57
|
*/
|
CREATE TABLE activity_sign_receive_record(
|
create_by varchar(100) NOT NULL COMMENT '创建人',
|
create_time datetime NOT NULL COMMENT '创建时间',
|
update_by varchar(100) NOT NULL COMMENT '更新人',
|
update_time datetime NOT NULL COMMENT '更新时间',
|
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
|
open_id varchar(100) COMMENT 'openID',
|
|
receive_time datetime COMMENT '领取时间',
|
|
remark varchar(500) COMMENT '备注',
|
|
award_id bigint(20) COMMENT '奖品设置表ID',
|
|
state int(4) COMMENT '是否已领取（1：待领取2:已领取）',
|
|
write_off_code varchar(100) COMMENT '核销码',
|
|
activity_id bigint(20) COMMENT '活动主表ID',
|
|
company_id bigint(20) COMMENT '公司ID',
|
|
PRIMARY KEY(id)
|
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='领取记录表';
|
|
|
|
|
/**
|
* 签到记录表
|
* @author yourName
|
* @date 2021-03-31 16:57
|
*/
|
CREATE TABLE activity_sign_record(
|
create_by varchar(100) NOT NULL COMMENT '创建人',
|
create_time datetime NOT NULL COMMENT '创建时间',
|
update_by varchar(100) NOT NULL COMMENT '更新人',
|
update_time datetime NOT NULL COMMENT '更新时间',
|
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
|
open_id varchar(100) COMMENT 'openID',
|
|
sign_time datetime COMMENT '签到时间',
|
|
cumulative_day int(4) COMMENT '累计签到天数',
|
|
activity_id bigint(20) COMMENT '活动主表ID',
|
|
company_id bigint(20) COMMENT '公司ID',
|
|
PRIMARY KEY(id)
|
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='签到记录表';
|
|
ALTER TABLE `shop_activities`
|
ADD COLUMN `act_code` varchar(200) NULL COMMENT '活动编码' AFTER `id`;
|
|
ALTER TABLE `activity_sign_award_set`
|
ADD COLUMN `award_state` int(4) NULL COMMENT '奖品是否有效（1：有效 2：无效）' AFTER `company_id`;
|
|
ALTER TABLE `activity_sign_award_set`
|
ADD COLUMN `goods_name` varchar(200) NULL COMMENT '产品名称' AFTER `coupon_id`;
|
|
ALTER TABLE `activity_sign_award_set`
|
ADD COLUMN `coupon_name` varchar(200) NULL COMMENT '优惠券名' AFTER `score_cnt`;
|
|
ALTER TABLE `activity_sign_record`
|
CHANGE COLUMN `open_id` `user_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'openID' AFTER `id`;
|
|
ALTER TABLE `activity_sign_receive_record`
|
CHANGE COLUMN `open_id` `user_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'openID' AFTER `id`;
|
|
/**
|
* 核销记录
|
* @author yourName
|
* @date 2021-04-08 14:25
|
*/
|
CREATE TABLE activity_sign_writeoff(
|
create_by varchar(100) NOT NULL COMMENT '创建人',
|
create_time datetime NOT NULL COMMENT '创建时间',
|
update_by varchar(100) NOT NULL COMMENT '更新人',
|
update_time datetime NOT NULL COMMENT '更新时间',
|
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
|
writeoff_time datetime COMMENT '核销时间',
|
|
writeoff_user varchar(100) COMMENT '核销员',
|
|
writeoff_code varchar(100) COMMENT '兑奖码',
|
|
act_id bigint(20) COMMENT '活动ID',
|
|
award_id bigint(20) COMMENT '奖品ID',
|
|
win_time datetime COMMENT '中奖时间',
|
|
state int(4) COMMENT '状态',
|
|
user_id bigint(20) COMMENT '中奖者ID',
|
|
logistics_id bigint(20) COMMENT '物流ID',
|
|
receive_id bigint(20) COMMENT '中奖记录ID',
|
|
company_id bigint(20) COMMENT '公司ID',
|
|
shop_id bigint(20) COMMENT '店铺ID',
|
|
writeoff_userid bigint(20) COMMENT '核销员ID',
|
|
PRIMARY KEY(id)
|
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='核销记录';
|
|
ALTER TABLE `activity_sign_receive_record`
|
ADD COLUMN `consignee` varchar(200) NULL COMMENT '收货人' AFTER `user_id`;
|
|
ALTER TABLE `activity_sign_receive_record`
|
ADD COLUMN `consignee_phone` varchar(50) NULL COMMENT '联系电话' AFTER `user_id`;
|
|
ALTER TABLE `activity_sign_receive_record`
|
ADD COLUMN `consignee_address` varchar(300) NULL COMMENT '收货地址' AFTER `consignee_phone`;
|
|
ALTER TABLE `shop_delivery_info`
|
ADD COLUMN `receive_id` bigint(20) NULL COMMENT '奖品领取ID' AFTER `company_id`;
|
