```[sql]
CREATE TABLE ns_adv (
adv_id int(11) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
site_id int(11) NOT NULL DEFAULT 0 COMMENT '站點id',
ap_id int(11) NOT NULL DEFAULT 0 COMMENT '廣告位id',
adv_title varchar(255) NOT NULL DEFAULT '' COMMENT '廣告內容描述',
adv_url varchar(255) NOT NULL DEFAULT '' COMMENT '廣告鏈接',
adv_image varchar(255) NOT NULL DEFAULT '' COMMENT '廣告內容圖片',
slide_sort int(11) NOT NULL DEFAULT 0 COMMENT '排序號',
price decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '廣告價格/月',
background varchar(255) NOT NULL DEFAULT '#FFFFFF' COMMENT '背景色',
PRIMARY KEY (adv_id)
)
ENGINE = INNODB,
CHARACTER SET utf8,
COLLATE utf8_general_ci,
COMMENT = '廣告表';
CREATE TABLE ns_adv_position (
ap_id mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '廣告位置id',
site_id int(11) NOT NULL DEFAULT 0 COMMENT '站點id',
ap_name varchar(100) NOT NULL DEFAULT '' COMMENT '廣告位置名',
ap_intro varchar(255) NOT NULL DEFAULT '' COMMENT '廣告位簡介',
ap_height int(10) NOT NULL DEFAULT 0 COMMENT '廣告位高度',
ap_width int(10) NOT NULL DEFAULT 0 COMMENT '廣告位寬度',
default_content varchar(300) NOT NULL DEFAULT '',
ap_background_color varchar(50) NOT NULL DEFAULT '#FFFFFF' COMMENT '廣告位背景色 默認白色',
type tinyint(4) NOT NULL DEFAULT 1 COMMENT '廣告位所在位置類型 1 pc端 2 手機端',
keyword varchar(255) NOT NULL DEFAULT '' COMMENT '關鍵字',
PRIMARY KEY (ap_id)
)
ENGINE = INNODB,
CHARACTER SET utf8,
COLLATE utf8_general_ci,
COMMENT = '廣告位表';
CREATE TABLE ns_help (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵id',
app_module varchar(255) NOT NULL DEFAULT '' COMMENT '應用模塊',
title varchar(255) NOT NULL DEFAULT '' COMMENT '幫助主題',
link_address varchar(1000) NOT NULL DEFAULT '' COMMENT '鏈接地址',
content text DEFAULT NULL COMMENT '幫助內容',
class_id int(11) NOT NULL DEFAULT 0 COMMENT '幫助類型id',
class_name varchar(50) NOT NULL DEFAULT '' COMMENT '幫助類型名稱',
sort int(11) NOT NULL DEFAULT 0 COMMENT '排序號',
create_time int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
modify_time int(11) NOT NULL DEFAULT 0 COMMENT '修改時間',
PRIMARY KEY (id)
)
ENGINE = INNODB,
CHARACTER SET utf8,
COLLATE utf8_general_ci,
COMMENT = '幫助文章表';
CREATE TABLE ns_help_class (
class_id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
app_module varchar(255) NOT NULL DEFAULT '' COMMENT '應用模塊',
class_name varchar(50) NOT NULL DEFAULT '' COMMENT '幫助類型名稱',
sort int(11) NOT NULL DEFAULT 0 COMMENT '排序號',
create_time int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
modify_time int(11) NOT NULL DEFAULT 0 COMMENT '修改時間',
PRIMARY KEY (class_id)
)
ENGINE = INNODB,
CHARACTER SET utf8,
COLLATE utf8_general_ci,
COMMENT = '幫助類型';
-- ----------------------------
-- Table structure for ns_notice
-- ----------------------------
DROP TABLE IF EXISTS `ns_notice`;
CREATE TABLE `ns_notice` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
`site_id` int(10) NOT NULL DEFAULT 0 COMMENT '站點id',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主題',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '內容',
`is_top` int(11) NOT NULL DEFAULT 0 COMMENT '是否置頂',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
`modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間',
`receiving_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接受對象',
`receiving_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接受對象名稱',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 43 AVG_ROW_LENGTH = 1024 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '公告' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_shop
-- ----------------------------
DROP TABLE IF EXISTS `ns_shop`;
CREATE TABLE `ns_shop` (
`site_id` int(11) NOT NULL,
`shop_status` int(11) NOT NULL DEFAULT 1 COMMENT '店鋪經營狀態(0.關閉,1正常)',
`close_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪關閉原因',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序號',
`start_time` int(11) NOT NULL DEFAULT 0 COMMENT '經營時間',
`end_time` int(11) NOT NULL DEFAULT 0 COMMENT '關閉時間',
`avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪頭像(大圖)',
`banner` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪條幅',
`qq` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系人qq',
`ww` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系人阿里旺旺',
`name` varchar(255) 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 '聯系電話',
`mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系手機號',
`workingtime` int(11) NOT NULL DEFAULT 0 COMMENT '工作時間',
`province` int(11) NOT NULL DEFAULT 0 COMMENT '省id',
`province_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省名稱',
`city` int(11) NOT NULL DEFAULT 0 COMMENT '城市id',
`city_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '城市名稱',
`district` int(11) NOT NULL DEFAULT 0 COMMENT '區縣id',
`district_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '區縣地址',
`community` int(11) NOT NULL DEFAULT 0 COMMENT '鄉鎮地址id',
`community_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '鄉鎮地址名稱',
`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(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '經度',
`latitude` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '緯度',
`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
`store_settlement_time` int(11) NOT NULL DEFAULT 0 COMMENT '門店最后結算時間',
`work_week` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '工作日',
PRIMARY KEY (`site_id`) USING BTREE
) ENGINE = InnoDB AVG_ROW_LENGTH = 512 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '店鋪表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_shop_address
-- ----------------------------
DROP TABLE IF EXISTS `ns_shop_address`;
CREATE TABLE `ns_shop_address` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0,
`contact_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系人',
`mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯系人手機號',
`postcode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '郵政編碼',
`province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省',
`city_id` int(11) NOT NULL DEFAULT 0 COMMENT '市',
`district_id` int(11) NOT NULL DEFAULT 0 COMMENT '縣',
`community_id` int(11) NOT NULL DEFAULT 0 COMMENT '鄉鎮',
`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 '收票地址',
`is_return` tinyint(1) NOT NULL DEFAULT 0 COMMENT '退貨地址',
`is_return_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是默認退貨地址',
`is_delivery` tinyint(1) NOT NULL DEFAULT 0 COMMENT '發貨地址',
`update_time` int(11) NOT NULL DEFAULT 0,
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_site
-- ----------------------------
DROP TABLE IF EXISTS `ns_site`;
CREATE TABLE `ns_site` (
`site_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '站點id',
`site_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點類型',
`site_domain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點域名',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
`site_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點名稱',
`username` varchar(255) 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',
`seo_keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點關鍵字',
`seo_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點描述',
PRIMARY KEY (`site_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 AVG_ROW_LENGTH = 114 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '站點基礎表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_site_diy_view
-- ----------------------------
DROP TABLE IF EXISTS `ns_site_diy_view`;
CREATE TABLE `ns_site_diy_view` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`addon_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '插件名稱',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板名稱',
`value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置值',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
`update_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間',
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'shop' COMMENT '應用模塊:shop、store',
`icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標',
`template_id` int(11) NOT NULL DEFAULT 0 COMMENT '模板id',
PRIMARY KEY (`id`) USING BTREE,
INDEX `IDX_nc_site_diy_view`(`site_id`, `name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 742 AVG_ROW_LENGTH = 1866 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '店鋪自定義模板表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_stat_shop
-- ----------------------------
DROP TABLE IF EXISTS `ns_stat_shop`;
CREATE TABLE `ns_stat_shop` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id',
`year` int(11) NOT NULL DEFAULT 0 COMMENT '年',
`month` int(11) NOT NULL DEFAULT 0 COMMENT '月',
`day` int(11) NOT NULL DEFAULT 0 COMMENT '日',
`day_time` int(11) NOT NULL DEFAULT 0 COMMENT '當日時間',
`order_total` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '訂單金額',
`shipping_total` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '運費金額',
`refund_total` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '退款金額',
`order_pay_count` int(11) NOT NULL DEFAULT 0 COMMENT '訂單總數',
`goods_pay_count` int(11) NOT NULL DEFAULT 0 COMMENT '訂單商品總數',
`shop_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '店鋪金額',
`platform_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '平臺金額',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間',
`modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間',
`collect_shop` int(11) NOT NULL DEFAULT 0 COMMENT '店鋪收藏量',
`collect_goods` int(11) NOT NULL DEFAULT 0 COMMENT '商品收藏量',
`visit_count` int(11) NOT NULL DEFAULT 0 COMMENT '瀏覽量',
`order_count` int(11) NOT NULL DEFAULT 0 COMMENT '訂單量(總)',
`goods_count` int(11) NOT NULL DEFAULT 0 COMMENT '訂單商品量(總)',
`add_goods_count` int(11) NOT NULL DEFAULT 0 COMMENT '添加商品數',
`member_count` int(11) NOT NULL DEFAULT 0 COMMENT '會員統計',
PRIMARY KEY (`id`) USING BTREE,
INDEX `IDX_ns_stat_shop_day`(`day`) USING BTREE,
INDEX `IDX_ns_stat_shop_day_time`(`day_time`) USING BTREE,
INDEX `IDX_ns_stat_shop_month`(`month`) USING BTREE,
INDEX `IDX_ns_stat_shop_site_id`(`site_id`) USING BTREE,
INDEX `IDX_ns_stat_shop_year`(`year`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 154 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
```
- 序言
- 商城簡介
- 代碼規范
- model層命名規范
- 前端(管理頁面)命名
- 控制器命名規范
- 入門指導
- 偽靜態配置
- 數據庫配置
- 系統環境
- 系統框架
- 目錄結構
- 數據庫操作
- 標準代碼(前端)
- 提示面板
- 表單
- 插件開發
- 插件目錄
- 插件開發說明
- 事件開發
- 常用事件
- 數據字典
- 系統基礎表
- 微信小程序相關
- 微信公眾號相關
- 配送相關表
- 商品相關表
- 店鋪網站設置相關
- 門店相關表
- 會員相關表
- 訂單相關表
- 營銷(組合套餐)
- 營銷(砍價)
- 營銷(優惠券)
- 營銷(限時折扣)
- 營銷(滿額包郵)
- 營銷(互動游戲)
- 營銷(團購)
- 營銷(滿減送)
- 營銷(拼團)
- 營銷(秒殺)
- 營銷(專題)
- 應用(分銷)
- 應用(店鋪筆記)
- 應用(小票打印)
- 應用(積分兌換)