You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
114 lines
5.4 KiB
114 lines
5.4 KiB
/*==============================================================*/
|
|
/* DBMS name: MySQL 5.0 */
|
|
/* Created on: 2018/9/6 12:42:36 */
|
|
/*==============================================================*/
|
|
|
|
|
|
drop table if exists coupon_batch;
|
|
|
|
drop table if exists recommend_config;
|
|
|
|
drop table if exists rel_vgoods_service_category;
|
|
|
|
drop table if exists service_category;
|
|
|
|
/*==============================================================*/
|
|
/* Table: coupon_batch */
|
|
/*==============================================================*/
|
|
create table coupon_batch
|
|
(
|
|
id int(20) unsigned not null auto_increment comment '主键',
|
|
channel_id int not null comment 'id',
|
|
merchant_no national varchar(32) comment '商户编号',
|
|
project_name national varchar(128) comment '方案名,后台展示',
|
|
batch_name national varchar(128) comment '批次名,商城展示',
|
|
coupon_batch_no national varchar(32) comment '优惠券批次编号',
|
|
batch_type tinyint default 0 comment '批次类型',
|
|
type tinyint default 0 comment '类型',
|
|
status tinyint default 0 comment '状态',
|
|
amount bigint default 0 comment '优惠额度',
|
|
full_amount bigint default 0 comment '满减券的满减额度,如满99减20的99',
|
|
discount bigint default 0 comment '折扣',
|
|
coupon_price bigint,
|
|
num int default 0 comment '数量',
|
|
received_num int default 0 comment '已领取数量',
|
|
created_at bigint default 0 comment '创建时间',
|
|
created_by national varchar(32) comment '创建者',
|
|
updated_at bigint default 0 comment '更新时间',
|
|
updated_by national varchar(32) comment '更新者',
|
|
time_type tinyint default 0 comment '时间类型',
|
|
invalid_at bigint default 0 comment '失效时间',
|
|
duration_day int default 0 comment '有效天数',
|
|
del_flag tinyint default 0 comment '删除标志',
|
|
goods_no national varchar(256) comment '适用商品id',
|
|
goods_type tinyint default 0 comment '商品类型限制 0为不限制',
|
|
use_limit tinyint comment '使用限制 0为不限制,1为限新用户',
|
|
version tinyint comment '编辑更新版本号',
|
|
primary key (id)
|
|
);
|
|
|
|
alter table coupon_batch comment '优惠券模板';
|
|
|
|
/*==============================================================*/
|
|
/* Table: recommend_config */
|
|
/*==============================================================*/
|
|
create table recommend_config
|
|
(
|
|
id int(32) not null auto_increment,
|
|
merchant_id bigint not null,
|
|
coupon_batch_id int(20) not null comment '主键',
|
|
merchant_no varchar(32) comment '商户编号',
|
|
coupon_batch_no varchar(32) comment '优惠券模板编号',
|
|
created_at bigint comment '创建时间',
|
|
created_by varchar(32) comment '创建人',
|
|
updated_at bigint comment '更新时间',
|
|
updated_by varchar(32) comment '更新人',
|
|
del_flag tinyint default 0 comment '删除标识：0-正常，1-已删除',
|
|
primary key (id)
|
|
);
|
|
|
|
alter table recommend_config comment '商户推荐配置';
|
|
|
|
/*==============================================================*/
|
|
/* Table: rel_vgoods_service_category */
|
|
/*==============================================================*/
|
|
create table rel_vgoods_service_category
|
|
(
|
|
category_id int(32) not null,
|
|
template_id int(20) not null,
|
|
id int(32) not null auto_increment,
|
|
category_no varchar(32) comment '品类编号',
|
|
template_no varchar(32) comment '商品模板编号',
|
|
sort int comment '排序值',
|
|
created_at bigint comment '创建时间',
|
|
created_by varchar(32) comment '创建人',
|
|
updated_at bigint comment '更新时间',
|
|
updated_by varchar(32) comment '更新人',
|
|
del_flag tinyint default 0 comment '删除标识：0-正常，1-已删除',
|
|
primary key (id)
|
|
);
|
|
|
|
alter table rel_vgoods_service_category comment '商品与服务品类关系';
|
|
|
|
/*==============================================================*/
|
|
/* Table: service_category */
|
|
/*==============================================================*/
|
|
create table service_category
|
|
(
|
|
id int(32) not null auto_increment,
|
|
category_no varchar(32) comment '品类编号',
|
|
category_name varchar(20) comment '品类名称',
|
|
status tinyint default 0 comment '状态：0-正常，1-下架',
|
|
is_release tinyint default 0 comment '是否发布：0-不发布，1-发布',
|
|
category_image varchar(200) comment '品类图',
|
|
created_at bigint comment '创建时间',
|
|
created_by varchar(32) comment '创建人',
|
|
updated_at bigint comment '更新时间',
|
|
updated_by varchar(32) comment '更新人',
|
|
sort int comment '排序值',
|
|
del_flag tinyint default 0 comment '删除标识：0-正常，1-已删除',
|
|
primary key (id)
|
|
);
|
|
|
|
alter table service_category comment '服务品类';
|
|
|