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.
137 lines
6.8 KiB
137 lines
6.8 KiB
/*==============================================================*/
|
|
/* DBMS name: MySQL 5.0 */
|
|
/* Created on: 2018/10/10 11:38:13 */
|
|
/*==============================================================*/
|
|
|
|
|
|
drop table if exists rel_vgoods_gift;
|
|
|
|
drop table if exists vgoods;
|
|
|
|
drop table if exists vorder;
|
|
|
|
/*==============================================================*/
|
|
/* Table: rel_vgoods_gift */
|
|
/*==============================================================*/
|
|
create table rel_vgoods_gift
|
|
(
|
|
gift_id bigint not null,
|
|
goods_id bigint not null,
|
|
goods_no varchar(32) comment '商品编号',
|
|
gift_no varchar(32) comment '赠品编号',
|
|
num int comment '数量',
|
|
created_at bigint comment '创建时间',
|
|
created_by varchar(32) comment '创建人',
|
|
primary key (gift_id, goods_id)
|
|
);
|
|
|
|
alter table rel_vgoods_gift comment '商品与赠品关系';
|
|
|
|
/*==============================================================*/
|
|
/* Table: vgoods */
|
|
/*==============================================================*/
|
|
create table vgoods
|
|
(
|
|
id bigint unsigned not null,
|
|
coupon_batch_id int(20) comment '主键',
|
|
merchant_id bigint,
|
|
vgoods_template_id int(20),
|
|
goods_no national varchar(32) comment '商品编号',
|
|
goods_version tinyint default 0 comment '商品版本',
|
|
template_version tinyint default 0 comment '商品模板版本',
|
|
name national varchar(50) comment '商品名称',
|
|
type tinyint default 0 comment '商品类型',
|
|
is_show_countdown national char(1) default N comment '是否显示倒计时,Y:是,N:否',
|
|
original_price bigint default 0 comment '原价',
|
|
price bigint default 0 comment '现价',
|
|
service_count int default 0 comment '服务次数',
|
|
cycle_mode tinyint default 0 comment '周期模式',
|
|
cycle_freq tinyint default 0 comment '周期频率',
|
|
active_period int default 0 comment '激活天数',
|
|
use_period int default 0 comment '使用天数',
|
|
created_at bigint unsigned default 0 comment '创建日期',
|
|
created_by national varchar(32) comment '创建者',
|
|
updated_at bigint unsigned default 0 comment '更新时间',
|
|
updated_by national varchar(32) comment '更新者',
|
|
started_at bigint default 0 comment '开售时间',
|
|
ended_at bigint default 0 comment '结束时间',
|
|
total_num int default 0 comment '商品总数量',
|
|
sold_num int default 0 comment '已售数量',
|
|
focused_num int default 0 comment '被关注人数',
|
|
short_desc national varchar(100) comment '简短描述',
|
|
show_img national varchar(255) comment '展示图片',
|
|
service_desc national text comment '服务描述',
|
|
banner_imgs national varchar(1000) comment 'banner图片',
|
|
evaluate_num int default 0 comment '评价个数',
|
|
evaluate_score bigint default 0 comment '评价分数',
|
|
evaluate_rate double default 0.00 comment '好评率',
|
|
status tinyint unsigned default 0 comment '商品状态',
|
|
notice national text comment '下单须知',
|
|
small_label national varchar(255) comment '小标签，以逗号相隔',
|
|
big_label national varchar(255) comment '大标签图片地址',
|
|
limit_type tinyint default 0 comment '限购方式 0不限购 1限新 2每人单次',
|
|
del_flag tinyint default 0 comment '删除标志',
|
|
sale_profit int default 0 comment '分销提成，万分比',
|
|
sequence_num int default 0 comment '排序',
|
|
is_show_coupon tinyint comment '优惠券展示：0-不展示，1-展示',
|
|
sale_type tinyint comment '分销类型：1-实付比例，2-固定金额',
|
|
big_category_no varchar(32) comment '大品类编号',
|
|
small_category_no varchar(32) comment '小品类编号',
|
|
isBindGifts tinyint default 0 comment '是否绑定赠品：0-否，1-是',
|
|
primary key (id)
|
|
);
|
|
|
|
alter table vgoods comment '虚拟商品';
|
|
|
|
/*==============================================================*/
|
|
/* Table: vorder */
|
|
/*==============================================================*/
|
|
create table vorder
|
|
(
|
|
id bigint unsigned not null,
|
|
address_id bigint,
|
|
coupon_id bigint not null,
|
|
consumer_info_id bigint,
|
|
channel_id int comment 'id',
|
|
user_recommend_id bigint,
|
|
vgoods_id bigint,
|
|
service_card_id bigint comment '主键ID',
|
|
merchant_no national varchar(32) comment '商家编号',
|
|
order_no national varchar(32) comment '订单编号',
|
|
address_full_name national varchar(100) comment '地址全称',
|
|
address_telephone national varchar(20) comment '地址电话',
|
|
region_id int default 0 comment '地区id',
|
|
linkman national varchar(32) comment '联系人',
|
|
lat decimal(10,6) default 0.000000 comment '纬度',
|
|
lng decimal(10,6) default 0.000000 comment '经度',
|
|
remark national varchar(255) comment '留言',
|
|
goods_version tinyint default 0 comment '商品版本',
|
|
goods_name national varchar(50) comment '商品名称',
|
|
goods_img_url national varchar(255) comment '商品图片地址',
|
|
goods_num int default 0 comment '商品数量',
|
|
origin_total_price bigint default 0 comment '商品总原价',
|
|
total_price bigint unsigned default 0 comment '商品现总价',
|
|
coupon_price bigint default 0 comment '优惠金额',
|
|
pay_price bigint default 0 comment '支付金额',
|
|
pay_type tinyint default 0 comment '支付类型',
|
|
pay_time bigint default 0 comment '支付时间',
|
|
order_source tinyint default 0 comment '订单来源',
|
|
status tinyint default 0 comment '订单状态',
|
|
voucher national varchar(255) comment '兑换凭证',
|
|
created_at bigint unsigned default 0 comment '创建时间',
|
|
created_by national varchar(20) comment '创建者',
|
|
updated_at bigint unsigned default 0 comment '更新时间',
|
|
updated_by national varchar(20) comment '更新者',
|
|
del_flag tinyint default 0 comment '删除标志',
|
|
sale_profit int default 0 comment '分销',
|
|
order_type tinyint comment '订单类型：10-销售订单，20：赠品订单',
|
|
sale_type tinyint comment '分销类型：1-实付比例，2-固定金额',
|
|
big_category_no varchar(32) comment '大品类编号',
|
|
small_category_no varchar(32) comment '小品类编号',
|
|
parent_order_no varchar(32) default '0' comment '若为0，则为主订单，否则为父订单编号',
|
|
primary key (id),
|
|
key AK_order_no (order_no)
|
|
);
|
|
|
|
alter table vorder comment '虚拟订单';
|
|
|