```[sql]
-- ----------------------------
-- Table structure for ns_order
-- ----------------------------
DROP TABLE IF EXISTS `ns_order`;
CREATE TABLE `ns_order` (
`order_id` int(11) NOT NULL AUTO_INCREMENT,
`order_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單編號',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '商家id',
`site_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪名稱',
`website_id` int(11) NOT NULL DEFAULT 0 COMMENT '分站id',
`order_name` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單內容',
`order_from` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單來源',
`order_from_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單來源名稱',
`order_type` int(11) NOT NULL DEFAULT 0 COMMENT '訂單類型 1. 普通訂單 2. 門店訂單 3. 本地配送訂單4. 虛擬訂單',
`order_type_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單類型名稱',
`order_promotion_type` int(11) NOT NULL DEFAULT 0 COMMENT '訂單營銷類型',
`order_promotion_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '營銷活動類型名稱',
`promotion_id` int(11) NOT NULL DEFAULT 0 COMMENT '營銷活動id',
`out_trade_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付流水號',
`out_trade_no_2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付流水號(多次支付)',
`delivery_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '整體提貨編碼',
`order_status` int(11) NOT NULL DEFAULT 0 COMMENT '訂單狀態',
`order_status_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單狀態名稱',
`order_status_action` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單操作',
`pay_status` int(11) NOT NULL DEFAULT 0 COMMENT '支付狀態',
`delivery_status` int(11) NOT NULL DEFAULT 0 COMMENT '配送狀態',
`refund_status` int(11) NOT NULL DEFAULT 0 COMMENT '退款狀態',
`pay_type` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付方式',
`pay_type_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付類型名稱',
`delivery_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '配送方式',
`delivery_type_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配送方式名稱',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '購買人uid',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '購買人姓名',
`mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '購買人手機',
`telephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '購買人固定電話',
`province_id` int(11) NOT NULL DEFAULT 0 COMMENT '購買人省id',
`city_id` int(11) NOT NULL DEFAULT 0 COMMENT '購買人市id',
`district_id` int(11) NOT NULL DEFAULT 0 COMMENT '購買人區縣id',
`community_id` int(11) NOT NULL DEFAULT 0 COMMENT '購買人社區id',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '購買人地址',
`full_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '購買人詳細地址',
`longitude` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '購買人地址經度',
`latitude` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '購買人地址緯度',
`buyer_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '購買人ip',
`buyer_ask_delivery_time` int(11) NOT NULL DEFAULT 0 COMMENT '購買人要求配送時間',
`buyer_message` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '購買人留言信息',
`goods_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品總金額',
`delivery_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '配送費用',
`promotion_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '訂單優惠金額(滿減)',
`coupon_id` int(11) NOT NULL DEFAULT 0 COMMENT '優惠券id',
`coupon_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '優惠券金額',
`invoice_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '發票金額',
`order_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '訂單合計金額',
`adjust_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '訂單調整金額',
`balance_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '余額支付金額',
`pay_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '抵扣之后應付金額',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
`pay_time` int(11) NOT NULL DEFAULT 0 COMMENT '訂單支付時間',
`delivery_time` int(11) NOT NULL DEFAULT 0 COMMENT '訂單配送時間',
`sign_time` int(11) NOT NULL DEFAULT 0 COMMENT '訂單簽收時間',
`finish_time` int(11) NOT NULL DEFAULT 0 COMMENT '訂單完成時間',
`close_time` int(11) NOT NULL DEFAULT 0 COMMENT '訂單關閉時間',
`is_lock` int(11) NOT NULL DEFAULT 0 COMMENT '是否鎖定訂單(針對維權,鎖定不可操作)',
`is_evaluate` int(11) NOT NULL DEFAULT 0 COMMENT '是否允許訂單評價',
`is_delete` int(11) NOT NULL DEFAULT 0 COMMENT '是否刪除(針對后臺)',
`is_enable_refund` int(11) NOT NULL DEFAULT 0 COMMENT '是否允許退款',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '賣家留言',
`goods_num` int(11) NOT NULL DEFAULT 0 COMMENT '商品件數',
`delivery_store_id` int(11) NOT NULL DEFAULT 0 COMMENT '門店id',
`delivery_status_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '發貨狀態',
`is_settlement` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否進行結算',
`store_settlement_id` int(11) NOT NULL DEFAULT 0 COMMENT '門店結算id',
`delivery_store_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '門店名稱',
`promotion_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '營銷類型',
`promotion_type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '營銷類型名稱',
`promotion_status_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '營銷狀態名稱',
`delivery_store_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '門店信息(json)',
`virtual_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '虛擬商品碼',
`evaluate_status` int(11) NOT NULL DEFAULT 0 COMMENT '評價狀態,0:未評價,1:已評價,2:已追評',
`evaluate_status_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '評價狀態名稱,未評價,已評價,已追評',
`refund_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '訂單退款金額',
`commission` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '總支出傭金',
`is_invoice` int(11) NOT NULL DEFAULT 0 COMMENT '是否需要發票 0 無發票 1 有發票',
`invoice_type` int(11) NOT NULL DEFAULT 1 COMMENT '發票類型 1 紙質發票 2 電子發票',
`invoice_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '發票抬頭',
`taxpayer_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '納稅人識別號',
`invoice_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '發票稅率',
`invoice_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '發票內容',
`invoice_delivery_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '發票郵寄費用',
`invoice_full_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '發票郵寄地址',
`is_tax_invoice` int(11) NOT NULL DEFAULT 0 COMMENT '是否需要增值稅專用發票',
`invoice_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '發票發送郵件',
`invoice_title_type` int(11) NOT NULL DEFAULT 0 COMMENT '發票抬頭類型 1 個人 2 企業',
`is_fenxiao` int(1) NOT NULL DEFAULT 1 COMMENT '是否參與分銷 0不參與 1參與',
`point_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '積分抵現金額',
PRIMARY KEY (`order_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 852 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_order_goods
-- ----------------------------
DROP TABLE IF EXISTS `ns_order_goods`;
CREATE TABLE `ns_order_goods` (
`order_goods_id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單id',
`order_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單編號',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '商家id',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '購買會員id',
`goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id',
`sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品skuid',
`sku_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名稱',
`sku_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品圖片',
`sku_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品編碼',
`is_virtual` int(11) NOT NULL DEFAULT 0 COMMENT '是否是虛擬商品',
`goods_class` int(11) NOT NULL DEFAULT 0 COMMENT '商品種類(1.實物 2.虛擬3.卡券)',
`goods_class_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品類型名稱',
`price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品賣價',
`cost_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '成本價',
`num` int(11) NOT NULL DEFAULT 0 COMMENT '購買數量',
`goods_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品總價',
`cost_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '成本總價',
`delivery_status` int(11) NOT NULL DEFAULT 0 COMMENT '配送狀態',
`delivery_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配送單號',
`gift_flag` int(11) NOT NULL DEFAULT 0 COMMENT '贈品標識',
`refund_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款編號(申請產生)',
`refund_status` int(11) NOT NULL DEFAULT 0 COMMENT '退款狀態',
`refund_status_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款狀態名稱',
`refund_status_action` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款操作',
`refund_type` int(11) NOT NULL DEFAULT 0 COMMENT '退款方式',
`refund_apply_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '退款申請金額',
`refund_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款原因',
`refund_real_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '實際退款金額',
`refund_delivery_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款公司名稱',
`refund_delivery_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款單號',
`refund_time` int(11) NOT NULL DEFAULT 0 COMMENT '實際退款時間',
`refund_refuse_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款拒絕原因',
`refund_action_time` int(11) NOT NULL DEFAULT 0 COMMENT '退款時間',
`delivery_status_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配送狀態名稱',
`real_goods_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '實際商品購買價',
`refund_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款說明',
`refund_delivery_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '買家退貨說明',
`refund_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退貨地址',
`is_refund_stock` int(11) NOT NULL DEFAULT 0 COMMENT '是否返還庫存',
`refund_money_type` int(11) NOT NULL DEFAULT 1 COMMENT '退款方式 1 原路退款 2線下退款',
`promotion_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '優惠金額',
`coupon_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '優惠券金額',
`adjust_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '調整金額',
`goods_name` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名稱',
`sku_spec_format` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'sku規格格式',
`is_fenxiao` int(1) NOT NULL DEFAULT 1,
`use_point` int(11) NOT NULL DEFAULT 0 COMMENT '積分抵扣所用積分數',
`point_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '積分抵扣金額',
PRIMARY KEY (`order_goods_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 481 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單商品表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_order_log
-- ----------------------------
DROP TABLE IF EXISTS `ns_order_log`;
CREATE TABLE `ns_order_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單id',
`action` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作',
`uid` int(11) NOT NULL DEFAULT 0 COMMENT '操作人id',
`nick_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作元',
`order_status` int(11) NOT NULL DEFAULT 0 COMMENT '訂單狀態',
`action_way` bigint(2) NOT NULL DEFAULT 0,
`order_status_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單狀態名稱',
`action_time` int(11) NOT NULL DEFAULT 0 COMMENT '操作時間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單操作表(傳統表,不用設計)' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_order_promotion_detail
-- ----------------------------
DROP TABLE IF EXISTS `ns_order_promotion_detail`;
CREATE TABLE `ns_order_promotion_detail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL COMMENT '站點id',
`order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單id',
`promotion_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單優惠說明',
`sku_list` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '參與的商品項',
`type` int(11) NOT NULL DEFAULT 0 COMMENT '類型 1優惠,2贈送',
`num` int(11) NOT NULL DEFAULT 0 COMMENT '相關數量',
`money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '相關金額',
`type_event` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '相關執行事件',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 528 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單滿減優惠表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_order_refund_log
-- ----------------------------
DROP TABLE IF EXISTS `ns_order_refund_log`;
CREATE TABLE `ns_order_refund_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id',
`order_goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單項id',
`refund_status` int(11) NOT NULL DEFAULT 0 COMMENT '退款狀態',
`refund_status_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款狀態名稱',
`action` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作內容',
`action_way` int(11) NOT NULL DEFAULT 2 COMMENT '操作類型1買家2賣家',
`action_userid` int(11) NOT NULL DEFAULT 0 COMMENT '操作人id',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作人名稱',
`action_time` int(11) NOT NULL DEFAULT 0 COMMENT '操作時間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 153 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單退款操作表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_pay
-- ----------------------------
DROP TABLE IF EXISTS `ns_pay`;
CREATE TABLE `ns_pay` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id',
`out_trade_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付流水號',
`pay_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付方式',
`trade_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '交易單號',
`pay_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付賬號',
`pay_body` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付主體',
`pay_detail` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付詳情',
`pay_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '支付金額',
`pay_addon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付插件',
`pay_voucher` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付票據',
`pay_status` int(11) NOT NULL DEFAULT 0 COMMENT '支付狀態(0.待支付 1. 支付中 2. 已支付 -1已取消)',
`return_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '同步回調網址',
`event` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付成功后事件(事件,網址)',
`mch_info` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商戶信息',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
`pay_time` int(11) NOT NULL DEFAULT 0 COMMENT '支付時間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 307 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '支付記錄' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_pay_refund
-- ----------------------------
DROP TABLE IF EXISTS `ns_pay_refund`;
CREATE TABLE `ns_pay_refund` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id',
`refund_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款編號',
`out_trade_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '對應支付流水號',
`refund_detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款詳情',
`refund_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '退款類型',
`refund_fee` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '退款金額',
`total_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '實際支付金額',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 297 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '退款記錄' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_verifier
-- ----------------------------
DROP TABLE IF EXISTS `ns_verifier`;
CREATE TABLE `ns_verifier` (
`verifier_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '核銷員id',
`verifier_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核銷員姓名',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '商家id',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '前臺會員id',
`uid` int(11) NOT NULL DEFAULT 0 COMMENT '后臺用戶id',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
`modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間',
PRIMARY KEY (`verifier_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1092 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '核銷員(商品或訂單商品)' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_verify
-- ----------------------------
DROP TABLE IF EXISTS `ns_verify`;
CREATE TABLE `ns_verify` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id',
`site_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點名稱',
`verify_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核銷碼',
`verify_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核銷類型',
`verify_type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核銷類型名稱',
`verify_content_json` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核銷相關數據',
`verifier_id` int(11) NOT NULL DEFAULT 0 COMMENT '核銷員id',
`verifier_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核銷員姓名',
`is_verify` int(11) NOT NULL DEFAULT 0 COMMENT '是否已經核銷',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
`verify_time` int(11) NOT NULL DEFAULT 0 COMMENT '核銷時間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1024 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '核銷編碼管理' ROW_FORMAT = Compact;
- 序言
- 商城簡介
- 代碼規范
- model層命名規范
- 前端(管理頁面)命名
- 控制器命名規范
- 入門指導
- 偽靜態配置
- 數據庫配置
- 系統環境
- 系統框架
- 目錄結構
- 數據庫操作
- 標準代碼(前端)
- 提示面板
- 表單
- 插件開發
- 插件目錄
- 插件開發說明
- 事件開發
- 常用事件
- 數據字典
- 系統基礎表
- 微信小程序相關
- 微信公眾號相關
- 配送相關表
- 商品相關表
- 店鋪網站設置相關
- 門店相關表
- 會員相關表
- 訂單相關表
- 營銷(組合套餐)
- 營銷(砍價)
- 營銷(優惠券)
- 營銷(限時折扣)
- 營銷(滿額包郵)
- 營銷(互動游戲)
- 營銷(團購)
- 營銷(滿減送)
- 營銷(拼團)
- 營銷(秒殺)
- 營銷(專題)
- 應用(分銷)
- 應用(店鋪筆記)
- 應用(小票打印)
- 應用(積分兌換)