```[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层命名规范
- 前端（管理页面）命名
- 控制器命名规范
- 入门指导
- 伪静态配置
- 数据库配置
- 系统环境
- 系统框架
- 目录结构
- 数据库操作
- 标准代码(前端)
- 提示面板
- 表单
- 插件开发
- 插件目录
- 插件开发说明
- 事件开发
- 常用事件
- 数据字典
- 系统基础表
- 微信小程序相关
- 微信公众号相关
- 配送相关表
- 商品相关表
- 店铺网站设置相关
- 门店相关表
- 会员相关表
- 订单相关表
- 营销（组合套餐）
- 营销（砍价）
- 营销（优惠券）
- 营销（限时折扣）
- 营销（满额包邮）
- 营销（互动游戏）
- 营销（团购）
- 营销（满减送）
- 营销（拼团）
- 营销（秒杀）
- 营销（专题）
- 应用（分销）
- 应用（店铺笔记）
- 应用（小票打印）
- 应用（积分兑换）