數據庫表 · 便民精靈

~~~[sql] /* Navicat Premium Data Transfer Source Server : dfc Source Server Type : MySQL Source Server Version : 50717 Source Host : localhost:3306 Source Schema : convenient_people Target Server Type : MySQL Target Server Version : 50717 File Encoding : 65001 Date: 14/06/2018 17:47:29 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin_named_user -- ---------------------------- DROP TABLE IF EXISTS `admin_named_user`; CREATE TABLE `admin_named_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用戶名', `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密碼', `user_id` int(11) NOT NULL COMMENT '所屬用戶id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `user_id`(`user_id`) USING BTREE, UNIQUE INDEX `username`(`username`) USING BTREE, CONSTRAINT `admin_named_user_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '命名用戶登錄表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_oauth_user -- ---------------------------- DROP TABLE IF EXISTS `admin_oauth_user`; CREATE TABLE `admin_oauth_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'open_id', `type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '第三方登錄類型，qq、wechat等', `user_id` int(11) NOT NULL COMMENT '所屬用戶id', `ext` json NULL COMMENT '額外信息', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `type`(`type`, `open_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `admin_oauth_user_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '第三方登錄表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_phone_user -- ---------------------------- DROP TABLE IF EXISTS `admin_phone_user`; CREATE TABLE `admin_phone_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機號', `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密碼', `user_id` int(11) NOT NULL COMMENT '所屬用戶id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `user_id`(`user_id`) USING BTREE, UNIQUE INDEX `phone`(`phone`) USING BTREE, CONSTRAINT `admin_phone_user_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '手機號登錄表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_user_config -- ---------------------------- DROP TABLE IF EXISTS `admin_user_config`; CREATE TABLE `admin_user_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `configs` json NULL COMMENT '配置項', `user_id` int(11) NOT NULL COMMENT '所屬用戶', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `admin_user_config_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶配置信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_user_info -- ---------------------------- DROP TABLE IF EXISTS `admin_user_info`; CREATE TABLE `admin_user_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用戶昵稱', `recent_login_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后登錄', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for banner -- ---------------------------- DROP TABLE IF EXISTS `banner`; CREATE TABLE `banner` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '標題', `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '圖片地址', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '鏈接地址', `is_enable` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否啟用', `position` int(11) NOT NULL COMMENT '所在位置', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'banner' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for city -- ---------------------------- DROP TABLE IF EXISTS `city`; CREATE TABLE `city` ( `id` int(11) NOT NULL AUTO_INCREMENT, `province_id` int(10) UNSIGNED NOT NULL COMMENT '地級市id', `city_id` bigint(20) UNSIGNED NOT NULL COMMENT '縣級市id', `city_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `city_id`(`city_id`) USING BTREE, INDEX `province_id`(`province_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 348 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '縣級市數據庫' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for community -- ---------------------------- DROP TABLE IF EXISTS `community`; CREATE TABLE `community` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '小區名', `county_id` bigint(20) NOT NULL COMMENT '區域id', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理人姓名', `phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理人手機號', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '登錄密碼', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '小區狀態,啟用/凍結', `last_login_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后登錄時間', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `phone`(`phone`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小區' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for county -- ---------------------------- DROP TABLE IF EXISTS `county`; CREATE TABLE `county` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '地級市主鍵ID', `city_id` bigint(20) UNSIGNED NOT NULL COMMENT '地級市id', `county_id` bigint(20) UNSIGNED NOT NULL COMMENT '縣級id', `county_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `county_id`(`county_id`) USING BTREE, INDEX `city_id`(`city_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3140 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地區市數據庫' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for faq -- ---------------------------- DROP TABLE IF EXISTS `faq`; CREATE TABLE `faq` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '標題', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '答案內容', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常見問題及答疑' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for merchants -- ---------------------------- DROP TABLE IF EXISTS `merchants`; CREATE TABLE `merchants` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '合作人姓名', `phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機號', `address` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在地址', `business` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '合作業務', `remark` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '備注', `status` enum('pending','approve','refuse') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'pending' COMMENT '合作信息狀態', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '招商合作信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for message_content -- ---------------------------- DROP TABLE IF EXISTS `message_content`; CREATE TABLE `message_content` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站內信標題', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站內信內容', `receiver_group` enum('personal','admin','store','community','all','user','other') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '接收消息用戶組', `creator_type` enum('admin','user','store','community') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息發送人類型', `creator_id` int(11) NOT NULL COMMENT '發送人id', `link` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '跳轉鏈接', `delete_time` timestamp(0) NULL DEFAULT NULL COMMENT '標記刪除時間', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '站內信內容' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for migrations -- ---------------------------- DROP TABLE IF EXISTS `migrations`; CREATE TABLE `migrations` ( `version` bigint(20) NOT NULL, `migration_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `start_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `end_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `breakpoint` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`version`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for province -- ---------------------------- DROP TABLE IF EXISTS `province`; CREATE TABLE `province` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主鍵ID', `province_id` int(11) UNSIGNED NOT NULL COMMENT '省份id、省份編號', `province_name` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '省份名稱', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `provice_id`(`province_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '省份數據庫' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rbac_permissions -- ---------------------------- DROP TABLE IF EXISTS `rbac_permissions`; CREATE TABLE `rbac_permissions` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Lft` int(11) NOT NULL, `Rght` int(11) NOT NULL, `Title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`ID`) USING BTREE, INDEX `Lft`(`Lft`) USING BTREE, INDEX `Rght`(`Rght`) USING BTREE, INDEX `Title`(`Title`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rbac_rolepermissions -- ---------------------------- DROP TABLE IF EXISTS `rbac_rolepermissions`; CREATE TABLE `rbac_rolepermissions` ( `RoleID` int(11) NOT NULL, `PermissionID` int(11) NOT NULL, `AssignmentDate` int(11) NOT NULL, PRIMARY KEY (`RoleID`, `PermissionID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rbac_roles -- ---------------------------- DROP TABLE IF EXISTS `rbac_roles`; CREATE TABLE `rbac_roles` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Lft` int(11) NOT NULL, `Rght` int(11) NOT NULL, `Title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`ID`) USING BTREE, INDEX `Lft`(`Lft`) USING BTREE, INDEX `Rght`(`Rght`) USING BTREE, INDEX `Title`(`Title`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rbac_userroles -- ---------------------------- DROP TABLE IF EXISTS `rbac_userroles`; CREATE TABLE `rbac_userroles` ( `UserID` int(11) NOT NULL, `RoleID` int(11) NOT NULL, `AssignmentDate` int(11) NOT NULL, PRIMARY KEY (`UserID`, `RoleID`) USING BTREE, CONSTRAINT `rbac_userroles_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `admin_user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for service_items -- ---------------------------- DROP TABLE IF EXISTS `service_items`; CREATE TABLE `service_items` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '服務名', `icon` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手機圖標', `img` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '圖片', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否啟用', `parent_id` int(11) NULL DEFAULT NULL COMMENT '上級id', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '服務項目' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for store -- ---------------------------- DROP TABLE IF EXISTS `store`; CREATE TABLE `store` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '門店名', `address` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '詳細地址', `county_id` bigint(20) NOT NULL COMMENT '區域id', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '店長姓名', `phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '負責人手機號', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '登錄密碼', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '門店狀態,啟用/凍結', `service_id` int(11) NULL DEFAULT NULL COMMENT '服務項目id', `service_item` json NULL COMMENT '門店具體的服務項目', `extra` json NULL COMMENT '額外數據', `last_login_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后登錄時間', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `phone`(`phone`) USING BTREE, INDEX `service_id`(`service_id`) USING BTREE, CONSTRAINT `store_ibfk_1` FOREIGN KEY (`service_id`) REFERENCES `service_items` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '門店' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for system_config -- ---------------------------- DROP TABLE IF EXISTS `system_config`; CREATE TABLE `system_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `about` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '關于我們', `protocol` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平臺協議', `mall_url` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商城地址', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系統配置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for system_jobs -- ---------------------------- DROP TABLE IF EXISTS `system_jobs`; CREATE TABLE `system_jobs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `queue` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '隊列名稱，對應到命令行的 --queue', `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息內容，為json結構', `attempts` int(3) UNSIGNED NOT NULL COMMENT '任務已經嘗試的次數', `reserved` int(3) UNSIGNED NOT NULL COMMENT '任務是否處于執行中的狀態 0 未執行 1 已執行', `reserved_at` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '任務被標記為已執行中的狀態的時刻', `available_at` int(10) UNSIGNED NOT NULL COMMENT '該任務運行執行的最高時刻，用于任務的定時，任務的延遲執行', `created_at` int(10) UNSIGNED NOT NULL COMMENT '任務的創建時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消息隊列使用的表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_info -- ---------------------------- DROP TABLE IF EXISTS `user_info`; CREATE TABLE `user_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '頭像地址', `nickname` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵稱', `gender` enum('male','female','secret') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'secret' COMMENT '性別', `birthday` date NULL DEFAULT NULL COMMENT '生日', `signature` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '個性簽名', `last_login_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后登錄時間', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '用戶狀態，啟用/凍結', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_message -- ---------------------------- DROP TABLE IF EXISTS `user_message`; CREATE TABLE `user_message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `message_id` int(11) NOT NULL COMMENT '消息內容id', `receiver_type` enum('admin','user','store','community') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '接收者類型', `receiver_id` int(11) NOT NULL COMMENT '接收者id', `creator_type` enum('admin','user','store','community') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息發送人類型', `creator_id` int(11) NOT NULL COMMENT '發送人id', `is_read` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已讀', `delete_time` timestamp(0) NULL DEFAULT NULL COMMENT '標記刪除時間', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `message_id`(`message_id`) USING BTREE, CONSTRAINT `user_message_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `message_content` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶站內信' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_oauth_user -- ---------------------------- DROP TABLE IF EXISTS `user_oauth_user`; CREATE TABLE `user_oauth_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `open_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'open_id', `type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '第三方登錄類型，qq、wechat等', `user_id` int(11) NOT NULL COMMENT '所屬用戶id', `ext` json NULL COMMENT '額外信息', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `type`(`type`, `open_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_oauth_user_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶端第三方登錄表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_order -- ---------------------------- DROP TABLE IF EXISTS `user_order`; CREATE TABLE `user_order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '聯系人姓名', `phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '聯系人手機號', `store_id` int(11) NOT NULL COMMENT '門店id', `service_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '服務項目名', `user_id` int(11) NOT NULL COMMENT '用戶id', `status` enum('pending','receive','finish','cancel') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '訂單狀態', `cancel_type` enum('merchant','user','system','normal') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'normal' COMMENT '取消類型', `cancel_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '取消或者關閉原因', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在地址', `other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '其他說明', `receive_time` timestamp(0) NULL DEFAULT NULL COMMENT '商家接受時間', `finish_time` timestamp(0) NULL DEFAULT NULL COMMENT '完成時間', `extra` json NULL COMMENT '額外數據', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NULL DEFAULT NULL, `delete_time` timestamp(0) NULL DEFAULT NULL COMMENT '標記刪除時間', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_order_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶訂單' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_phone -- ---------------------------- DROP TABLE IF EXISTS `user_phone`; CREATE TABLE `user_phone` ( `id` int(11) NOT NULL AUTO_INCREMENT, `phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機號', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登錄密碼', `user_id` int(11) NOT NULL COMMENT '用戶id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `phone`(`phone`, `user_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_phone_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶登錄表' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; ~~~