可視化sql · 超神宿數據庫

~~~[sql] /* Navicat Premium Data Transfer Source Server : dfc Source Server Type : MySQL Source Server Version : 50717 Source Host : localhost:3306 Source Schema : chaoshensu Target Server Type : MySQL Target Server Version : 50717 File Encoding : 65001 Date: 14/06/2018 17:32:40 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin_record -- ---------------------------- DROP TABLE IF EXISTS `admin_record`; CREATE TABLE `admin_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) NOT NULL COMMENT '管理id', `content` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作內容', `record` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作記錄id', `result` tinyint(4) NOT NULL COMMENT '操作結果', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作時間', PRIMARY KEY (`id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, CONSTRAINT `admin_record_ibfk_1` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 90 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理操作記錄' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_user -- ---------------------------- DROP TABLE IF EXISTS `admin_user`; CREATE TABLE `admin_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機號', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密碼', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `last_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次登錄時間', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '狀態', `session_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登錄session_id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_admin_phone`(`phone`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理員' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for area_range -- ---------------------------- DROP TABLE IF EXISTS `area_range`; CREATE TABLE `area_range` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '篩選名稱', `min_area` int(11) NOT NULL COMMENT '最小面積', `max_area` int(11) NOT NULL COMMENT '最大面積', `order` int(11) NOT NULL COMMENT '前端排序', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_area_order`(`order`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 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(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '標題', `img` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '圖片地址', `url` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '圖片路徑', `order` int(11) NOT NULL COMMENT '圖片排序', `show` tinyint(4) NOT NULL COMMENT '圖片是否在前端顯示', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加/發布時間', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_show`(`show`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'banner' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for browsing_history -- ---------------------------- DROP TABLE IF EXISTS `browsing_history`; CREATE TABLE `browsing_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用戶id', `h_i_id` int(11) NOT NULL COMMENT '房源id', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '瀏覽時間', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `h_i_id`(`h_i_id`) USING BTREE, CONSTRAINT `browsing_history_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `browsing_history_ibfk_2` FOREIGN KEY (`h_i_id`) REFERENCES `house_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 81 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '瀏覽記錄' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for city -- ---------------------------- DROP TABLE IF EXISTS `city`; CREATE TABLE `city` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '市名', `province_id` int(11) NOT NULL COMMENT '省id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_city_name`(`name`) USING BTREE, INDEX `province_id`(`province_id`) USING BTREE, CONSTRAINT `city_ibfk_1` FOREIGN KEY (`province_id`) REFERENCES `province` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '市' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for collect -- ---------------------------- DROP TABLE IF EXISTS `collect`; CREATE TABLE `collect` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用戶id', `h_i_id` int(11) NOT NULL COMMENT '房源id', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '收藏時間', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `h_i_id`(`h_i_id`) USING BTREE, CONSTRAINT `collect_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `collect_ibfk_2` FOREIGN KEY (`h_i_id`) REFERENCES `house_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_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, `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '小區名稱', `county_id` int(11) NOT NULL COMMENT '所在地區', `source` tinyint(4) NOT NULL COMMENT '來源', `landmark_id` int(11) NOT NULL COMMENT '對應的地標', `address` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '小區詳細地址', `longitude` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在經度', `latitude` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在緯度', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `sale_id` int(11) NULL DEFAULT NULL COMMENT '銷售id', `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_xq_name`(`name`) USING BTREE, INDEX `county_id`(`county_id`) USING BTREE, INDEX `landmark_id`(`landmark_id`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, CONSTRAINT `community_ibfk_1` FOREIGN KEY (`county_id`) REFERENCES `county` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `community_ibfk_2` FOREIGN KEY (`landmark_id`) REFERENCES `landmark` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `community_ibfk_3` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `community_ibfk_4` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小區信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for config -- ---------------------------- DROP TABLE IF EXISTS `config`; CREATE TABLE `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 '協議', `watermark` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '水印', `deposit` bigint(20) NOT NULL COMMENT '看房押金', `allot_mode` tinyint(4) NOT NULL COMMENT '派單方式', `p_min` bigint(20) NOT NULL COMMENT '物業推薦最低傭金', `p_max` bigint(20) NOT NULL COMMENT '物業推薦最高傭金', `p_num` int(11) NOT NULL COMMENT '物業每天開門獲利上限', `h_deposit` bigint(20) NOT NULL COMMENT '租房訂金', `expire_day` int(11) NOT NULL COMMENT '租房到期提前提醒', `lock_time` int(11) NOT NULL COMMENT '電子鎖到期時間', `show_time` int(11) NOT NULL COMMENT '看房時間', `over_time` int(11) NOT NULL COMMENT '超過時間', `amount` bigint(20) NOT NULL COMMENT '扣除押金', `deal_sum` bigint(20) NOT NULL DEFAULT 0 COMMENT '成交獎勵金', `overdue_day` tinyint(4) NOT NULL DEFAULT 1 COMMENT '租房逾期天數', `rent_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '租住須知', `refund_explanation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '退款說明', `deposit_refund` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '押金退還事項', `extra_charge` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '額外收費說明', `long_rent_refund` text 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 cooperation_company -- ---------------------------- DROP TABLE IF EXISTS `cooperation_company`; CREATE TABLE `cooperation_company` ( `id` int(11) NOT NULL AUTO_INCREMENT, `company_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司名', `company_address` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司詳細地址', `principal_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '負責人姓名', `principal_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '負責人手機號', `account_type` tinyint(4) NOT NULL COMMENT '賬戶類型', `account_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '賬戶姓名', `account_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '開戶支行', `account` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收款賬號', `s_time` date NOT NULL COMMENT '合作開始時間', `e_time` date NOT NULL COMMENT '合作結束時間', `divided_way` tinyint(4) NOT NULL COMMENT '分利方式', `day_money` bigint(20) NOT NULL DEFAULT 0 COMMENT '按天的金額', `proportion` int(11) NOT NULL DEFAULT 0 COMMENT '比例數據', `cooperation_deposit` bigint(20) NOT NULL DEFAULT 0 COMMENT '合作押金', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `sale_id` int(11) NULL DEFAULT NULL COMMENT '銷售id', `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理id', PRIMARY KEY (`id`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, CONSTRAINT `cooperation_company_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `cooperation_company_ibfk_2` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合作公司信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cooperation_sale -- ---------------------------- DROP TABLE IF EXISTS `cooperation_sale`; CREATE TABLE `cooperation_sale` ( `id` int(11) NOT NULL AUTO_INCREMENT, `store_id` int(11) NOT NULL COMMENT '門店id', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '銷售姓名', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機號', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '銷售狀態', `sale_id` int(11) NULL DEFAULT NULL COMMENT '銷售id', `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_c_sale_phone`(`phone`) USING BTREE, INDEX `idx_c_sale_name`(`name`) USING BTREE, INDEX `idx_c_sale_status`(`status`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, INDEX `store_id`(`store_id`) USING BTREE, CONSTRAINT `cooperation_sale_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `cooperation_sale_ibfk_2` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `cooperation_sale_ibfk_3` FOREIGN KEY (`store_id`) REFERENCES `cooperation_store` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合作公司下的銷售信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cooperation_sale_info -- ---------------------------- DROP TABLE IF EXISTS `cooperation_sale_info`; CREATE TABLE `cooperation_sale_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sale_id` int(11) NOT NULL COMMENT '銷售id', `openid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `photo` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '頭像', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機號', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登錄密碼', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '銷售狀態', `session_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登錄狀態', `nickname` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵稱', `last_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次登錄時間', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `sex` tinyint(4) NOT NULL DEFAULT 0 COMMENT '性別', PRIMARY KEY (`id`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, CONSTRAINT `cooperation_sale_info_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `cooperation_sale` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合作銷售個人資料' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cooperation_sale_mail -- ---------------------------- DROP TABLE IF EXISTS `cooperation_sale_mail`; CREATE TABLE `cooperation_sale_mail` ( `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 '內容', `send_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '發送時間', `c_sale_id` int(11) NOT NULL COMMENT '銷售id', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否閱讀', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_cxs_title`(`title`) USING BTREE, INDEX `c_sale_id`(`c_sale_id`) USING BTREE, CONSTRAINT `cooperation_sale_mail_ibfk_1` FOREIGN KEY (`c_sale_id`) REFERENCES `cooperation_sale` (`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 cooperation_store -- ---------------------------- DROP TABLE IF EXISTS `cooperation_store`; CREATE TABLE `cooperation_store` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '門店名', `county_id` int(11) NOT NULL COMMENT '門店地址', `address` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '門店詳細地址', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '店長姓名', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '店長手機號', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登錄密碼', `session_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登錄狀態', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '用戶狀態', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `last_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次登錄時間', `company_id` int(11) NOT NULL COMMENT '公司id', `sale_id` int(11) NULL DEFAULT NULL COMMENT '銷售id', `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理id', PRIMARY KEY (`id`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, INDEX `company_id`(`company_id`) USING BTREE, INDEX `county_id`(`county_id`) USING BTREE, CONSTRAINT `cooperation_store_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `cooperation_store_ibfk_2` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `cooperation_store_ibfk_3` FOREIGN KEY (`company_id`) REFERENCES `cooperation_company` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `cooperation_store_ibfk_4` FOREIGN KEY (`county_id`) REFERENCES `county` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 9 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, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '縣(區)名', `city_id` int(11) NOT NULL COMMENT '市id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_county_name`(`name`) USING BTREE, INDEX `city_id`(`city_id`) USING BTREE, CONSTRAINT `county_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '縣(區)' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for door_lock -- ---------------------------- DROP TABLE IF EXISTS `door_lock`; CREATE TABLE `door_lock` ( `id` int(11) NOT NULL AUTO_INCREMENT, `h_i_id` int(11) NOT NULL COMMENT '房源id', `r_id` int(11) NULL DEFAULT NULL COMMENT '房間id', `sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '電子鎖序號', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '完善時間', `status` tinyint(4) NOT NULL DEFAULT 0, `password` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '電子鎖密碼', PRIMARY KEY (`id`) USING BTREE, INDEX `h_i_id`(`h_i_id`) USING BTREE, CONSTRAINT `door_lock_ibfk_1` FOREIGN KEY (`h_i_id`) REFERENCES `house_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '電子鎖' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for entrust_contract -- ---------------------------- DROP TABLE IF EXISTS `entrust_contract`; CREATE TABLE `entrust_contract` ( `id` int(11) NOT NULL AUTO_INCREMENT, `l_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房東姓名', `l_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房東手機號', `l_id_card` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房東身份證號', `h_address` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房源詳細地址', `r_s_time` datetime(0) NOT NULL COMMENT '租房開始時間', `r_e_time` datetime(0) NOT NULL COMMENT '租房結束時間', `p_time` json NOT NULL COMMENT '付款時間段', `is_pay` tinyint(4) NOT NULL COMMENT '是否代繳水電氣', `is_settle` tinyint(4) NOT NULL COMMENT '水電氣是否結清', `water` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '水初始值', `electric` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '電初始值', `gas` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '氣初始值', `s_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '監督電話', `a_type` tinyint(4) NOT NULL COMMENT '賬戶類型', `c_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司名/個人名', `p_m` tinyint(4) NOT NULL COMMENT '收款方式', `payee` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收款人姓名', `account` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收款人賬號', `h_i_id` int(11) NOT NULL COMMENT '房源id', `r_id` int(11) NULL DEFAULT NULL COMMENT '房間id', `r_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租客姓名', `r_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租客手機號', `r_id_card` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租客身份證號', `facility` json NULL COMMENT '房間設施', `other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其他說明', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '完善時間', PRIMARY KEY (`id`) USING BTREE, INDEX `h_i_id`(`h_i_id`) USING BTREE, INDEX `r_id`(`r_id`) USING BTREE, CONSTRAINT `entrust_contract_ibfk_1` FOREIGN KEY (`h_i_id`) REFERENCES `house_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `entrust_contract_ibfk_2` FOREIGN KEY (`r_id`) REFERENCES `room` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '租前合同' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for external_long_commission -- ---------------------------- DROP TABLE IF EXISTS `external_long_commission`; CREATE TABLE `external_long_commission` ( `id` int(11) NOT NULL AUTO_INCREMENT, `min` bigint(20) NOT NULL COMMENT '最低租金', `max` bigint(20) NOT NULL COMMENT '最高租金', `proportion` tinyint(4) NOT NULL COMMENT '提成比例', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '外部長租提成' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for external_short_commission -- ---------------------------- DROP TABLE IF EXISTS `external_short_commission`; CREATE TABLE `external_short_commission` ( `id` int(11) NOT NULL AUTO_INCREMENT, `min` bigint(20) NOT NULL COMMENT '最低租金', `max` bigint(20) NOT NULL COMMENT '最高租金', `proportion` tinyint(4) NOT NULL COMMENT '提成比例', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_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 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 house_entrust -- ---------------------------- DROP TABLE IF EXISTS `house_entrust`; CREATE TABLE `house_entrust` ( `id` int(11) NOT NULL AUTO_INCREMENT, `province_id` int(11) NOT NULL COMMENT '省id', `h_province` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在省名', `city_id` int(11) NOT NULL COMMENT '市id', `h_city` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在市名', `county_id` int(11) NOT NULL COMMENT '區id', `h_county` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在區名', `landmark_id` int(11) NULL DEFAULT NULL COMMENT '地標id', `h_landmark` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地標名稱', `community_id` int(11) NULL DEFAULT NULL COMMENT '小區id', `h_community` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '小區名稱', `h_unit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '小區單元', `h_swap` tinyint(4) NOT NULL DEFAULT 1 COMMENT '是否可調換', `metro_id` int(11) NULL DEFAULT NULL COMMENT '地鐵線路id', `h_metro` int(11) NULL DEFAULT NULL COMMENT '地鐵線路', `site_id` int(11) NULL DEFAULT NULL COMMENT '站點id', `h_site` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地鐵站點名', `h_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房源戶型', `h_floor` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在樓層', `h_fitment` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房源裝修', `h_sex` tinyint(4) NOT NULL DEFAULT 2 COMMENT '性別限制', `h_area` int(11) NOT NULL COMMENT '房源面積', `r_mode` int(11) NOT NULL COMMENT '出租方式', `h_rent` bigint(20) NOT NULL COMMENT '期望租金', `l_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房東姓名', `l_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房東電話', `h_facilities` json NULL COMMENT '配套設施', `other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其他說明', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '委托時間', `source` tinyint(4) NOT NULL COMMENT '來源', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '房源狀態', `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理id', `sale_id` int(11) NULL DEFAULT NULL COMMENT '銷售id', `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id', `property_id` int(11) NULL DEFAULT NULL COMMENT '物業id', `g_sale_id` int(11) NULL DEFAULT NULL COMMENT '內部負責銷售', `audit_time` timestamp(0) NULL DEFAULT NULL COMMENT '審核時間', `c_sale_id` int(11) NULL DEFAULT NULL COMMENT '第三方負責銷售', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_h_source`(`source`) USING BTREE, INDEX `idx_h_status`(`status`) USING BTREE, INDEX `province_id`(`province_id`) USING BTREE, INDEX `city_id`(`city_id`) USING BTREE, INDEX `county_id`(`county_id`) USING BTREE, INDEX `landmark_id`(`landmark_id`) USING BTREE, INDEX `community_id`(`community_id`) USING BTREE, INDEX `metro_id`(`metro_id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `property_id`(`property_id`) USING BTREE, INDEX `g_sale_id`(`g_sale_id`) USING BTREE, INDEX `c_sale_id`(`c_sale_id`) USING BTREE, CONSTRAINT `house_entrust_ibfk_1` FOREIGN KEY (`province_id`) REFERENCES `province` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_10` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_11` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_12` FOREIGN KEY (`g_sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_13` FOREIGN KEY (`c_sale_id`) REFERENCES `cooperation_sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_14` FOREIGN KEY (`landmark_id`) REFERENCES `landmark` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_15` FOREIGN KEY (`community_id`) REFERENCES `community` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_2` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_3` FOREIGN KEY (`county_id`) REFERENCES `county` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_6` FOREIGN KEY (`metro_id`) REFERENCES `metro` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_7` FOREIGN KEY (`site_id`) REFERENCES `metro_site` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_8` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_entrust_ibfk_9` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 50 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '房屋委托' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for house_info -- ---------------------------- DROP TABLE IF EXISTS `house_info`; CREATE TABLE `house_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `h_video` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '視頻地址', `h_img` json NULL COMMENT '房間圖片', `r_mode` int(11) NOT NULL COMMENT '出租方式', `h_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房源名稱', `province_id` int(11) NOT NULL COMMENT '省id', `h_province` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在省名', `city_id` int(11) NOT NULL COMMENT '市id', `h_city` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在市名', `county_id` int(11) NOT NULL COMMENT '區id', `h_county` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在區名', `landmark_id` int(11) NULL DEFAULT NULL COMMENT '地標id', `h_landmark` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地標名稱', `community_id` int(11) NULL DEFAULT NULL COMMENT '小區id', `h_community` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '小區名稱', `h_unit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '小區單元', `metro_id` int(11) NULL DEFAULT NULL COMMENT '地鐵線路id', `h_metro` int(11) NULL DEFAULT NULL COMMENT '地鐵線路', `site_id` int(11) NULL DEFAULT NULL COMMENT '站點id', `h_site` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地鐵站點名', `h_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房源戶型', `h_floor` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在樓層', `h_fitment` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房源裝修', `h_sex` tinyint(4) NOT NULL COMMENT '性別限制', `h_swap` tinyint(4) NOT NULL COMMENT '是否可調換', `h_contract` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否完善房源合同', `h_is_d_b` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否需要門禁', `h_area` int(11) NOT NULL COMMENT '房源面積', `h_facilities` json NULL COMMENT '配套設施', `h_l_rent` bigint(20) NULL DEFAULT NULL COMMENT '長租租金', `h_s_rent` bigint(20) NULL DEFAULT NULL COMMENT '短租租金', `h_l_p_m` int(11) NULL DEFAULT NULL COMMENT '長租支付方式', `h_l_p_n` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '長租支付方式名', `h_s_p_m` json NULL COMMENT '短租支付方式', `other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其他說明', `h_p_c_id` int(11) NULL DEFAULT NULL COMMENT '物業公司id', `h_p_id` int(11) NULL DEFAULT NULL COMMENT '物業人員id', `is_empower` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否授權開門', `source` tinyint(4) NOT NULL COMMENT '來源', `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理id', `sale_id` int(11) NULL DEFAULT NULL COMMENT '銷售id', `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id', `property_id` int(11) NULL DEFAULT NULL COMMENT '物業id', `g_sale_id` int(11) NULL DEFAULT NULL COMMENT '內部負責銷售', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '房源狀態', `commission` bigint(20) NOT NULL DEFAULT 0 COMMENT '人員傭金', `h_toward` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房屋朝向', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '完善時間', `audit` tinyint(4) NOT NULL DEFAULT 0 COMMENT '審核狀態', `guard` json NULL COMMENT '門衛資料', `h_e_id` int(11) NULL DEFAULT NULL COMMENT '房源id', `h_is_look` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否完善電子鎖', `s_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上架時間', `c_sale_id` int(11) NULL DEFAULT NULL COMMENT '第三方負責銷售', `is_all_pay` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否全付', `special` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否是特殊房源', `special_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '特殊房源備注', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_h_source`(`source`) USING BTREE, INDEX `idx_h_status`(`status`) USING BTREE, INDEX `idx_h_audit`(`audit`) USING BTREE, INDEX `province_id`(`province_id`) USING BTREE, INDEX `city_id`(`city_id`) USING BTREE, INDEX `county_id`(`county_id`) USING BTREE, INDEX `landmark_id`(`landmark_id`) USING BTREE, INDEX `community_id`(`community_id`) USING BTREE, INDEX `metro_id`(`metro_id`) USING BTREE, INDEX `site_id`(`site_id`) USING BTREE, INDEX `h_e_id`(`h_e_id`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `property_id`(`property_id`) USING BTREE, INDEX `g_sale_id`(`g_sale_id`) USING BTREE, INDEX `h_p_c_id`(`h_p_c_id`) USING BTREE, INDEX `h_p_id`(`h_p_id`) USING BTREE, INDEX `h_l_p_m`(`h_l_p_m`) USING BTREE, INDEX `c_sale_id`(`c_sale_id`) USING BTREE, CONSTRAINT `house_info_ibfk_1` FOREIGN KEY (`province_id`) REFERENCES `province` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_10` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_11` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_12` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_13` FOREIGN KEY (`g_sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_14` FOREIGN KEY (`h_p_c_id`) REFERENCES `property_company` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_15` FOREIGN KEY (`h_p_id`) REFERENCES `property` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_16` FOREIGN KEY (`h_l_p_m`) REFERENCES `payment_method` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_17` FOREIGN KEY (`c_sale_id`) REFERENCES `cooperation_sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_18` FOREIGN KEY (`landmark_id`) REFERENCES `landmark` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_19` FOREIGN KEY (`community_id`) REFERENCES `community` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_2` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_3` FOREIGN KEY (`county_id`) REFERENCES `county` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_6` FOREIGN KEY (`metro_id`) REFERENCES `metro` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_7` FOREIGN KEY (`site_id`) REFERENCES `metro_site` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_8` FOREIGN KEY (`h_e_id`) REFERENCES `house_entrust` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `house_info_ibfk_9` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '房源信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for house_type -- ---------------------------- DROP TABLE IF EXISTS `house_type`; CREATE TABLE `house_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '戶型名', `order` int(11) NOT NULL COMMENT '前端排序', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_type_order`(`order`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '房屋戶型' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for internal_long_commission -- ---------------------------- DROP TABLE IF EXISTS `internal_long_commission`; CREATE TABLE `internal_long_commission` ( `id` int(11) NOT NULL AUTO_INCREMENT, `min` bigint(20) NOT NULL COMMENT '最低租金', `max` bigint(20) NOT NULL COMMENT '最高租金', `proportion` tinyint(4) NOT NULL COMMENT '提成比例', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 87 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '內部長租提成' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for internal_short_commission -- ---------------------------- DROP TABLE IF EXISTS `internal_short_commission`; CREATE TABLE `internal_short_commission` ( `id` int(11) NOT NULL AUTO_INCREMENT, `min` bigint(20) NOT NULL COMMENT '最低租金', `max` bigint(20) NOT NULL COMMENT '最高租金', `proportion` tinyint(4) NOT NULL COMMENT '提成比例', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '內部短租提成' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for landmark -- ---------------------------- DROP TABLE IF EXISTS `landmark`; CREATE TABLE `landmark` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '地標名', `longitude` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在經度', `latitude` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在緯度', `county_id` int(11) NOT NULL COMMENT '區id', PRIMARY KEY (`id`) USING BTREE, INDEX `county_id`(`county_id`) USING BTREE, CONSTRAINT `landmark_ibfk_1` FOREIGN KEY (`county_id`) REFERENCES `county` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '地標' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for lease_time -- ---------------------------- DROP TABLE IF EXISTS `lease_time`; CREATE TABLE `lease_time` ( `id` int(11) NOT NULL AUTO_INCREMENT, `month` int(11) NOT NULL COMMENT '租住月數', `order` int(11) NOT NULL COMMENT '排列順序', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_lease_order`(`order`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '長租周期設置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for life_pay -- ---------------------------- DROP TABLE IF EXISTS `life_pay`; CREATE TABLE `life_pay` ( `id` int(11) NOT NULL AUTO_INCREMENT, `c_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '繳費中文名稱', `e_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '繳費英文名稱', `min_sum` bigint(20) NOT NULL COMMENT '繳費最低金額', `order` int(11) NOT NULL COMMENT '前端排序', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_pay_order`(`order`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '生活繳費' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for look_house -- ---------------------------- DROP TABLE IF EXISTS `look_house`; CREATE TABLE `look_house` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用戶id', `h_i_id` int(11) NOT NULL COMMENT '房源id', `r_id` int(11) NULL DEFAULT NULL COMMENT '房間id', `property_id` int(11) NULL DEFAULT NULL COMMENT '物業人員id', `sale_id` int(11) NULL DEFAULT NULL COMMENT '負責銷售id', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '狀態', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '申請時間', `k_time` timestamp(0) NULL DEFAULT NULL COMMENT '開門時間', `c_time` timestamp(0) NULL DEFAULT NULL COMMENT '關門時間', `end_time` timestamp(0) NULL DEFAULT NULL COMMENT '結束看房時間', `mode` tinyint(4) NOT NULL DEFAULT 0 COMMENT '開門方式', `c_sale_id` int(11) NULL DEFAULT NULL COMMENT '第三方負責銷售', `sum` bigint(20) NOT NULL DEFAULT 0 COMMENT '看房費用', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `h_i_id`(`h_i_id`) USING BTREE, INDEX `r_id`(`r_id`) USING BTREE, INDEX `property_id`(`property_id`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, INDEX `c_sale_id`(`c_sale_id`) USING BTREE, CONSTRAINT `look_house_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `look_house_ibfk_2` FOREIGN KEY (`h_i_id`) REFERENCES `house_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `look_house_ibfk_3` FOREIGN KEY (`r_id`) REFERENCES `room` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `look_house_ibfk_4` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `look_house_ibfk_5` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `look_house_ibfk_6` FOREIGN KEY (`c_sale_id`) REFERENCES `cooperation_sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 254 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '申請看房' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for mail -- ---------------------------- DROP TABLE IF EXISTS `mail`; CREATE TABLE `mail` ( `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 '內容', `send_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '發送時間', `type` tinyint(4) 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 metro -- ---------------------------- DROP TABLE IF EXISTS `metro`; CREATE TABLE `metro` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city_id` int(11) NOT NULL COMMENT '所在市', `name` int(11) NOT NULL COMMENT '線路名稱', `order` int(11) NOT NULL COMMENT '排列順序', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_metro_order`(`order`) USING BTREE, INDEX `city_id`(`city_id`) USING BTREE, CONSTRAINT `metro_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `city` (`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 metro_site -- ---------------------------- DROP TABLE IF EXISTS `metro_site`; CREATE TABLE `metro_site` ( `id` int(11) NOT NULL AUTO_INCREMENT, `metro_id` int(11) NOT NULL COMMENT '所屬地鐵線路', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站點名稱', `order` int(11) NOT NULL COMMENT '排列順序', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_site_order`(`order`) USING BTREE, INDEX `metro_id`(`metro_id`) USING BTREE, CONSTRAINT `metro_site_ibfk_1` FOREIGN KEY (`metro_id`) REFERENCES `metro` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 7 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 open_the_record -- ---------------------------- DROP TABLE IF EXISTS `open_the_record`; CREATE TABLE `open_the_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NULL DEFAULT NULL COMMENT '用戶id', `property_id` int(11) NULL DEFAULT NULL COMMENT '物業id', `d_id` int(11) NOT NULL COMMENT '電子鎖id', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '開門時間', `mode` tinyint(255) NULL DEFAULT 0, `password` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '電子鎖密碼', `status` tinyint(4) NOT NULL COMMENT '開鎖狀態 0 已開 1 失敗', `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '失敗原因', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `property_id`(`property_id`) USING BTREE, INDEX `d_id`(`d_id`) USING BTREE, CONSTRAINT `open_the_record_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `open_the_record_ibfk_2` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `open_the_record_ibfk_3` FOREIGN KEY (`d_id`) REFERENCES `door_lock` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 128 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '房源每日統計' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for payment_method -- ---------------------------- DROP TABLE IF EXISTS `payment_method`; CREATE TABLE `payment_method` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支付方式名稱', `rent` int(11) NOT NULL COMMENT '繳納租金月數', `bet` int(11) NOT NULL COMMENT '繳納押金月數', `order` int(11) NOT NULL COMMENT '排列順序', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_method_order`(`order`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付方式設置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for property -- ---------------------------- DROP TABLE IF EXISTS `property`; CREATE TABLE `property` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機號', `landline` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '座機號', `source` tinyint(4) NOT NULL COMMENT '來源', `p_c_id` int(11) NOT NULL COMMENT '所屬物業公司', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `sale_id` int(11) NULL DEFAULT NULL COMMENT '銷售id', `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理id', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '物業狀態', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_wyry_phone_name`(`phone`) USING BTREE, INDEX `idx_wyry_name`(`name`) USING BTREE, INDEX `idx_wyry_status`(`status`) USING BTREE, INDEX `p_c_id`(`p_c_id`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, CONSTRAINT `property_ibfk_1` FOREIGN KEY (`p_c_id`) REFERENCES `property_company` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `property_ibfk_2` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `property_ibfk_3` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物業人員' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for property_balance -- ---------------------------- DROP TABLE IF EXISTS `property_balance`; CREATE TABLE `property_balance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `property_id` int(11) NOT NULL COMMENT '物業id', `sum` bigint(20) NOT NULL DEFAULT 0 COMMENT '余額金額', PRIMARY KEY (`id`) USING BTREE, INDEX `property_id`(`property_id`) USING BTREE, CONSTRAINT `property_balance_ibfk_1` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物業余額' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for property_cash -- ---------------------------- DROP TABLE IF EXISTS `property_cash`; CREATE TABLE `property_cash` ( `id` int(11) NOT NULL AUTO_INCREMENT, `property_id` int(11) NOT NULL COMMENT '物業id', `sum` bigint(20) NOT NULL DEFAULT 0 COMMENT '提現金額', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '狀態', `a_type` tinyint(4) NULL DEFAULT NULL COMMENT '提現賬戶類型', `account` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提現賬號', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '申請提現時間', PRIMARY KEY (`id`) USING BTREE, INDEX `property_id`(`property_id`) USING BTREE, CONSTRAINT `property_cash_ibfk_1` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物業提現記錄' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for property_company -- ---------------------------- DROP TABLE IF EXISTS `property_company`; CREATE TABLE `property_company` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司名稱', `source` tinyint(4) NOT NULL COMMENT '來源', `community_id` int(11) NULL DEFAULT NULL COMMENT '關聯小區', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `sale_id` int(11) NULL DEFAULT NULL COMMENT '銷售id', `admin_id` int(11) NULL DEFAULT NULL COMMENT '管理id', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_wygs_name`(`name`) USING BTREE, INDEX `community_id`(`community_id`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, CONSTRAINT `property_company_ibfk_1` FOREIGN KEY (`community_id`) REFERENCES `community` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `property_company_ibfk_2` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `property_company_ibfk_3` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物業公司' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for property_income_log -- ---------------------------- DROP TABLE IF EXISTS `property_income_log`; CREATE TABLE `property_income_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `source` tinyint(4) NOT NULL COMMENT '收入來源', `sum` bigint(20) NOT NULL COMMENT '收入金額', `property_id` int(11) NOT NULL COMMENT '物業id', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '充值時間', PRIMARY KEY (`id`) USING BTREE, INDEX `property_id`(`property_id`) USING BTREE, CONSTRAINT `property_income_log_ibfk_1` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物業收入記錄' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for property_info -- ---------------------------- DROP TABLE IF EXISTS `property_info`; CREATE TABLE `property_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `property_id` int(11) NOT NULL COMMENT '物業人員id', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機號', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登錄密碼', `landline` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '座機號', `openid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `photo` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '頭像地址', `nickname` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵稱', `introduce` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '個人介紹', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '狀態', `session_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登錄狀態', `sex` tinyint(4) NOT NULL DEFAULT 0 COMMENT '性別', `last_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次登錄時間', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注冊時間', PRIMARY KEY (`id`) USING BTREE, INDEX `property_id`(`property_id`) USING BTREE, CONSTRAINT `property_info_ibfk_1` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物業人員資料' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for property_mail -- ---------------------------- DROP TABLE IF EXISTS `property_mail`; CREATE TABLE `property_mail` ( `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 '內容', `send_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '發送時間', `property_id` int(11) NOT NULL COMMENT '物業人員id', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否閱讀', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_wy_title`(`title`) USING BTREE, INDEX `property_id`(`property_id`) USING BTREE, CONSTRAINT `property_mail_ibfk_1` FOREIGN KEY (`property_id`) REFERENCES `property` (`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 property_reward -- ---------------------------- DROP TABLE IF EXISTS `property_reward`; CREATE TABLE `property_reward` ( `id` int(11) NOT NULL AUTO_INCREMENT, `s_num` int(11) NOT NULL COMMENT '開始次數', `e_num` int(11) NOT NULL COMMENT '結束次數', `sum` bigint(20) NOT NULL COMMENT '收入金額', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '物業開門獎勵設置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for province -- ---------------------------- DROP TABLE IF EXISTS `province`; CREATE TABLE `province` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '省名', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_province_name`(`name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_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 = 78 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 = 3 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` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rent_range -- ---------------------------- DROP TABLE IF EXISTS `rent_range`; CREATE TABLE `rent_range` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '篩選名稱', `min_rent` bigint(20) NOT NULL COMMENT '最小租金', `max_rent` bigint(20) NOT NULL COMMENT '最大租金', `order` int(11) NOT NULL COMMENT '前端排序', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_rent_order`(`order`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '租金區間' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for room -- ---------------------------- DROP TABLE IF EXISTS `room`; CREATE TABLE `room` ( `id` int(11) NOT NULL AUTO_INCREMENT, `r_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房間名', `h_i_id` int(11) NOT NULL COMMENT '房源id', `r_area` int(11) NOT NULL COMMENT '房間面積', `h_l_rent` bigint(20) NULL DEFAULT NULL COMMENT '長租租金', `h_s_rent` bigint(20) NULL DEFAULT NULL COMMENT '短租租金', `h_l_p_m` int(11) NULL DEFAULT NULL COMMENT '長租支付方式', `h_l_p_n` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '長租支付方式名', `h_s_p_m` json NULL COMMENT '短租支付方式', `h_facilities` json NULL COMMENT '配套設施', `h_toward` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房屋朝向', `h_fitment` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房間裝修', `h_sex` tinyint(4) NOT NULL COMMENT '性別限制', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '房間狀態', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '完善時間', `is_all_pay` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否全付', PRIMARY KEY (`id`) USING BTREE, INDEX `h_i_id`(`h_i_id`) USING BTREE, INDEX `h_l_p_m`(`h_l_p_m`) USING BTREE, CONSTRAINT `room_ibfk_1` FOREIGN KEY (`h_i_id`) REFERENCES `house_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `room_ibfk_2` FOREIGN KEY (`h_l_p_m`) REFERENCES `payment_method` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '房間信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for room_supplies -- ---------------------------- DROP TABLE IF EXISTS `room_supplies`; CREATE TABLE `room_supplies` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '設施名', `order` int(11) NOT NULL COMMENT '前端排序', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_supplies_order`(`order`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '房屋設施' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sale -- ---------------------------- DROP TABLE IF EXISTS `sale`; CREATE TABLE `sale` ( `id` int(11) NOT NULL AUTO_INCREMENT, `store_id` int(11) NOT NULL COMMENT '門店id', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '銷售姓名', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機號', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '銷售狀態', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_sale_phone`(`phone`) USING BTREE, INDEX `idx_sale_name`(`name`) USING BTREE, INDEX `idx_sale_status`(`status`) USING BTREE, INDEX `store_id`(`store_id`) USING BTREE, CONSTRAINT `sale_ibfk_1` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '銷售表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sale_commission -- ---------------------------- DROP TABLE IF EXISTS `sale_commission`; CREATE TABLE `sale_commission` ( `id` int(11) NOT NULL AUTO_INCREMENT, `g_sale_id` int(11) NULL DEFAULT NULL COMMENT '內部銷售', `c_sale_id` int(11) NULL DEFAULT NULL COMMENT '外部銷售', `sum` bigint(20) NOT NULL COMMENT '銷售傭金', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '申請時間', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '傭金狀態', `audit_time` timestamp(0) NULL DEFAULT NULL COMMENT '處理時間', `mode` tinyint(4) NOT NULL COMMENT '租房方式', `order_id` int(11) NOT NULL COMMENT '訂單id', `rent` bigint(20) NOT NULL DEFAULT 0 COMMENT '訂單租金', `deposit` bigint(20) NOT NULL DEFAULT 0 COMMENT '訂單押金', PRIMARY KEY (`id`) USING BTREE, INDEX `order_id`(`order_id`) USING BTREE, INDEX `g_sale_id`(`g_sale_id`) USING BTREE, INDEX `c_sale_id`(`c_sale_id`) USING BTREE, CONSTRAINT `sale_commission_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `user_order` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `sale_commission_ibfk_2` FOREIGN KEY (`g_sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `sale_commission_ibfk_3` FOREIGN KEY (`c_sale_id`) REFERENCES `cooperation_sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '銷售傭金來源記錄' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sale_info -- ---------------------------- DROP TABLE IF EXISTS `sale_info`; CREATE TABLE `sale_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sale_id` int(11) NOT NULL COMMENT '銷售id', `openid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid', `photo` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '頭像', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手機號', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登錄密碼', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '銷售狀態', `session_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登錄狀態', `nickname` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵稱', `last_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次登錄時間', `sex` tinyint(4) NOT NULL DEFAULT 0 COMMENT '性別', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注冊時間', PRIMARY KEY (`id`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, CONSTRAINT `sale_info_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '銷售個人資料' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sale_mail -- ---------------------------- DROP TABLE IF EXISTS `sale_mail`; CREATE TABLE `sale_mail` ( `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 '內容', `send_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '發送時間', `sale_id` int(11) NOT NULL COMMENT '銷售id', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否閱讀', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_xs_title`(`title`) USING BTREE, INDEX `sale_id`(`sale_id`) USING BTREE, CONSTRAINT `sale_mail_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`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 short_time -- ---------------------------- DROP TABLE IF EXISTS `short_time`; CREATE TABLE `short_time` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` int(11) NOT NULL COMMENT '租住天數', `order` int(11) NOT NULL COMMENT '排列順序', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_short_order`(`order`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '短租周期設置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for statistics -- ---------------------------- DROP TABLE IF EXISTS `statistics`; CREATE TABLE `statistics` ( `id` int(11) NOT NULL AUTO_INCREMENT, `total_num` int(11) NOT NULL COMMENT '當天總房間數', `new_num` int(11) NOT NULL COMMENT '當天新增房間數', `rent_num` int(11) NOT NULL COMMENT '當天在租總房間數', `renew_num` int(11) NOT NULL COMMENT '當天續租房間數', `rented_num` int(11) NOT NULL COMMENT '當天未租房間數', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '記錄時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 65 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(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '門店名', `county_id` int(11) NOT NULL COMMENT '區id', `address` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '詳細地址', `longitude` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在經度', `latitude` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在緯度', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '店長姓名', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '店長手機號', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登錄密碼', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '店長狀態', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `session_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '店長登錄session_id', `last_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次登錄時間', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_store_phone`(`phone`) USING BTREE, INDEX `county_id`(`county_id`) USING BTREE, CONSTRAINT `store_ibfk_1` FOREIGN KEY (`county_id`) REFERENCES `county` (`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 store_cash -- ---------------------------- DROP TABLE IF EXISTS `store_cash`; CREATE TABLE `store_cash` ( `id` int(11) NOT NULL AUTO_INCREMENT, `inside_store` int(11) NULL DEFAULT NULL COMMENT '內部門店', `outer_store` int(11) NULL DEFAULT NULL COMMENT '外部門店', `sum` bigint(20) NOT NULL COMMENT '提現金額', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '申請狀態', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '申請時間', `audit_time` timestamp(0) NULL DEFAULT NULL COMMENT '審核時間', `sale` json NOT NULL COMMENT '銷售id', PRIMARY KEY (`id`) USING BTREE, INDEX `inside_store`(`inside_store`) USING BTREE, INDEX `outer_store`(`outer_store`) USING BTREE, CONSTRAINT `store_cash_ibfk_1` FOREIGN KEY (`inside_store`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `store_cash_ibfk_2` FOREIGN KEY (`outer_store`) REFERENCES `cooperation_store` (`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 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, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `attempts` int(3) UNSIGNED NOT NULL, `reserved` int(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED NULL DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT 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 unlock_record -- ---------------------------- DROP TABLE IF EXISTS `unlock_record`; CREATE TABLE `unlock_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sn` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '門鎖的sn', `qr_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二維碼編號', `status` tinyint(1) 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 = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手機號', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用戶姓名', `photo` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '頭像', `nickname` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用戶昵稱', `sex` tinyint(4) NOT NULL DEFAULT 1 COMMENT '性別', `status` int(11) NOT NULL DEFAULT 0 COMMENT '用戶狀態', `introduce` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '個人介紹', `type` tinyint(4) NOT NULL COMMENT '用戶類型', `session_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登錄狀態', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注冊時間', `last_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次登陸時間', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_use_phone`(`phone`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '前端用戶' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_balance -- ---------------------------- DROP TABLE IF EXISTS `user_balance`; CREATE TABLE `user_balance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用戶id', `sum` bigint(20) NOT NULL DEFAULT 0 COMMENT '余額金額', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_balance_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '余額' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_cash -- ---------------------------- DROP TABLE IF EXISTS `user_cash`; CREATE TABLE `user_cash` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用戶id', `sum` bigint(20) NOT NULL DEFAULT 0 COMMENT '提現金額', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '狀態', `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '提現類型', `a_type` tinyint(4) NULL DEFAULT NULL COMMENT '提現賬戶類型', `account` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提現賬號', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '申請提現時間', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_cash_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶提現記錄' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_contract -- ---------------------------- DROP TABLE IF EXISTS `user_contract`; CREATE TABLE `user_contract` ( `id` int(11) NOT NULL AUTO_INCREMENT, `l_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房東姓名', `l_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房東手機號', `l_id_card` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房東身份證號碼', `t_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '承租方姓名', `t_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '承租方手機號', `t_id_card` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '承租方身份證號碼', `h_address` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房源詳細地址', `r_s_time` datetime(0) NOT NULL COMMENT '租房開始時間', `r_e_time` datetime(0) NOT NULL COMMENT '租房結束時間', `p_time` json NOT NULL COMMENT '付款時間段', `rent` bigint(20) NOT NULL DEFAULT 0 COMMENT '租金', `deposit` bigint(20) NOT NULL DEFAULT 0 COMMENT '押金', `is_pay` tinyint(4) NOT NULL COMMENT '是否代繳水電氣', `is_settle` tinyint(4) NOT NULL COMMENT '水電氣是否結清', `life` json NOT NULL COMMENT '水電氣參數', `s_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '監督電話', `facility` json NULL COMMENT '房間設施', `m_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '經辦人姓名', `m_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '經辦人手機號', `m_s_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '經辦人店長電話', `m_store` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '經辦人門店名', `other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其他說明', `sign_mode` tinyint(4) NOT NULL DEFAULT 0 COMMENT '簽訂方式', `people_num` tinyint(4) NOT NULL DEFAULT 0 COMMENT '入住人數', `order_id` int(11) NOT NULL COMMENT '用戶訂單id', `img` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '合同圖片地址', `firm` json NULL COMMENT '公司賬戶信息', `costs` json NULL COMMENT '其他費用', `user_id` int(11) NOT NULL COMMENT '用戶id', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '簽訂時間', PRIMARY KEY (`id`) USING BTREE, INDEX `order_id`(`order_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_contract_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `user_order` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `user_contract_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 99 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶租房合同' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_deposit -- ---------------------------- DROP TABLE IF EXISTS `user_deposit`; CREATE TABLE `user_deposit` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用戶id', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '押金狀態', `sum` bigint(20) NOT NULL DEFAULT 0 COMMENT '押金金額', PRIMARY KEY (`id`) USING BTREE, INDEX `deposit_status`(`status`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_deposit_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '押金' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_long_pay -- ---------------------------- DROP TABLE IF EXISTS `user_long_pay`; CREATE TABLE `user_long_pay` ( `id` int(11) NOT NULL AUTO_INCREMENT, `staging_time` date NOT NULL COMMENT '付款時間段', `sum` bigint(20) NOT NULL COMMENT '繳費金額', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '支付狀態', `pay_time` date NULL DEFAULT NULL COMMENT '繳費時間', `order_id` int(11) NOT NULL COMMENT '訂單id', `user_id` int(11) NOT NULL COMMENT '用戶id', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `month` tinyint(255) NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `order_id`(`order_id`) USING BTREE, CONSTRAINT `user_long_pay_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `user_long_pay_ibfk_2` FOREIGN KEY (`order_id`) REFERENCES `user_order` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 146 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶租房訂單' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_mail -- ---------------------------- DROP TABLE IF EXISTS `user_mail`; CREATE TABLE `user_mail` ( `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 '內容', `send_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '發送時間', `user_id` int(11) NOT NULL COMMENT '用戶id', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否閱讀', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_wy_title`(`title`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_mail_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`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, `order_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '訂單號', `mode` tinyint(4) NOT NULL COMMENT '租房方式', `h_i_id` int(11) NOT NULL COMMENT '房源id', `r_id` int(11) NULL DEFAULT NULL COMMENT '房間id', `into_time` datetime(0) NOT NULL COMMENT '入住時間', `out_time` datetime(0) NOT NULL COMMENT '離開時間', `g_sale_id` int(11) NULL DEFAULT NULL COMMENT '內部負責銷售', `c_sale_id` int(11) NULL DEFAULT NULL COMMENT '第三方負責銷售', `rent` bigint(20) NOT NULL COMMENT '租金單價', `deposit` bigint(20) NOT NULL COMMENT '租房的押金', `total` bigint(20) NOT NULL COMMENT '總金額', `sum` bigint(20) NOT NULL DEFAULT 0 COMMENT '已付金額', `people_num` tinyint(4) NOT NULL DEFAULT 0 COMMENT '入住人數', `document_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '證件類型', `license_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '證件號', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '租房人姓名', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '租房人手機號', `is_all_pay` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否全付', `is_book` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否預訂', `book_gold` bigint(20) NOT NULL DEFAULT 0 COMMENT '訂金', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '下單時間', `pay_time` timestamp(0) NULL DEFAULT NULL COMMENT '付款時間', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '訂單狀態', `user_id` int(11) NOT NULL COMMENT '用戶id', `h_l_p_n` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '長租支付方式名', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_u_mode`(`mode`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `h_i_id`(`h_i_id`) USING BTREE, INDEX `r_id`(`r_id`) USING BTREE, INDEX `g_sale_id`(`g_sale_id`) USING BTREE, INDEX `c_sale_id`(`c_sale_id`) USING BTREE, CONSTRAINT `user_order_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `user_order_ibfk_2` FOREIGN KEY (`h_i_id`) REFERENCES `house_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `user_order_ibfk_3` FOREIGN KEY (`r_id`) REFERENCES `room` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `user_order_ibfk_4` FOREIGN KEY (`g_sale_id`) REFERENCES `sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT, CONSTRAINT `user_order_ibfk_5` FOREIGN KEY (`c_sale_id`) REFERENCES `cooperation_sale` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 132 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶租房訂單' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_pay_log -- ---------------------------- DROP TABLE IF EXISTS `user_pay_log`; CREATE TABLE `user_pay_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '繳費單號', `user_id` int(11) NOT NULL COMMENT '用戶id', `h_i_id` int(11) NOT NULL COMMENT '房源id', `r_id` int(11) NULL DEFAULT NULL COMMENT '房間id', `sum` bigint(20) NOT NULL COMMENT '繳費金額', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '繳費狀態', `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '繳費名稱', `is_d_deposit` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否抵扣押金', `d_deposit` bigint(20) NOT NULL DEFAULT 0 COMMENT '抵扣押金金額', `total` bigint(20) NOT NULL COMMENT '實際支付金額', `payment_method` tinyint(4) NOT NULL DEFAULT 0 COMMENT '付款方式', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '繳費時間', `pay_time` timestamp(0) NULL DEFAULT NULL COMMENT '支付時間', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `h_i_id`(`h_i_id`) USING BTREE, INDEX `r_id`(`r_id`) USING BTREE, CONSTRAINT `user_pay_log_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `user_pay_log_ibfk_2` FOREIGN KEY (`h_i_id`) REFERENCES `house_info` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `user_pay_log_ibfk_3` FOREIGN KEY (`r_id`) REFERENCES `room` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '生活繳費記錄' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_payment_log -- ---------------------------- DROP TABLE IF EXISTS `user_payment_log`; CREATE TABLE `user_payment_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支付單號', `mode` tinyint(4) NOT NULL COMMENT '付款類型', `order_id` int(11) NOT NULL COMMENT '訂單id', `user_id` int(11) NOT NULL COMMENT '用戶id', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '申請時間', `is_d_deposit` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否抵扣押金', `d_deposit` bigint(20) NOT NULL DEFAULT 0 COMMENT '抵扣押金金額', `sum` bigint(20) NOT NULL COMMENT '應付金額', `total` bigint(20) NOT NULL COMMENT '實際支付', `payment_method` tinyint(4) NOT NULL DEFAULT 0 COMMENT '付款方式', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '支付狀態', `u_p_id` int(11) NULL DEFAULT NULL COMMENT '繳費時間段id', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `order_id`(`order_id`) USING BTREE, INDEX `u_p_id`(`u_p_id`) USING BTREE, CONSTRAINT `user_payment_log_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `user_payment_log_ibfk_2` FOREIGN KEY (`order_id`) REFERENCES `user_order` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `user_payment_log_ibfk_3` FOREIGN KEY (`u_p_id`) REFERENCES `user_long_pay` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 131 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(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信openid', `user_id` int(11) NOT NULL COMMENT '用戶信息id', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '123456' COMMENT '用戶密碼', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_phone_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '手機用戶' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_retirement -- ---------------------------- DROP TABLE IF EXISTS `user_retirement`; CREATE TABLE `user_retirement` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` tinyint(4) NOT NULL COMMENT '取消類型', `order_id` int(11) NOT NULL COMMENT '訂單id', `user_id` int(11) NOT NULL COMMENT '用戶id', `h_i_id` int(11) NOT NULL COMMENT '房源id', `r_id` int(11) NULL DEFAULT NULL COMMENT '房間id', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '申請時間', `recede_time` timestamp(0) NULL DEFAULT NULL COMMENT '退房時間', `refund_amount` bigint(20) NOT NULL DEFAULT 0 COMMENT '退款金額', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '退款說明', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '處理狀態', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `order_id`(`order_id`) USING BTREE, CONSTRAINT `user_retirement_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `user_retirement_ibfk_2` FOREIGN KEY (`order_id`) REFERENCES `user_order` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶申請退租' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_topup_log -- ---------------------------- DROP TABLE IF EXISTS `user_topup_log`; CREATE TABLE `user_topup_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用戶id', `order_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '充值訂單號', `sum` bigint(20) NOT NULL DEFAULT 0 COMMENT '充值金額', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '充值狀態', `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '充值類型', `mode` tinyint(4) NOT NULL DEFAULT 0 COMMENT '支付方式', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '充值時間', `pay_time` timestamp(0) NULL DEFAULT NULL COMMENT '支付時間', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_topup_log_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 97 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用戶充值記錄' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user_wechat -- ---------------------------- DROP TABLE IF EXISTS `user_wechat`; CREATE TABLE `user_wechat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `openid` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信openid', `user_id` int(11) NOT NULL COMMENT '用戶信息id', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `user_wechat_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '微信用戶' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; ~~~