配送相關 · Niushop單商戶V3數據字典

```[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 = '虛擬商品核銷記錄表'; ```