應用（店鋪筆記） · Niushop單商戶V5開發手冊

```[sql] -- ---------------------------- -- Table structure for ns_notes -- ---------------------------- DROP TABLE IF EXISTS `ns_notes`; CREATE TABLE `ns_notes` ( `note_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `note_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '筆記類型', `note_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '標題', `note_abstract` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '摘要', `group_id` int(11) NOT NULL DEFAULT 0 COMMENT '分組id', `cover_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '封面圖片類型（0單圖 1多圖）', `cover_img` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '封面圖片', `goods_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品id（根據類型判斷商品是單個還是多個）', `goods_highlights` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品亮點（單品有效）', `note_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '內容', `status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '狀態（0草稿箱 1發布）', `is_show_release_time` tinyint(1) NOT NULL DEFAULT 0 COMMENT '發布時間是否顯示', `is_show_read_num` tinyint(1) NOT NULL DEFAULT 0 COMMENT '閱讀數是否顯示', `is_show_dianzan_num` tinyint(1) NOT NULL COMMENT '點贊數是否顯示', `read_num` int(11) NOT NULL DEFAULT 0 COMMENT '閱讀數', `dianzan_num` int(11) NOT NULL DEFAULT 0 COMMENT '點贊數', `create_time` int(11) NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, `initial_read_num` int(11) NOT NULL DEFAULT 0 COMMENT '初始閱讀數', `initial_dianzan_num` int(11) NOT NULL DEFAULT 0 COMMENT '初始點贊數', PRIMARY KEY (`note_id`) USING BTREE, INDEX `IDX_ns_promotion_notes_group_id`(`group_id`) USING BTREE, INDEX `IDX_ns_promotion_notes_site_id`(`site_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1638 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '店鋪筆記' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_notes_dianzan_record -- ---------------------------- DROP TABLE IF EXISTS `ns_notes_dianzan_record`; CREATE TABLE `ns_notes_dianzan_record` ( `record_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `note_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '分組名稱', PRIMARY KEY (`record_id`) USING BTREE, INDEX `IDX_ns_notes_dianzan_record_member_id`(`member_id`) USING BTREE, INDEX `IDX_ns_notes_dianzan_record_note_id`(`note_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 5461 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '筆記點贊記錄' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_notes_group -- ---------------------------- DROP TABLE IF EXISTS `ns_notes_group`; CREATE TABLE `ns_notes_group` ( `group_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `group_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分組名稱', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `notes_num` int(11) NOT NULL DEFAULT 0 COMMENT '筆記數', `release_num` int(11) NOT NULL DEFAULT 0 COMMENT '發布數', `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`group_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2730 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '筆記分組' ROW_FORMAT = Compact;