```[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;
```
- 序言
- 商城簡介
- 代碼規范
- model層命名規范
- 前端(管理頁面)命名
- 控制器命名規范
- 入門指導
- 偽靜態配置
- 數據庫配置
- 系統環境
- 系統框架
- 目錄結構
- 數據庫操作
- 標準代碼(前端)
- 提示面板
- 表單
- 插件開發
- 插件目錄
- 插件開發說明
- 事件開發
- 常用事件
- 數據字典
- 系統基礎表
- 微信小程序相關
- 微信公眾號相關
- 配送相關表
- 商品相關表
- 店鋪網站設置相關
- 門店相關表
- 會員相關表
- 訂單相關表
- 營銷(組合套餐)
- 營銷(砍價)
- 營銷(優惠券)
- 營銷(限時折扣)
- 營銷(滿額包郵)
- 營銷(互動游戲)
- 營銷(團購)
- 營銷(滿減送)
- 營銷(拼團)
- 營銷(秒殺)
- 營銷(專題)
- 應用(分銷)
- 應用(店鋪筆記)
- 應用(小票打印)
- 應用(積分兌換)