```[sql]
-- ----------------------------
-- Table structure for ns_weapp_experiencer
-- ----------------------------
DROP TABLE IF EXISTS `ns_weapp_experiencer`;
CREATE TABLE `ns_weapp_experiencer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL COMMENT '站點id',
`wechatid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信號',
`userstr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信用戶唯一值',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加時間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 8192 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '微信小程序體驗者' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_weapp_goods
-- ----------------------------
DROP TABLE IF EXISTS `ns_weapp_goods`;
CREATE TABLE `ns_weapp_goods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL COMMENT '站點id',
`goods_id` int(11) NOT NULL COMMENT '小程序商品庫商品id 非商城商品id',
`name` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名稱',
`cover_img` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品圖片鏈接',
`price` decimal(10,2) NOT NULL COMMENT '商品價格',
`status` int(255) NOT NULL COMMENT '商品狀態,0:未審核。1:審核中,2:審核通過,3:審核駁回',
`url` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品小程序鏈接',
`audit_id` int(11) NOT NULL COMMENT '審核單id',
`sku_id` int(11) NOT NULL COMMENT '商品sku_id',
`third_party_tag` int(1) NOT NULL COMMENT '商品來源 0在小程序平臺添加的商品 1/2通過api添加的商品',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2340 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_weapp_live_room
-- ----------------------------
DROP TABLE IF EXISTS `ns_weapp_live_room`;
CREATE TABLE `ns_weapp_live_room` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL COMMENT '站點id',
`roomid` int(11) NOT NULL COMMENT '直播間id',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房間名稱',
`cover_img` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房間背景封面',
`share_img` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分享卡片圖片',
`start_time` int(11) NOT NULL COMMENT '直播計劃開始時間',
`end_time` int(11) NOT NULL COMMENT '直播計劃結束時間',
`anchor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主播昵稱',
`goods` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '直播間商品',
`live_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'live_status 101: 直播中, 102: 未開始, 103: 已結束, 104: 禁播, 105: 暫停中, 106: 異常, 107: 已過期',
`anchor_img` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主播頭像',
`banner` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '直播間橫幅',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1638 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序直播直播間表' ROW_FORMAT = Compact;
- 序言
- 商城簡介
- 代碼規范
- model層命名規范
- 前端(管理頁面)命名
- 控制器命名規范
- 入門指導
- 偽靜態配置
- 數據庫配置
- 系統環境
- 系統框架
- 目錄結構
- 數據庫操作
- 標準代碼(前端)
- 提示面板
- 表單
- 插件開發
- 插件目錄
- 插件開發說明
- 事件開發
- 常用事件
- 數據字典
- 系統基礎表
- 微信小程序相關
- 微信公眾號相關
- 配送相關表
- 商品相關表
- 店鋪網站設置相關
- 門店相關表
- 會員相關表
- 訂單相關表
- 營銷(組合套餐)
- 營銷(砍價)
- 營銷(優惠券)
- 營銷(限時折扣)
- 營銷(滿額包郵)
- 營銷(互動游戲)
- 營銷(團購)
- 營銷(滿減送)
- 營銷(拼團)
- 營銷(秒殺)
- 營銷(專題)
- 應用(分銷)
- 應用(店鋪筆記)
- 應用(小票打印)
- 應用(積分兌換)