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

```[sql] -- ---------------------------- -- Table structure for ns_express_company -- ---------------------------- DROP TABLE IF EXISTS `ns_express_company`; CREATE TABLE `ns_express_company` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', `company_id` int(11) NOT NULL DEFAULT 0 COMMENT '物流公司id', `company_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流公司名稱', `logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'logo', `express_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '編碼', `content_json` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '打印內容', `background_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '背景圖', `font_size` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '打印字體', `width` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '寬度', `height` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '高度', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `scale` decimal(10,2) NOT NULL DEFAULT 1.00 COMMENT '真實尺寸（mm）與顯示尺寸（px）的比例', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 963 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '店鋪物流公司' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_express_company_template -- ---------------------------- DROP TABLE IF EXISTS `ns_express_company_template`; CREATE TABLE `ns_express_company_template` ( `company_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `company_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流公司名稱', `logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流公司logo', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流公司網址', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `express_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '編碼', `express_no_kd100` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '編碼（快遞100）', `express_no_cainiao` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '編碼（菜鳥）', `content_json` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '打印內容', `background_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '背景圖', `font_size` int(11) NOT NULL DEFAULT 14 COMMENT '打印字體', `width` int(11) NOT NULL DEFAULT 0 COMMENT '寬度', `height` int(11) NOT NULL DEFAULT 0 COMMENT '高度', `scale` decimal(10,2) NOT NULL DEFAULT 1.00 COMMENT '真實尺寸（mm）與顯示尺寸（px）的比例', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `is_electronicsheet` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否支持電子面單（0不支持 1支持）', `print_style` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '電子面單打印風格', PRIMARY KEY (`company_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 101 AVG_ROW_LENGTH = 2340 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系統物流公司表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_express_delivery_package -- ---------------------------- DROP TABLE IF EXISTS `ns_express_delivery_package`; CREATE TABLE `ns_express_delivery_package` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單id', `order_goods_id_array` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單項商品組合列表', `goods_id_array` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品組合列表', `package_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '包裹名稱（包裹- 1 包裹 - 2）', `delivery_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '發貨方式1 需要物流 0無需物流', `express_company_id` int(11) NOT NULL DEFAULT 0 COMMENT '快遞公司id', `express_company_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流公司名稱', `delivery_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '運單編號', `delivery_time` int(11) NOT NULL DEFAULT 0 COMMENT '發貨時間', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員id', `member_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員名稱', `express_company_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '發貨公司圖片', `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '發貨方式（manual 手動發貨 electronicsheet 電子面單發貨）', `template_id` int(11) NOT NULL DEFAULT 0 COMMENT '電子面單模板id', `template_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '電子面單模板名稱', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 569 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品訂單物流信息表（多次發貨）' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_express_electronicsheet -- ---------------------------- DROP TABLE IF EXISTS `ns_express_electronicsheet`; CREATE TABLE `ns_express_electronicsheet` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `template_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板名稱', `company_id` int(1) NOT NULL DEFAULT 0 COMMENT '物流公司id', `company_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流公司名稱', `express_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '編碼', `customer_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'CustomerName', `customer_pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'CustomerPwd', `send_site` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'SendSite', `send_staff` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'SendStaff', `month_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'MonthCode', `postage_payment_method` tinyint(3) NOT NULL DEFAULT 0 COMMENT '郵費支付方式（1現付 2到付 3月結）', `is_notice` tinyint(3) NOT NULL DEFAULT 0 COMMENT '快遞員上門攬件（0否 1是）', `status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '狀態（0正常 -1不使用）', `is_default` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否默認（0否 1是）', `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, `print_style` int(11) NOT NULL COMMENT '模板風格', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 3276 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '電子面單' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_express_template -- ---------------------------- DROP TABLE IF EXISTS `ns_express_template`; CREATE TABLE `ns_express_template` ( `template_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '商家店鋪id', `template_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板名稱', `fee_type` int(11) NOT NULL DEFAULT 0 COMMENT '運費計算方式1.重量2體積3按件', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `is_default` int(11) NOT NULL DEFAULT 0 COMMENT '是否默認', `surplus_area_ids` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剩余地址id', PRIMARY KEY (`template_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 42325 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '運費模板' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_express_template_item -- ---------------------------- DROP TABLE IF EXISTS `ns_express_template_item`; CREATE TABLE `ns_express_template_item` ( `item_id` int(11) NOT NULL AUTO_INCREMENT, `template_id` int(11) NOT NULL DEFAULT 0 COMMENT '模板id', `area_ids` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '地址id序列', `area_names` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '地址名稱序列', `snum` int(11) NOT NULL DEFAULT 0 COMMENT '起步計算標準', `sprice` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '起步計算價格', `xnum` int(11) NOT NULL DEFAULT 0 COMMENT '續步計算標準', `xprice` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '續步計算價格', `fee_type` int(11) NOT NULL DEFAULT 1 COMMENT '運費計算方式', PRIMARY KEY (`item_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 187 AVG_ROW_LENGTH = 122249 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '運費模板細節' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_local -- ---------------------------- DROP TABLE IF EXISTS `ns_local`; CREATE TABLE `ns_local` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'default' COMMENT '配送方式 default 商家自配送 other 第三方配送', `area_type` int(11) NOT NULL DEFAULT 1 COMMENT '配送區域', `local_area_json` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '區域配送設置', `time_is_open` int(11) NOT NULL DEFAULT 0 COMMENT '訂單達是否開啟 0 關閉 1 開啟', `time_type` int(11) NOT NULL DEFAULT 0 COMMENT '時間選取類型 0 全天 1 自定義', `time_week` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '營業時間周一周二.......', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '當日的起始時間', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '當日的營業結束時間', `update_time` int(11) NOT NULL DEFAULT 0, `is_open_step` int(11) NOT NULL DEFAULT 0 COMMENT '是否啟用階梯價(適用于行政區域)', `start_distance` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '多少距離以內,...', `start_delivery_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '多少距離以內,多少錢', `continued_distance` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '每增加多少距離', `continued_delivery_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '每增加多少距離,運費增加', `start_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '起送價', `delivery_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '配送費', `area_array` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '地域集合', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 AVG_ROW_LENGTH = 5461 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '本地配送設置' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_local_delivery_package -- ---------------------------- DROP TABLE IF EXISTS `ns_local_delivery_package`; CREATE TABLE `ns_local_delivery_package` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單id', `order_goods_id_array` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單項商品組合列表', `goods_id_array` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品組合列表', `package_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '包裹名稱（包裹- 1 包裹 - 2）', `delivery_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'default' COMMENT '發貨方式 default 商家自配送 other 第三方配送', `delivery_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '運單編號', `delivery_time` int(11) NOT NULL DEFAULT 0 COMMENT '發貨時間', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員id', `member_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員名稱', `deliverer` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配送員', `deliverer_mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 AVG_ROW_LENGTH = 8192 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '外賣配送物流信息表' ROW_FORMAT = Compact; ```