訂單相關表 · Niushop單商戶V5開發手冊

```[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;