```[sql]
CREATE TABLE ns_express_company (
co_id INT(11) NOT NULL AUTO_INCREMENT COMMENT '表序号',
shop_id INT(11) NOT NULL COMMENT '商铺id',
company_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '物流公司名称',
express_no VARCHAR(20) NOT NULL DEFAULT '' COMMENT '物流编号',
is_enabled INT(11) NOT NULL DEFAULT 1 COMMENT '使用状态',
image VARCHAR(255) DEFAULT '' COMMENT '物流公司模版图片',
phone VARCHAR(50) NOT NULL DEFAULT '' COMMENT '联系电话',
orders INT(11) DEFAULT NULL,
express_logo VARCHAR(255) DEFAULT '' COMMENT '公司logo',
is_default INT(11) NOT NULL DEFAULT 0 COMMENT '是否设置为默认 0未设置 1 默认',
template_id INT(11) NOT NULL DEFAULT 0 COMMENT '安装的物流公司模板id',
template VARCHAR(255) DEFAULT '' COMMENT '电子面单规则',
is_electronic VARCHAR(255) DEFAULT '0' COMMENT '是否开启电子面单 0、不开启 1、开启',
PRIMARY KEY (co_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 5
AVG_ROW_LENGTH = 4096
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '物流公司';
CREATE TABLE ns_express_shipping (
sid INT(11) NOT NULL AUTO_INCREMENT COMMENT '运单模版id',
shop_id INT(11) NOT NULL COMMENT '店铺id',
template_name VARCHAR(255) NOT NULL DEFAULT '' COMMENT '模版名称',
co_id INT(11) NOT NULL DEFAULT 0 COMMENT '物流公司 id',
size_type SMALLINT(6) NOT NULL DEFAULT 1 COMMENT '尺寸类型 1像素px 2毫米mm',
width SMALLINT(6) NOT NULL DEFAULT 0 COMMENT '宽度',
height SMALLINT(6) NOT NULL DEFAULT 0 COMMENT '长度',
image VARCHAR(255) NOT NULL DEFAULT '' COMMENT '快递单图片',
PRIMARY KEY (sid),
INDEX IDX_express_shipping_co_id (co_id),
INDEX IDX_express_shipping_shopId (shop_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 5
AVG_ROW_LENGTH = 4096
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '运单模板';
CREATE TABLE ns_express_shipping_items (
sid INT(11) NOT NULL DEFAULT 0 COMMENT '运单模版id',
field_name VARCHAR(30) NOT NULL COMMENT '字段名称',
field_display_name VARCHAR(255) NOT NULL COMMENT '打印项名称',
is_print TINYINT(4) NOT NULL DEFAULT 1 COMMENT '是否打印',
x INT(11) NOT NULL DEFAULT 0 COMMENT 'x',
y INT(11) NOT NULL DEFAULT 0 COMMENT 'y',
PRIMARY KEY (sid, field_name)
)
ENGINE = INNODB
AVG_ROW_LENGTH = 315
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '物流模板打印项';
CREATE TABLE ns_express_shipping_items_library (
Id INT(11) NOT NULL AUTO_INCREMENT COMMENT '物流模版打印项库ID',
shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店铺id',
field_name VARCHAR(50) NOT NULL COMMENT '字段名',
field_display_name VARCHAR(50) NOT NULL COMMENT '字段显示名',
is_enabled BIT(1) NOT NULL DEFAULT b'1' COMMENT '是否启用',
PRIMARY KEY (Id)
)
ENGINE = INNODB
AUTO_INCREMENT = 14
AVG_ROW_LENGTH = 1260
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '物流模版打印项库';
CREATE TABLE ns_o2o_distribution_area (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
store_id INT(11) NOT NULL DEFAULT 0 COMMENT '门店或者店铺id',
province_id TEXT DEFAULT NULL COMMENT '省id',
city_id TEXT DEFAULT NULL COMMENT '市id',
district_id TEXT DEFAULT NULL COMMENT '区县id',
community_id TEXT DEFAULT NULL COMMENT '社区乡镇id',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '配送区域管理';
CREATE TABLE ns_o2o_distribution_config (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
store_id INT(11) NOT NULL DEFAULT 0 COMMENT '门店或者店铺id',
order_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '订单金额',
freight DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '运费',
is_start INT(11) NOT NULL DEFAULT 0 COMMENT '是否是起步价',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 2
AVG_ROW_LENGTH = 8192
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '配送费用设置';
CREATE TABLE ns_o2o_distribution_user (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL DEFAULT '' COMMENT '配送人员姓名',
mobile VARCHAR(255) NOT NULL DEFAULT '' COMMENT '配送人员电话',
remark TEXT DEFAULT NULL COMMENT '配送人员备注',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 16384
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '配送人员管理';
CREATE TABLE ns_o2o_order_delivery (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
express_no VARCHAR(255) NOT NULL DEFAULT '' COMMENT '订单编号',
order_id INT(11) NOT NULL DEFAULT 0 COMMENT '订单id',
order_delivery_user_id INT(11) NOT NULL DEFAULT 0 COMMENT '配送人员id',
order_delivery_user_name VARCHAR(255) NOT NULL DEFAULT '' COMMENT '配送人员姓名',
order_delivery_user_mobile VARCHAR(255) NOT NULL DEFAULT '' COMMENT '配送人员电话',
status INT(11) NOT NULL DEFAULT 0 COMMENT '状态',
remark TEXT NOT NULL COMMENT '备注',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 8192
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = 'o2o订单配送';
CREATE TABLE ns_offpay_area (
shop_id INT(11) DEFAULT NULL COMMENT '店铺Id',
province_id TEXT DEFAULT NULL COMMENT '省Id组合',
city_id TEXT DEFAULT NULL COMMENT '市Id组合',
district_id TEXT DEFAULT NULL COMMENT '县Id组合'
)
ENGINE = INNODB
AVG_ROW_LENGTH = 16384
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '货到付款支持地区表';
CREATE TABLE ns_picked_up_auditor (
auditor_id INT(11) NOT NULL AUTO_INCREMENT COMMENT '审核人id',
uid INT(11) NOT NULL DEFAULT 0 COMMENT '用户id',
pickup_id INT(11) NOT NULL DEFAULT 0 COMMENT '自提点门店id',
create_time INT(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
PRIMARY KEY (auditor_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 16384
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '自提门店审核人表';
CREATE TABLE ns_pickup_point (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店铺ID',
name VARCHAR(255) NOT NULL COMMENT '自提点名称',
address VARCHAR(255) NOT NULL DEFAULT '' COMMENT '自提点地址',
contact VARCHAR(255) NOT NULL DEFAULT '' COMMENT '联系人',
phone VARCHAR(255) NOT NULL DEFAULT '' COMMENT '联系电话',
city_id INT(11) NOT NULL COMMENT '市ID',
province_id INT(11) NOT NULL COMMENT '省ID',
district_id INT(11) NOT NULL COMMENT '区县ID',
supplier_id INT(11) NOT NULL DEFAULT 0 COMMENT '供应门店ID',
longitude VARCHAR(255) NOT NULL DEFAULT '' COMMENT '经度',
latitude VARCHAR(255) NOT NULL DEFAULT '' COMMENT '维度',
create_time INT(11) DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 4096
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '自提点管理';
--
-- Definition for table ns_verification_person
--
DROP TABLE IF EXISTS ns_verification_person;
CREATE TABLE ns_verification_person (
v_id INT(11) NOT NULL AUTO_INCREMENT,
uid INT(11) NOT NULL DEFAULT 0 COMMENT '用户id',
shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店铺id',
create_time INT(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (v_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 8192
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '核销人员表';
--
-- Definition for table ns_virtual_goods
--
DROP TABLE IF EXISTS ns_virtual_goods;
CREATE TABLE ns_virtual_goods (
virtual_goods_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
virtual_code VARBINARY(255) NOT NULL COMMENT '虚拟码',
virtual_goods_name VARCHAR(255) NOT NULL DEFAULT '' COMMENT '虚拟商品名称',
money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '虚拟商品金额',
buyer_id INT(11) NOT NULL DEFAULT 0 COMMENT '买家id',
buyer_nickname VARCHAR(255) NOT NULL DEFAULT '' COMMENT '买家名称',
order_goods_id INT(11) NOT NULL DEFAULT 0 COMMENT '关联订单项id',
order_no VARCHAR(255) NOT NULL DEFAULT '' COMMENT '订单编号',
validity_period INT(11) NOT NULL DEFAULT 0 COMMENT '有效期/天(0表示不限制)',
start_time INT(11) NOT NULL DEFAULT 0 COMMENT '有效期开始时间',
end_time INT(11) NOT NULL DEFAULT 0 COMMENT '有效期结束时间',
use_number INT(11) NOT NULL DEFAULT 0 COMMENT '使用次数',
confine_use_number INT(11) NOT NULL DEFAULT 0 COMMENT '限制使用次数',
use_status TINYINT(1) NOT NULL DEFAULT 0 COMMENT '使用状态(-1:已过期,0:未使用,1:已使用)',
shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店铺id',
remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '备注',
create_time INT(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
goods_id INT(11) NOT NULL DEFAULT 0 COMMENT '商品id',
sku_id INT(11) NOT NULL DEFAULT 0 COMMENT '规格id',
goods_type INT(11) NOT NULL DEFAULT 0 COMMENT '商品类型',
PRIMARY KEY (virtual_goods_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 1365
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '虚拟商品列表(用户下单支成功后存放)';
--
-- Definition for table ns_virtual_goods_group
--
DROP TABLE IF EXISTS ns_virtual_goods_group;
CREATE TABLE ns_virtual_goods_group (
virtual_goods_group_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '虚拟商品分组id',
virtual_goods_group_name VARCHAR(255) NOT NULL DEFAULT '' COMMENT '虚拟商品分组名称',
interfaces VARCHAR(1000) DEFAULT '' COMMENT '接口调用地址（JSON）',
shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店铺id',
create_time INT(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (virtual_goods_group_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 2
AVG_ROW_LENGTH = 4096
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '虚拟商品分组表';
--
-- Definition for table ns_virtual_goods_type
--
DROP TABLE IF EXISTS ns_virtual_goods_type;
CREATE TABLE ns_virtual_goods_type (
virtual_goods_type_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '虚拟商品类型id',
virtual_goods_group_id INT(11) NOT NULL DEFAULT 0 COMMENT '关联虚拟商品分组id',
validity_period INT(11) NOT NULL DEFAULT 0 COMMENT '有效期/天(0表示不限制)',
confine_use_number INT(11) NOT NULL DEFAULT 0 COMMENT '限制使用次数',
shop_id INT(11) NOT NULL COMMENT '店铺id',
create_time INT(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
relate_goods_id INT(11) NOT NULL DEFAULT 0 COMMENT '关联商品id',
value_info VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '值详情',
PRIMARY KEY (virtual_goods_type_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 3276
CHARACTER SET utf8
COLLATE utf8_general_ci;
--
-- Definition for table ns_virtual_goods_verification
--
DROP TABLE IF EXISTS ns_virtual_goods_verification;
CREATE TABLE ns_virtual_goods_verification (
id INT(11) NOT NULL AUTO_INCREMENT,
uid INT(11) NOT NULL DEFAULT 0 COMMENT '核销人员id',
virtual_goods_id INT(11) NOT NULL DEFAULT 0 COMMENT '用户虚拟商品id',
action VARCHAR(255) NOT NULL DEFAULT '' COMMENT '动作内容',
status INT(11) NOT NULL DEFAULT 0 COMMENT '用户虚拟商品使用状态',
create_time INT(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
num INT(11) NOT NULL DEFAULT 0 COMMENT '核销次数',
goods_id INT(11) NOT NULL DEFAULT 0 COMMENT '商品id',
verification_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '核销员',
user_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '虚拟商品所有者',
goods_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '虚拟商品名称',
buyer_id INT(11) NOT NULL DEFAULT 0 COMMENT '商品所有人',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '虚拟商品核销记录表';
```
