```[sql]
CREATE TABLE ns_account (
account_id INT(10) NOT NULL AUTO_INCREMENT COMMENT '账户ID',
account_profit DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平台的总营业额',
account_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平台资金总余额',
account_return DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平台利润总额',
account_deposit DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '保证金总额',
account_order DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商城订单总额',
account_withdraw DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商城提现总额',
account_shop DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店铺总余额',
account_shop_withdraw DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店铺总提现',
PRIMARY KEY (account_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 8192
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '商城资金统计';
CREATE TABLE ns_account_assistant_records (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
serial_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水号',
shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店铺id',
money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '对应金额',
account_type TINYINT(1) NOT NULL COMMENT '账户类型',
type_alis_id INT(11) NOT NULL COMMENT '关联ID',
remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '简介',
create_time INT(11) DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '招商员支付记录';
CREATE TABLE ns_account_order_records (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
serial_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水号',
shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店铺id',
money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '对应金额',
account_type TINYINT(1) NOT NULL COMMENT '账户类型',
type_alis_id INT(11) NOT NULL COMMENT '关联ID',
remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '简介',
create_time INT(11) DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 8192
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '金额账户记录';
CREATE TABLE ns_account_period (
period_id INT(10) NOT NULL AUTO_INCREMENT COMMENT '账户ID',
period_year INT(10) NOT NULL COMMENT '账期年份',
period_month INT(10) NOT NULL COMMENT '账期月份',
account_profit DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '账期总营业额',
account_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '账期总发生余额',
account_return DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '账期利润总额',
account_deposit DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '账期保证金总额',
account_order DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '账期订单总额',
account_withdraw DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '账期店铺提现总额',
account_shop DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '账期店铺总发生额',
account_shop_withdraw DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '账期店铺总提现额',
start_time INT(11) DEFAULT 0 COMMENT '开始时间',
end_time INT(11) DEFAULT 0 COMMENT '结束时间',
PRIMARY KEY (period_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 16384
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '商城账期结算表';
CREATE TABLE ns_account_records (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店铺id',
money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '对应金额',
account_type TINYINT(1) NOT NULL COMMENT '账户类型',
type_alis_id INT(11) NOT NULL COMMENT '关联ID',
is_display TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否显示',
is_calculate TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否参与计算',
remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '简介',
create_time INT(11) DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 1092
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '金额账户记录';
CREATE TABLE ns_account_return_records (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店铺id',
money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
return_type INT(11) NOT NULL DEFAULT 0 COMMENT '提成类型',
type_alis_id INT(11) NOT NULL DEFAULT 0 COMMENT '关联id',
is_display INT(11) NOT NULL DEFAULT 0 COMMENT '是否显示',
is_calculate INT(11) NOT NULL DEFAULT 0 COMMENT '是否计算',
remark VARCHAR(255) NOT NULL DEFAULT '0' COMMENT '备注',
create_time INT(11) DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 910
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '平台的利润的记录';
CREATE TABLE ns_account_withdraw_records (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
serial_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水号',
shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店铺id',
money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '对应金额',
account_type TINYINT(1) NOT NULL COMMENT '账户类型',
type_alis_id INT(11) NOT NULL COMMENT '关联ID',
remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '简介',
create_time INT(11) DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '金额账户记录';
CREATE TABLE ns_account_withdraw_user_records (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
serial_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水号',
shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店铺id',
money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '对应金额',
account_type TINYINT(1) NOT NULL COMMENT '账户类型',
type_alis_id INT(11) NOT NULL COMMENT '关联ID',
remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '简介',
create_time INT(11) DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '会员提现记录表';
--
-- Definition for table ns_shop
--
DROP TABLE IF EXISTS ns_shop;
CREATE TABLE ns_shop (
shop_id INT(11) NOT NULL COMMENT '店铺索引id',
shop_name VARCHAR(50) NOT NULL COMMENT '店铺名称',
shop_type INT(11) NOT NULL COMMENT '店铺类型等级',
uid INT(11) NOT NULL COMMENT '会员id',
shop_group_id INT(11) NOT NULL COMMENT '店铺分类',
shop_company_name VARCHAR(50) DEFAULT NULL COMMENT '店铺公司名称',
province_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店铺所在省份ID',
city_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店铺所在市ID',
shop_address VARCHAR(100) NOT NULL DEFAULT '' COMMENT '详细地区',
shop_zip VARCHAR(10) NOT NULL DEFAULT '' COMMENT '邮政编码',
shop_state TINYINT(1) NOT NULL DEFAULT 1 COMMENT '店铺状态，0关闭，1开启，2审核中',
shop_close_info VARCHAR(255) DEFAULT NULL COMMENT '店铺关闭原因',
shop_sort INT(11) NOT NULL DEFAULT 0 COMMENT '店铺排序',
shop_logo VARCHAR(255) DEFAULT NULL COMMENT '店铺logo',
shop_banner VARCHAR(255) DEFAULT NULL COMMENT '店铺横幅',
shop_avatar VARCHAR(150) DEFAULT NULL COMMENT '店铺头像',
shop_keywords VARCHAR(255) NOT NULL DEFAULT '' COMMENT '店铺seo关键字',
shop_description VARCHAR(255) NOT NULL DEFAULT '' COMMENT '店铺seo描述',
shop_qq VARCHAR(50) DEFAULT NULL COMMENT 'QQ',
shop_ww VARCHAR(50) DEFAULT NULL COMMENT '阿里旺旺',
shop_phone VARCHAR(20) DEFAULT NULL COMMENT '商家电话',
shop_domain VARCHAR(50) DEFAULT NULL COMMENT '店铺二级域名',
shop_domain_times TINYINT(1) UNSIGNED DEFAULT 0 COMMENT '二级域名修改次数',
shop_recommend TINYINT(1) NOT NULL DEFAULT 0 COMMENT '推荐，0为否，1为是，默认为0',
shop_credit INT(10) NOT NULL DEFAULT 0 COMMENT '店铺信用',
shop_desccredit FLOAT NOT NULL DEFAULT 0 COMMENT '描述相符度分数',
shop_servicecredit FLOAT NOT NULL DEFAULT 0 COMMENT '服务态度分数',
shop_deliverycredit FLOAT NOT NULL DEFAULT 0 COMMENT '发货速度分数',
shop_collect INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店铺收藏数量',
shop_stamp VARCHAR(200) DEFAULT NULL COMMENT '店铺印章',
shop_printdesc VARCHAR(500) DEFAULT NULL COMMENT '打印订单页面下方说明文字',
shop_sales DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店铺销售额（不计算退款）',
shop_account DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店铺账户余额',
shop_cash DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店铺可提现金额',
shop_workingtime VARCHAR(100) DEFAULT NULL COMMENT '工作时间',
live_store_name VARCHAR(255) DEFAULT NULL COMMENT '商铺名称',
live_store_address VARCHAR(255) DEFAULT NULL COMMENT '商家地址',
live_store_tel VARCHAR(255) DEFAULT NULL COMMENT '商铺电话',
live_store_bus VARCHAR(255) DEFAULT NULL COMMENT '公交线路',
shop_vrcode_prefix CHAR(3) DEFAULT NULL COMMENT '商家兑换码前缀',
store_qtian TINYINT(1) DEFAULT 0 COMMENT '7天退换',
shop_zhping TINYINT(1) DEFAULT 0 COMMENT '正品保障',
shop_erxiaoshi TINYINT(1) DEFAULT 0 COMMENT '两小时发货',
shop_tuihuo TINYINT(1) DEFAULT 0 COMMENT '退货承诺',
shop_shiyong TINYINT(1) DEFAULT 0 COMMENT '试用中心',
shop_shiti TINYINT(1) DEFAULT 0 COMMENT '实体验证',
shop_xiaoxie TINYINT(1) DEFAULT 0 COMMENT '消协保证',
shop_huodaofk TINYINT(1) DEFAULT 0 COMMENT '货到付款',
shop_free_time VARCHAR(10) DEFAULT NULL COMMENT '商家配送时间',
shop_region VARCHAR(50) DEFAULT NULL COMMENT '店铺默认配送区域',
recommend_uid INT(11) NOT NULL DEFAULT 0 COMMENT '推荐招商员用户id',
shop_qrcode VARCHAR(255) NOT NULL DEFAULT '' COMMENT '店铺公众号',
shop_create_time INT(11) DEFAULT 0 COMMENT '店铺时间',
shop_end_time INT(11) DEFAULT 0 COMMENT '店铺关闭时间',
PRIMARY KEY (shop_id)
)
ENGINE = INNODB
AVG_ROW_LENGTH = 16384
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '店铺数据表';
--
-- Definition for table ns_shop_account
--
DROP TABLE IF EXISTS ns_shop_account;
CREATE TABLE ns_shop_account (
shop_id INT(11) NOT NULL,
shop_profit DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店铺总营业额',
shop_total_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店铺入账总额',
shop_proceeds DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店铺收益总额',
shop_platform_commission DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平台抽取店铺利润总额',
shop_withdraw DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店铺提现总额',
shop_point INT(11) NOT NULL DEFAULT 0 COMMENT '店铺发放的积分总额',
shop_point_use INT(11) NOT NULL DEFAULT 0 COMMENT '会员已使用多少积分',
PRIMARY KEY (shop_id)
)
ENGINE = INNODB
AVG_ROW_LENGTH = 2340
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '店铺账户表';
--
-- Definition for table ns_shop_ad
--
DROP TABLE IF EXISTS ns_shop_ad;
CREATE TABLE ns_shop_ad (
id INT(11) NOT NULL AUTO_INCREMENT,
shop_id INT(11) NOT NULL,
ad_image VARCHAR(255) NOT NULL DEFAULT '' COMMENT '广告图片',
link_url VARCHAR(255) NOT NULL DEFAULT '' COMMENT '链接地址',
sort INT(11) NOT NULL DEFAULT 0 COMMENT '排序',
type INT(1) NOT NULL DEFAULT 0 COMMENT '类型 0 -- pc端 1-- 手机端 ',
background VARCHAR(255) NOT NULL DEFAULT '#FFFFFF' COMMENT '背景色',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 5461
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '店铺广告设置';
--
-- Definition for table ns_shop_coin_records
--
DROP TABLE IF EXISTS ns_shop_coin_records;
CREATE TABLE ns_shop_coin_records (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
shop_id INT(11) NOT NULL COMMENT '店铺ID',
num DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '购物币数量',
account_type INT(11) NOT NULL DEFAULT 1 COMMENT '增加或减少类型',
type_alis_id INT(11) NOT NULL DEFAULT 0 COMMENT '关联ID',
is_display TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否显示',
text VARCHAR(255) NOT NULL DEFAULT '' COMMENT '简介',
create_time INT(11) DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '店铺购物币记录';
--
-- Definition for table ns_shop_express_address
--
DROP TABLE IF EXISTS ns_shop_express_address;
CREATE TABLE ns_shop_express_address (
express_address_id INT(11) NOT NULL AUTO_INCREMENT COMMENT '物流地址id',
shop_id INT(11) NOT NULL COMMENT '商铺id',
contact VARCHAR(100) NOT NULL DEFAULT '' COMMENT '联系人',
mobile VARCHAR(50) NOT NULL DEFAULT '' COMMENT '手机',
phone VARCHAR(50) NOT NULL DEFAULT '' COMMENT '电话',
company_name VARCHAR(100) NOT NULL DEFAULT '' COMMENT '公司名称',
province SMALLINT(6) NOT NULL DEFAULT 0 COMMENT '所在地省',
city SMALLINT(6) NOT NULL DEFAULT 0 COMMENT '所在地市',
district SMALLINT(6) NOT NULL DEFAULT 0 COMMENT '所在地区县',
zipcode VARCHAR(6) NOT NULL DEFAULT '' COMMENT '邮编',
address VARCHAR(100) NOT NULL DEFAULT '' COMMENT '详细地址',
is_consigner TINYINT(2) NOT NULL DEFAULT 0 COMMENT '发货地址标记',
is_receiver TINYINT(2) NOT NULL DEFAULT 0 COMMENT '收货地址标记',
create_date INT(11) DEFAULT 0 COMMENT '创建日期',
modify_date INT(11) DEFAULT 0 COMMENT '修改日期',
PRIMARY KEY (express_address_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 1092
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '物流地址';
--
-- Definition for table ns_shop_group
--
DROP TABLE IF EXISTS ns_shop_group;
CREATE TABLE ns_shop_group (
shop_group_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分组ID',
group_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '分组名称',
group_sort INT(11) NOT NULL DEFAULT 1 COMMENT '分组排序号',
create_time INT(11) DEFAULT 0 COMMENT '创建时间',
modify_time INT(11) DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (shop_group_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 2730
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '店铺分组表';
--
-- Definition for table ns_shop_order_account_records
--
DROP TABLE IF EXISTS ns_shop_order_account_records;
CREATE TABLE ns_shop_order_account_records (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
shop_id INT(11) NOT NULL COMMENT '店铺ID',
order_id INT(11) NOT NULL COMMENT '订单ID',
order_no VARCHAR(255) NOT NULL DEFAULT '' COMMENT '订单编号',
order_goods_id INT(11) NOT NULL COMMENT '订单项ID',
goods_pay_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '订单项实际支付金额',
rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品平台佣金比率',
shop_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店铺获取金额',
platform_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平台获取金额',
is_refund TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否产生退款',
refund_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '实际退款金额',
shop_refund_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店铺扣减余额',
platform_refund_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平台扣减余额',
is_issue TINYINT(4) NOT NULL DEFAULT 0 COMMENT '是否已经结算',
remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '备注',
create_time INT(11) DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 655
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '店铺针对订单的金额分配';
```
