From 7634d7ff15b1fa84ea84a51a1ba6e45b11a4aa21 Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期日, 27 四月 2025 11:17:34 +0800 Subject: [PATCH] SSO登录逻辑再修改 --- pipIrr-platform/文档/dbSQL/pipirr_ym(2025-02-10).sql | 2736 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 2,736 insertions(+), 0 deletions(-) diff --git "a/pipIrr-platform/\346\226\207\346\241\243/dbSQL/pipirr_ym\0502025-02-10\051.sql" "b/pipIrr-platform/\346\226\207\346\241\243/dbSQL/pipirr_ym\0502025-02-10\051.sql" new file mode 100644 index 0000000..0bd477c --- /dev/null +++ "b/pipIrr-platform/\346\226\207\346\241\243/dbSQL/pipirr_ym\0502025-02-10\051.sql" @@ -0,0 +1,2736 @@ +/* + Navicat Premium Data Transfer + + Source Server : 鍏冭皨闃块噷浜� + Source Server Type : MySQL + Source Server Version : 80034 + Source Host : 8.130.130.233:3306 + Source Schema : pipirr_ym + + Target Server Type : MySQL + Target Server Version : 80034 + File Encoding : 65001 + + Date: 10/02/2025 09:44:10 +*/ + +SET NAMES utf8mb4; +SET FOREIGN_KEY_CHECKS = 0; + +-- ---------------------------- +-- Table structure for area_code_2023 +-- ---------------------------- +DROP TABLE IF EXISTS `area_code_2023`; +CREATE TABLE `area_code_2023` ( + `code` bigint UNSIGNED NOT NULL COMMENT '鍖哄垝浠ｇ爜', + `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '鍚嶇О', + `level` tinyint(1) NOT NULL COMMENT '绾у埆1-5,鐪佸競鍘块晣鏉�', + `pcode` bigint NULL DEFAULT NULL COMMENT '鐖剁骇鍖哄垝浠ｇ爜', + `category` int NULL DEFAULT NULL COMMENT '鍩庝埂鍒嗙被', + PRIMARY KEY (`code`) USING BTREE, + INDEX `name`(`name` ASC) USING BTREE, + INDEX `level`(`level` ASC) USING BTREE, + INDEX `pcode`(`pcode` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_block +-- ---------------------------- +DROP TABLE IF EXISTS `ba_block`; +CREATE TABLE `ba_block` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '鐗囧尯鍚嶇О', + `header` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '璐熻矗浜�', + `phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '璐熻矗浜虹數璇�', + `area` int NULL DEFAULT NULL COMMENT '绉嶆闈㈢Н', + `color` varchar(7) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '鐢靛瓙鍦板浘鍖哄煙鐫�鑹�', + `remark` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '澶囨敞', + `deleted` tinyint NULL DEFAULT 0, + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_captcha +-- ---------------------------- +DROP TABLE IF EXISTS `ba_captcha`; +CREATE TABLE `ba_captcha` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '楠岃瘉鐮乼oken', + `code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '楠岃瘉瀛楃', + `expiration` bigint NULL DEFAULT NULL COMMENT '杩囨湡鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍥惧舰楠岃瘉璁板綍琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ba_client +-- ---------------------------- +DROP TABLE IF EXISTS `ba_client`; +CREATE TABLE `ba_client` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `countyId` bigint NULL DEFAULT NULL COMMENT '鍘縄D', + `townId` bigint NULL DEFAULT NULL COMMENT '闀嘔D', + `villageId` bigint NULL DEFAULT NULL COMMENT '鏉慖D', + `blockId` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戠墖鍖�', + `divideId` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝垎姘存埧', + `typeId` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戠敤姘存埛绫诲瀷', + `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '濮撳悕', + `num` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '缂栧彿', + `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎵嬫満鍙�', + `idCard` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '韬唤璇佸彿', + `area` double NULL DEFAULT NULL COMMENT '绉嶆闈㈢Н', + `district` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍘垮悕绉�+闀囧悕绉�+鏉戝悕绉�', + `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '琛楅亾+闂ㄧ墝鍙�', + `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞', + `disabled` tinyint NULL DEFAULT NULL COMMENT '绂佹鏍囧織', + `deleted` tinyint NULL DEFAULT NULL COMMENT '鍒犻櫎鏍囧織', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢ㄦ按鎴�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_client_type +-- ---------------------------- +DROP TABLE IF EXISTS `ba_client_type`; +CREATE TABLE `ba_client_type` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鐢ㄦ按鎴风被鍨嬪悕绉�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢ㄦ按鎴风被鍨�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_dict +-- ---------------------------- +DROP TABLE IF EXISTS `ba_dict`; +CREATE TABLE `ba_dict` ( + `id` int NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', + `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鏍囪瘑', + `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍚嶇О', + `value_type` tinyint NOT NULL COMMENT '鍊肩被鍨�;1-Number锛�2-String锛�3-Boolean', + `hash_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'hash鍊�;褰撳瓧鍏搁」琚慨鏀规椂鍙樻洿', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞', + `deleted` bigint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;鏈垹闄や负 0锛屽凡鍒犻櫎涓哄垹闄ゆ椂闂�', + `create_by` int NULL DEFAULT NULL COMMENT '鍒涘缓浜�', + `update_by` int NULL DEFAULT NULL COMMENT '淇敼浜�', + `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `update_time` datetime NULL DEFAULT NULL COMMENT '淇敼鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瀛楀吀琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_dict_item +-- ---------------------------- +DROP TABLE IF EXISTS `ba_dict_item`; +CREATE TABLE `ba_dict_item` ( + `id` int NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', + `dict_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '瀛楀吀Code', + `value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鏁版嵁鍊�', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鏍囩', + `status` tinyint NOT NULL DEFAULT 1 COMMENT '鐘舵��;1-鍚敤锛�0-绂佺敤', + `attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '闄勫姞灞炴��', + `sort` int NOT NULL DEFAULT 0 COMMENT '鎺掑簭锛堝崌搴忥級', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞', + `deleted` bigint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;鏈垹闄や负 0锛屽凡鍒犻櫎涓哄垹闄ゆ椂闂�', + `create_by` int NULL DEFAULT NULL COMMENT '鍒涘缓浜�', + `update_by` int NULL DEFAULT NULL COMMENT '淇敼浜�', + `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `update_time` datetime NULL DEFAULT NULL COMMENT '淇敼鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瀛楀吀椤�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_district +-- ---------------------------- +DROP TABLE IF EXISTS `ba_district`; +CREATE TABLE `ba_district` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `supperId` bigint NULL DEFAULT NULL COMMENT '鎸囧悜涓婄骇琛屾斂鍖�', + `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '琛屾斂鍖哄悕绉�', + `num` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '琛屾斂鍖虹紪鍙�', + `level` tinyint NULL DEFAULT NULL COMMENT '琛屾斂鍖虹骇鍒�', + `deleted` tinyint NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_divide +-- ---------------------------- +DROP TABLE IF EXISTS `ba_divide`; +CREATE TABLE `ba_divide` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `countyId` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戞墍鍦ㄥ幙锛堝綊灞炲湴锛�', + `townId` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戞墍鍦ㄩ晣锛堝綊灞炲湴锛�', + `villageId` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚� 鎵�鍦ㄦ潙锛堝綊灞炲湴锛�', + `blockId` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戠墖鍖�', + `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍒嗘按鍙ｅ悕绉版垨缂栧彿', + `villages` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '瑕嗙洊鏉�', + `area` float(10, 2) NULL DEFAULT NULL COMMENT '瑕嗙洊闈㈢Н锛堝钩鏂瑰叕閲岋級', + `header` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '璐熻矗浜�', + `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鑱旂郴鐢佃瘽', + `lng` double NULL DEFAULT NULL COMMENT '缁忓害', + `lat` double NULL DEFAULT NULL COMMENT '绾害', + `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞', + `deleted` tinyint NULL DEFAULT NULL COMMENT '鍒犻櫎鏍囧織', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_map_coordinates +-- ---------------------------- +DROP TABLE IF EXISTS `ba_map_coordinates`; +CREATE TABLE `ba_map_coordinates` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `graph_id` bigint NOT NULL COMMENT '鍥惧舰ID', + `lat` decimal(18, 15) NULL DEFAULT NULL COMMENT '绾害', + `lng` decimal(18, 15) NULL DEFAULT NULL COMMENT '缁忓害', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍦板浘鍥惧舰鍧愭爣' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_map_graph +-- ---------------------------- +DROP TABLE IF EXISTS `ba_map_graph`; +CREATE TABLE `ba_map_graph` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `block_id` bigint NOT NULL COMMENT '鐗囧尯ID', + `graph_type` tinyint NOT NULL DEFAULT 1 COMMENT '鍥惧舰绫诲瀷;1-CircleMarker 锛�2-Polygon 锛�3-Polyline', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍦板浘鍥惧舰琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_role +-- ---------------------------- +DROP TABLE IF EXISTS `ba_role`; +CREATE TABLE `ba_role` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '瑙掕壊鍚嶇О', + `operator` bigint NULL DEFAULT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operate_dt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺瑙掕壊琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_role_permissions +-- ---------------------------- +DROP TABLE IF EXISTS `ba_role_permissions`; +CREATE TABLE `ba_role_permissions` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `roleId` bigint NOT NULL COMMENT '瑙掕壊缂栧彿', + `permissions` json NOT NULL COMMENT '鏉冮檺鍒楄〃', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瑙掕壊鏉冮檺鍏宠仈琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_settings +-- ---------------------------- +DROP TABLE IF EXISTS `ba_settings`; +CREATE TABLE `ba_settings` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `item_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '閰嶇疆椤�', + `item_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '閰嶇疆椤瑰��', + `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺閰嶇疆琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_user +-- ---------------------------- +DROP TABLE IF EXISTS `ba_user`; +CREATE TABLE `ba_user` ( + `id` bigint NOT NULL, + `blockId` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戠墖鍖哄疄浣�', + `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '鐢ㄦ埛濮撳悕', + `phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '鎵嬫満鍙凤紝鐢ㄤ簬鐧诲綍绯荤粺', + `password` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '瀵嗙爜锛宮d5鍔犲瘑', + `orgTag` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '鐢ㄦ埛鎵�鏈夋満鏋勬爣绛�', + `supperAdmin` tinyint NULL DEFAULT NULL COMMENT '鏄惁瓒呯骇绠＄悊鍛橈紝1鏄紝0鍚�', + `disabled` tinyint NULL DEFAULT NULL COMMENT '鏄惁绂佺敤锛�1鏄紝0鍚�', + `deleted` tinyint NULL DEFAULT NULL COMMENT '鍒犻櫎鏍囧織锛�1鏄紝0鍚�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ba_user_role +-- ---------------------------- +DROP TABLE IF EXISTS `ba_user_role`; +CREATE TABLE `ba_user_role` ( + `userId` bigint NOT NULL, + `roleId` bigint NOT NULL, + PRIMARY KEY (`userId`, `roleId`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ir_crop +-- ---------------------------- +DROP TABLE IF EXISTS `ir_crop`; +CREATE TABLE `ir_crop` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `crop_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '浣滅墿鍚嶇О', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '浣滅墿琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ir_group_client +-- ---------------------------- +DROP TABLE IF EXISTS `ir_group_client`; +CREATE TABLE `ir_group_client` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `group_id` bigint NOT NULL COMMENT '杞亴缁処D', + `client_id` bigint NOT NULL COMMENT '鍐滄埛ID', + `operator` bigint NULL DEFAULT NULL COMMENT '鍒涘缓浜�', + `operate_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '杞亴缁勫啘鎴峰叧鑱旇〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ir_group_unit +-- ---------------------------- +DROP TABLE IF EXISTS `ir_group_unit`; +CREATE TABLE `ir_group_unit` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `group_id` bigint NOT NULL COMMENT '杞亴缁勭紪鍙�', + `unit_id` bigint NOT NULL COMMENT '鐏屾簤鍗曞厓缂栧彿', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜�', + `operate_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '杞亴缁勭亴婧夊崟鍏冨叧鑱旇〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ir_irrigate_group +-- ---------------------------- +DROP TABLE IF EXISTS `ir_irrigate_group`; +CREATE TABLE `ir_irrigate_group` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `group_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '杞亴缁勭紪鐮�', + `project_id` bigint NOT NULL COMMENT '椤圭洰缂栧彿', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜�', + `operate_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '杞亴缁勮〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ir_irrigate_plan +-- ---------------------------- +DROP TABLE IF EXISTS `ir_irrigate_plan`; +CREATE TABLE `ir_irrigate_plan` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `project_id` bigint NULL DEFAULT NULL COMMENT '椤圭洰ID', + `plan_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '璁″垝鍚嶇О', + `startup_mode` tinyint NULL DEFAULT 1 COMMENT '璁″垝鍚姩妯″紡;1-鎵嬪姩鍚姩锛�2-鑷姩鍚姩', + `plan_start_time` datetime NULL DEFAULT NULL COMMENT '鐏屾簤寮�濮嬫椂闂�;绮剧‘鍒板垎', + `plan_stop_time` datetime NULL DEFAULT NULL COMMENT '鐏屾簤缁撴潫鏃堕棿;绮剧‘鍒板垎', + `plan_state` tinyint NULL DEFAULT 1 COMMENT '璁″垝鐘舵��;1-鑽夌锛�2-宸插彂甯�', + `executing_state` tinyint NULL DEFAULT 1 COMMENT '鎵ц鐘舵��;1-鏈墽琛岋紝2-鎵ц涓紝3-宸叉殏鍋滐紝4-宸茬粓姝紝5-宸插畬鎴�', + `deleted` bigint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;鏈垹闄や负0锛屽凡鍒犻櫎涓哄垹闄ゆ椂闂�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐏屾簤璁″垝琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ir_irrigate_schedule +-- ---------------------------- +DROP TABLE IF EXISTS `ir_irrigate_schedule`; +CREATE TABLE `ir_irrigate_schedule` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `plan_id` bigint NOT NULL COMMENT '鐏屾簤璁″垝ID', + `group_id` bigint NOT NULL COMMENT '杞亴缁処D', + `start_time` datetime NOT NULL COMMENT '鐏屾簤寮�濮嬫椂闂�;绮剧‘鍒板垎', + `stop_time` datetime NOT NULL COMMENT '鐏屾簤缁撴潫鏃堕棿;绮剧‘鍒板垎', + `intake_ids` json NULL COMMENT '鍙栨按鍙D鍒楄〃', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐏屾簤娆″簭琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ir_irrigate_scheduling +-- ---------------------------- +DROP TABLE IF EXISTS `ir_irrigate_scheduling`; +CREATE TABLE `ir_irrigate_scheduling` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `crop_id` bigint NOT NULL COMMENT '浣滅墿缂栧彿', + `growth_period` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '浣滅墿鐢熼暱鏈�', + `irrigate_cycle` int NOT NULL COMMENT '鐏屾按鍛ㄦ湡', + `duration` int NOT NULL COMMENT '鐏屾按寤剁画鏃堕棿', + `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜�', + `operate_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐏屾簤鍒跺害琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ir_irrigate_unit +-- ---------------------------- +DROP TABLE IF EXISTS `ir_irrigate_unit`; +CREATE TABLE `ir_irrigate_unit` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `project_id` bigint NOT NULL COMMENT '椤圭洰ID', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙D', + `area` float(10, 2) NULL DEFAULT NULL COMMENT '鐏屾簤闈㈢Н', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜�', + `operate_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐏屾簤鍗曞厓琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ir_opening_schedule +-- ---------------------------- +DROP TABLE IF EXISTS `ir_opening_schedule`; +CREATE TABLE `ir_opening_schedule` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `schedule_id` bigint NOT NULL COMMENT '鐏屾簤娆″簭ID', + `start_time` datetime NOT NULL COMMENT '寮�闃�鏃堕棿;绮剧‘鍒板垎', + `duration` int NOT NULL COMMENT '鐏屾簤鏃堕暱;鍒嗛挓', + `intake_nums` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍙栨按鍙ｇ紪鍙峰垪琛�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '寮�闃�璁″垝琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ir_plan_operate +-- ---------------------------- +DROP TABLE IF EXISTS `ir_plan_operate`; +CREATE TABLE `ir_plan_operate` ( + `update_time` datetime NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿', + `id` bigint NOT NULL COMMENT '涓婚敭', + `plan_id` bigint NOT NULL COMMENT '鐏屾簤璁″垝ID', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operate_type` tinyint NULL DEFAULT NULL COMMENT '鎿嶄綔绫诲瀷;1-鍒涘缓锛�2-鍙戝竷锛�3-鎵ц锛�4-鏆傚仠锛�5-缁堟锛�6-瀹屾垚', + `operate_time` datetime NULL DEFAULT NULL COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐏屾簤璁″垝鎿嶄綔琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ir_plan_pause +-- ---------------------------- +DROP TABLE IF EXISTS `ir_plan_pause`; +CREATE TABLE `ir_plan_pause` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `schedule_id` bigint NOT NULL COMMENT '鐏屾簤娆″簭ID', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `pause_time` datetime NOT NULL COMMENT '鏆傚仠鏃堕棿;绮剧‘鍒板垎', + `renew_time` datetime NULL DEFAULT NULL COMMENT '鎭㈠鏃堕棿;绮剧‘鍒板垎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '璁″垝鏆傚仠璁板綍琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ir_plan_terminate +-- ---------------------------- +DROP TABLE IF EXISTS `ir_plan_terminate`; +CREATE TABLE `ir_plan_terminate` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `schedule_id` bigint NOT NULL COMMENT '鐏屾簤娆″簭ID', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `terminate_time` datetime NOT NULL COMMENT '缁堟鏃堕棿;绮剧‘鍒板垎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '璁″垝缁堟璁板綍琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ir_project +-- ---------------------------- +DROP TABLE IF EXISTS `ir_project`; +CREATE TABLE `ir_project` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `project_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '椤圭洰鍚嶇О', + `province_id` bigint NULL DEFAULT NULL COMMENT '鐪両D', + `city_id` bigint NULL DEFAULT NULL COMMENT '甯侷D', + `county_id` bigint NULL DEFAULT NULL COMMENT '鍘縄D', + `town_id` bigint NULL DEFAULT NULL COMMENT '闀嘔D', + `village_id` bigint NULL DEFAULT NULL COMMENT '鏉慖D', + `project_state` tinyint NULL DEFAULT 1 COMMENT '椤圭洰鐘舵��;1-鍚敤锛�2-搴熷純', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜�', + `operate_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '椤圭洰琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ir_unit_client +-- ---------------------------- +DROP TABLE IF EXISTS `ir_unit_client`; +CREATE TABLE `ir_unit_client` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `unit_id` bigint NOT NULL COMMENT '鐏屾簤鍗曞厓ID', + `client_id` bigint NOT NULL COMMENT '鍐滄埛ID', + `operator` bigint NULL DEFAULT NULL COMMENT '鍒涘缓浜�', + `operate_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐏屾簤鍗曞厓鍐滄埛鍏宠仈琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ope_approve_result +-- ---------------------------- +DROP TABLE IF EXISTS `ope_approve_result`; +CREATE TABLE `ope_approve_result` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `work_order_id` bigint NOT NULL COMMENT '宸ュ崟ID', + `processing_result_id` bigint NOT NULL COMMENT '澶勭悊缁撴灉ID', + `approver_id` bigint NULL DEFAULT NULL COMMENT '瀹℃牳浜篒D', + `approve_time` datetime NULL DEFAULT NULL COMMENT '瀹℃牳鏃堕棿', + `approve_result` tinyint NULL DEFAULT NULL COMMENT '瀹℃牳缁撴灉;1-閫氳繃锛�2-椹冲洖', + `deleted` bigint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;鏈垹闄や负0锛屽凡鍒犻櫎涓哄垹闄ゆ椂闂�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '澶勭悊缁撴灉瀹℃牳璁板綍' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ope_inspect +-- ---------------------------- +DROP TABLE IF EXISTS `ope_inspect`; +CREATE TABLE `ope_inspect` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `inspector_id` bigint NOT NULL COMMENT '宸℃鍛業D', + `start_time` datetime NULL DEFAULT NULL COMMENT '寮�濮嬪贰妫�鏃堕棿', + `stop_time` datetime NULL DEFAULT NULL COMMENT '缁撴潫宸℃鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '宸℃琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ope_issue_report +-- ---------------------------- +DROP TABLE IF EXISTS `ope_issue_report`; +CREATE TABLE `ope_issue_report` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `content` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '闂鍐呭', + `images` json NULL COMMENT '鐓х墖鍒楄〃', + `audios` json NULL COMMENT '闊抽鍒楄〃', + `videos` json NULL COMMENT '瑙嗛鍒楄〃', + `lng` decimal(18, 15) NULL DEFAULT NULL COMMENT '缁忓害', + `lat` decimal(18, 15) NULL DEFAULT NULL COMMENT '绾害', + `inspector_id` bigint NULL DEFAULT NULL COMMENT '宸℃鍛業D', + `report_time` datetime NULL DEFAULT NULL COMMENT '涓婃姤鏃堕棿', + `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鑱旂郴鐢佃瘽', + `state` tinyint NULL DEFAULT NULL COMMENT '鐘舵��;1-鏈彈鐞嗭紝2-宸插彈鐞嗭紝3宸插垹闄�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '闂涓婃姤璁板綍琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ope_processing_result +-- ---------------------------- +DROP TABLE IF EXISTS `ope_processing_result`; +CREATE TABLE `ope_processing_result` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `work_order_id` bigint NOT NULL COMMENT '宸ュ崟ID', + `inspector_id` bigint NOT NULL COMMENT '宸℃鍛業D', + `content` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '缁撴灉鍐呭', + `images` json NULL COMMENT '鐓х墖鍒楄〃', + `audios` json NULL COMMENT '闊抽鍒楄〃', + `videos` json NULL COMMENT '瑙嗛鍒楄〃', + `lng` decimal(18, 15) NULL DEFAULT NULL COMMENT '缁忓害', + `lat` decimal(18, 15) NULL DEFAULT NULL COMMENT '绾害', + `complete_time` datetime NULL DEFAULT NULL COMMENT '浠诲姟瀹屾垚鏃堕棿;绮剧‘鍒板垎', + `report_time` datetime NULL DEFAULT NULL COMMENT '涓婃姤鏃堕棿', + `state` tinyint NULL DEFAULT NULL COMMENT '鐘舵��;1-宸蹭笂鎶ワ紝2-宸查�氳繃锛�3-宸查┏鍥�', + `deleted` bigint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;鏈垹闄や负0锛屽凡鍒犻櫎涓哄垹闄ゆ椂闂�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '澶勭悊缁撴灉璁板綍琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ope_report_reply +-- ---------------------------- +DROP TABLE IF EXISTS `ope_report_reply`; +CREATE TABLE `ope_report_reply` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `report_id` bigint NOT NULL COMMENT '闂涓婃姤ID', + `reply_content` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍥炲鍐呭', + `reply_time` datetime NULL DEFAULT NULL COMMENT '鍥炲鏃堕棿', + `replier_id` bigint NOT NULL COMMENT '鍥炲浜篒D', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '涓婃姤鍥炲璁板綍琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ope_task_type +-- ---------------------------- +DROP TABLE IF EXISTS `ope_task_type`; +CREATE TABLE `ope_task_type` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `task_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '浠诲姟绫诲瀷', + `deleted` bigint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;鏈垹闄や负0锛屽凡鍒犻櫎涓哄垹闄ゆ椂闂�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '浠诲姟绫诲瀷琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ope_track +-- ---------------------------- +DROP TABLE IF EXISTS `ope_track`; +CREATE TABLE `ope_track` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `inspect_id` bigint NULL DEFAULT NULL COMMENT '宸℃ID', + `lng` decimal(18, 15) NULL DEFAULT NULL COMMENT '缁忓害', + `lat` decimal(18, 15) NULL DEFAULT NULL COMMENT '绾害', + `locate_time` datetime NULL DEFAULT NULL COMMENT '鎵撶偣鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '宸℃杞ㄨ抗琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for ope_work_order +-- ---------------------------- +DROP TABLE IF EXISTS `ope_work_order`; +CREATE TABLE `ope_work_order` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `dispatcher_id` bigint NOT NULL COMMENT '娲惧崟浜篒D', + `inspector_id` bigint NOT NULL COMMENT '宸℃鍛業D', + `task_type_id` bigint NOT NULL DEFAULT 4 COMMENT '浠诲姟绫诲瀷ID', + `task_content` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '浠诲姟鍐呭', + `complete_criteria` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '瀹屾垚鏍囧噯', + `dead_line` datetime NULL DEFAULT NULL COMMENT '瑕佹眰瀹屾垚鏃堕棿;绮剧‘鍒板垎', + `complete_time` datetime NULL DEFAULT NULL COMMENT '浠诲姟瀹屾垚鏃堕棿;绮剧‘鍒板垎', + `dispatch_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '娲惧崟鏃堕棿', + `client_report_id` bigint NULL DEFAULT NULL COMMENT '鍐滄埛闂涓婃姤ID', + `inspector_report_id` bigint NULL DEFAULT NULL COMMENT '宸℃鍛橀棶棰樹笂鎶D', + `state` tinyint NULL DEFAULT NULL COMMENT '鐘舵��;1-鏈畬鎴愶紝2-宸插畬鎴�', + `reject_times` int NULL DEFAULT 0 COMMENT '椹冲洖娆℃暟', + `deleted` bigint NOT NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;鏈垹闄や负0锛屽凡鍒犻櫎涓哄垹闄ゆ椂闂�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '宸ュ崟琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for pr_common_intakes +-- ---------------------------- +DROP TABLE IF EXISTS `pr_common_intakes`; +CREATE TABLE `pr_common_intakes` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `operator_id` bigint NOT NULL COMMENT '鎿嶄綔浜篒D', + `intake_id` bigint NOT NULL COMMENT '鍙栨按鍙D', + `last_used_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鏈�鍚庝竴娆′娇鐢ㄦ椂闂�', + `usage_count` int NULL DEFAULT 0 COMMENT '浣跨敤娆℃暟', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '甯哥敤鍙栨按鍙�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for pr_controller +-- ---------------------------- +DROP TABLE IF EXISTS `pr_controller`; +CREATE TABLE `pr_controller` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `intakeId` bigint NOT NULL COMMENT '鍙栨按鍙D', + `rtuAddr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `protocol` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '閫氳鍗忚', + `protocol_version` int NULL DEFAULT NULL COMMENT '鍗忚鐗堟湰鍙�', + `findDt` datetime NULL DEFAULT NULL COMMENT '鍙戠幇鏃ユ湡鏃堕棿', + `orgTag` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏈烘瀯tag', + `addWays` tinyint NULL DEFAULT 1 COMMENT '娣诲姞鏂瑰紡;1-绯荤粺鑷姩锛�2-鎵嬪姩', + `operator` bigint NULL DEFAULT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎺у埗鍣ㄨ〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_controller_tramp +-- ---------------------------- +DROP TABLE IF EXISTS `pr_controller_tramp`; +CREATE TABLE `pr_controller_tramp` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `rtuAddr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `protocol` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '閫氫俊鍗忚', + `protocol_version` int NULL DEFAULT NULL COMMENT '閫氫俊鍗忚鐗堟湰鍙�', + `findDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍙戠幇鏃ユ湡鏃堕棿', + `orgTag` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏈烘瀯tag', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '娴佹氮鎺у埗鍣�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_divide +-- ---------------------------- +DROP TABLE IF EXISTS `pr_divide`; +CREATE TABLE `pr_divide` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `countyId` bigint NULL DEFAULT NULL COMMENT '鎵�鍦ㄥ幙', + `townId` bigint NULL DEFAULT NULL COMMENT '鎵�鍦ㄩ晣', + `villageId` bigint NULL DEFAULT NULL COMMENT '鎵�鍦ㄦ潙', + `blockId` bigint NOT NULL COMMENT '鎵�灞炵墖鍖�', + `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍒嗘按鍙ｅ悕绉版垨缂栧彿', + `villages` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '瑕嗙洊鏉�', + `area` float(10, 2) NULL DEFAULT NULL COMMENT '瑕嗙洊闈㈢Н锛堝钩鏂瑰叕閲岋級', + `header` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '璐熻矗浜�', + `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鑱旂郴鐢佃瘽', + `lng` double NOT NULL COMMENT '缁忓害', + `lat` double NOT NULL COMMENT '绾害', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍒嗘按鎴胯〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_flow_monitoring +-- ---------------------------- +DROP TABLE IF EXISTS `pr_flow_monitoring`; +CREATE TABLE `pr_flow_monitoring` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `countyId` bigint NULL DEFAULT NULL COMMENT '鎵�鍦ㄥ幙', + `townId` bigint NULL DEFAULT NULL COMMENT '鎵�鍦ㄩ晣', + `villageId` bigint NULL DEFAULT NULL COMMENT '鎵�鍦ㄦ潙', + `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鐩戞祴绔欏悕绉�', + `lng` double NOT NULL COMMENT '缁忓害', + `lat` double NOT NULL COMMENT '绾害', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '娴侀噺鐩戞祴绔欒〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_flowmeter +-- ---------------------------- +DROP TABLE IF EXISTS `pr_flowmeter`; +CREATE TABLE `pr_flowmeter` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `monitoringId` bigint NULL DEFAULT NULL COMMENT '鐩戞祴绔橧D', + `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '娴侀噺璁＄紪鍙�', + `protocol` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '閫氳鍗忚', + `onlineState` tinyint NULL DEFAULT 2 COMMENT '鍦ㄧ嚎鐘舵��;1-鍦ㄧ嚎锛�2-绂荤嚎', + `reportTime` datetime NULL DEFAULT NULL COMMENT '鏈�杩戜笂鎶ユ椂闂�', + `addWays` tinyint NULL DEFAULT 1 COMMENT '娣诲姞鏂瑰紡;1-绯荤粺鑷姩锛�2-鎵嬪姩', + `operator` bigint NULL DEFAULT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '娴侀噺璁¤〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_intake +-- ---------------------------- +DROP TABLE IF EXISTS `pr_intake`; +CREATE TABLE `pr_intake` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `countyId` bigint NULL DEFAULT NULL COMMENT '鎵�鍦ㄥ幙', + `townId` bigint NULL DEFAULT NULL COMMENT '鎵�鍦ㄩ晣', + `villageId` bigint NULL DEFAULT NULL COMMENT '鎵�鍦ㄦ潙', + `divideId` bigint NOT NULL COMMENT '鍒嗘按鍙ｇ紪鍙�', + `blockId` bigint NOT NULL COMMENT '鐗囧尯缂栧彿', + `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍙栨按鍙ｅ悕绉�', + `lng` double NULL DEFAULT NULL COMMENT '缁忓害', + `lat` double NULL DEFAULT NULL COMMENT '绾害', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NULL DEFAULT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍙栨按鍙ｈ〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_intake_controller +-- ---------------------------- +DROP TABLE IF EXISTS `pr_intake_controller`; +CREATE TABLE `pr_intake_controller` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `intakeId` bigint NOT NULL COMMENT '鍙栨按鍙ｇ紪鍙�', + `controllerId` bigint NOT NULL COMMENT '鎺у埗鍣ㄧ紪鍙�', + `operateType` tinyint NULL DEFAULT 1 COMMENT '鎿嶄綔绫诲瀷;1-鎹嗙粦锛�2-瑙ｇ粦', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍙栨按鍙ｆ崋缁戣〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_intake_vc +-- ---------------------------- +DROP TABLE IF EXISTS `pr_intake_vc`; +CREATE TABLE `pr_intake_vc` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `intake_id` bigint NOT NULL COMMENT '鍙栨按鍙D', + `vc_id` bigint NOT NULL COMMENT '铏氭嫙鍗D', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍙栨按鍙ｈ櫄鎷熷崱缁戝畾琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_monitoring_flowmeter +-- ---------------------------- +DROP TABLE IF EXISTS `pr_monitoring_flowmeter`; +CREATE TABLE `pr_monitoring_flowmeter` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `monitoringId` bigint NOT NULL COMMENT '鐩戞祴绔欑紪鍙�', + `flowmeterId` bigint NOT NULL COMMENT '娴侀噺璁＄紪鍙�', + `operateType` tinyint NULL DEFAULT 1 COMMENT '鎿嶄綔绫诲瀷;1-鎹嗙粦锛�2-瑙ｇ粦', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐩戞祴绔欐祦閲忚鍏宠仈琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_network_coordinates +-- ---------------------------- +DROP TABLE IF EXISTS `pr_network_coordinates`; +CREATE TABLE `pr_network_coordinates` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `network_id` bigint NOT NULL COMMENT '绠＄綉ID', + `lat` decimal(18, 15) NULL DEFAULT NULL COMMENT '绾害', + `lng` decimal(18, 15) NULL DEFAULT NULL COMMENT '缁忓害', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绠＄綉鍧愭爣琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_scheduling_params +-- ---------------------------- +DROP TABLE IF EXISTS `pr_scheduling_params`; +CREATE TABLE `pr_scheduling_params` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `utilization_coefficient` float(2, 1) NULL DEFAULT NULL COMMENT '鐏屾簤姘村埄鐢ㄧ郴鏁�', + `percentage_soil_wetted` float(5, 4) NULL DEFAULT NULL COMMENT '鍦熷￥婀挎鼎姣�', + `wetted_depth` int NULL DEFAULT NULL COMMENT '璁″垝婀挎鼎灞傛繁搴︼紙鍘樼背锛�', + `soil_bulk_density` float(5, 4) NULL DEFAULT NULL COMMENT '鍦熷￥瀹归噸锛堝厠/绔嬫柟鍘樼背锛�', + `field_capacity` float(5, 4) NULL DEFAULT NULL COMMENT '鐢伴棿鎸佹按閲�', + `soil_moisture_upper` float(5, 4) NULL DEFAULT NULL COMMENT '鍦熷￥閫傚疁鍚按鐜囦笂闄�', + `soil_moisture_lower` float(5, 4) NULL DEFAULT NULL COMMENT '鍦熷￥閫傚疁鍚按鐜囦笅闄�', + `designed_discharge` float(5, 1) NULL DEFAULT NULL COMMENT '鐏屾按鍣ㄨ璁℃祦閲忥紙鍗�/灏忔椂锛�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐏屾簤鍒跺害璁捐鍙傛暟琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_water_network +-- ---------------------------- +DROP TABLE IF EXISTS `pr_water_network`; +CREATE TABLE `pr_water_network` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `network_type` tinyint NOT NULL COMMENT '绠＄綉绫诲瀷;1-杈撴按锛�2-閰嶆按', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '杈撻厤姘寸缃戣〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for pr_water_price +-- ---------------------------- +DROP TABLE IF EXISTS `pr_water_price`; +CREATE TABLE `pr_water_price` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `price` float(5, 2) NOT NULL COMMENT '姘翠环', + `project_id` bigint NULL DEFAULT NULL COMMENT '椤圭洰缂栧彿', + `operator` bigint NULL DEFAULT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operate_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '姘翠环琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_alarm_state_history +-- ---------------------------- +DROP TABLE IF EXISTS `rm_alarm_state_history`; +CREATE TABLE `rm_alarm_state_history` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D锛堝閿級', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `dt` datetime NULL DEFAULT NULL COMMENT '涓婃姤鏃ユ湡鏃堕棿', + `rtu_dt` datetime NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄦ椂閽�', + `valve_state` tinyint NULL DEFAULT NULL COMMENT '鐘舵��-闃�闂�/娉碉紙0鎵撳紑銆�1鍏抽棴锛�', + `alarm_remain_water` tinyint NULL DEFAULT NULL COMMENT '鍓╀綑姘撮噺灏忎簬鎶ヨ涓婇檺鎶ヨ鎶ヨ锛�1锛氭姤璀︼紝 0锛氭甯革級', + `alarm0_water_remain` tinyint NULL DEFAULT NULL COMMENT '鍓╀綑姘撮噺涓�0鍏虫车/闃�(1锛氬叧娉碉紝0锛氭甯�)', + `alarm_exceed_year` tinyint NULL DEFAULT NULL COMMENT '骞寸敤姘撮噺澶т簬闄愬埗姘撮噺鎶ヨ(1锛氭姤璀� 0锛氭甯�)', + `alarm_water_meter_fault` tinyint NULL DEFAULT NULL COMMENT '娴侀噺璁℃晠闅�(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_loss` tinyint NULL DEFAULT NULL COMMENT '婕忔崯(鍋锋按)鎶ヨ(1锛氭姤璀︼紝 0锛氭甯�)', + `alarm_water_meter_break` tinyint NULL DEFAULT NULL COMMENT '娴侀噺璁℃崯鍧�(姝ｅ父閫氳浣嗙灛鏃朵负0)鎶ヨ(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_ele_meter_fault` tinyint NULL DEFAULT NULL COMMENT '鐢佃〃鏁呴殰鎶ヨ(1锛氭姤璀︼紝0锛氭甯�)', + `alarm0_money_remain` tinyint NULL DEFAULT NULL COMMENT '鍓╀綑閲戦涓�0(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_inner_door` tinyint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ唴闂ㄦ姤璀�(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_outer_door` tinyint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ闂ㄦ墦寮�鎶ヨ(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_ele_miss` tinyint NULL DEFAULT NULL COMMENT '浜ゆ祦缂洪」鎶ヨ(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_ele_exceed` tinyint NULL DEFAULT NULL COMMENT '浜ゆ祦杩囨祦鎶ヨ(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_ele_low_volt` tinyint NULL DEFAULT NULL COMMENT '涓夌浉鐢垫瑺鍘嬫姤璀�(1锛氭姤璀︼紝0锛氭甯�)', + `state_ic_enable` tinyint NULL DEFAULT NULL COMMENT 'IC鍗＄姸鎬�(1銆佹湁鏁堬紝0锛氭棤鏁�)', + `alarm_battery_volt` tinyint NULL DEFAULT NULL COMMENT '鐢垫睜鐢靛帇鎶ヨ锛�1锛氭姤璀︼紝0锛氭甯革級', + `alarm_valve` tinyint NULL DEFAULT NULL COMMENT '闃�闂ㄦ姤璀︼紙1锛氭姤璀︼紝0锛氭甯革級', + `power_type` tinyint NULL DEFAULT NULL COMMENT '渚涚數鏂瑰紡锛�0: 220V锛�1锛氳搫鐢垫睜锛�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_alarm_state_history_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎺у埗鍣ㄦ姤璀︿笌鐘舵�侊紙鍘嗗彶锛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_alarm_state_last +-- ---------------------------- +DROP TABLE IF EXISTS `rm_alarm_state_last`; +CREATE TABLE `rm_alarm_state_last` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D锛堝閿級', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `dt` datetime NULL DEFAULT NULL COMMENT '涓婃姤鏃ユ湡鏃堕棿', + `rtu_dt` datetime NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄦ椂閽�', + `valve_state` tinyint NULL DEFAULT NULL COMMENT '鐘舵��-闃�闂�/娉碉紙0鎵撳紑銆�1鍏抽棴锛�', + `alarm_remain_water` tinyint NULL DEFAULT NULL COMMENT '鍓╀綑姘撮噺灏忎簬鎶ヨ涓婇檺鎶ヨ鎶ヨ锛�1锛氭姤璀︼紝 0锛氭甯革級', + `alarm0_water_remain` tinyint NULL DEFAULT NULL COMMENT '鍓╀綑姘撮噺涓�0鍏虫车/闃�(1锛氬叧娉碉紝0锛氭甯�)', + `alarm_exceed_year` tinyint NULL DEFAULT NULL COMMENT '骞寸敤姘撮噺澶т簬闄愬埗姘撮噺鎶ヨ(1锛氭姤璀� 0锛氭甯�)', + `alarm_water_meter_fault` tinyint NULL DEFAULT NULL COMMENT '娴侀噺璁℃晠闅�(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_loss` tinyint NULL DEFAULT NULL COMMENT '婕忔崯(鍋锋按)鎶ヨ(1锛氭姤璀︼紝 0锛氭甯�)', + `alarm_water_meter_break` tinyint NULL DEFAULT NULL COMMENT '娴侀噺璁℃崯鍧�(姝ｅ父閫氳浣嗙灛鏃朵负0)鎶ヨ(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_ele_meter_fault` tinyint NULL DEFAULT NULL COMMENT '鐢佃〃鏁呴殰鎶ヨ(1锛氭姤璀︼紝0锛氭甯�)', + `alarm0_money_remain` tinyint NULL DEFAULT NULL COMMENT '鍓╀綑閲戦涓�0(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_inner_door` tinyint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ唴闂ㄦ姤璀�(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_outer_door` tinyint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ闂ㄦ墦寮�鎶ヨ(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_ele_miss` tinyint NULL DEFAULT NULL COMMENT '浜ゆ祦缂洪」鎶ヨ(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_ele_exceed` tinyint NULL DEFAULT NULL COMMENT '浜ゆ祦杩囨祦鎶ヨ(1锛氭姤璀︼紝0锛氭甯�)', + `alarm_ele_low_volt` tinyint NULL DEFAULT NULL COMMENT '涓夌浉鐢垫瑺鍘嬫姤璀�(1锛氭姤璀︼紝0锛氭甯�)', + `state_ic_enable` tinyint NULL DEFAULT NULL COMMENT 'IC鍗＄姸鎬�(1銆佹湁鏁堬紝0锛氭棤鏁�)', + `alarm_battery_volt` tinyint NULL DEFAULT NULL COMMENT '鐢垫睜鐢靛帇鎶ヨ锛�1锛氭姤璀︼紝0锛氭甯革級', + `alarm_valve` tinyint NULL DEFAULT NULL COMMENT '闃�闂ㄦ姤璀︼紙1锛氭姤璀︼紝0锛氭甯革級', + `power_type` tinyint NULL DEFAULT NULL COMMENT '渚涚數鏂瑰紡锛�0: 220V锛�1锛氳搫鐢垫睜锛�', + `send_ms_time` bigint NULL DEFAULT NULL COMMENT '鍙戦�佹秷鎭椂鍒伙紙姣锛�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_alarm_state_last_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎺у埗鍣ㄦ姤璀︿笌鐘舵�侊紙鏈�鏂帮級' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_client_amount_day +-- ---------------------------- +DROP TABLE IF EXISTS `rm_client_amount_day`; +CREATE TABLE `rm_client_amount_day` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '鍐滄埛ID', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '鏃ュ彇姘撮噺', + `money` float(10, 2) NULL DEFAULT NULL COMMENT '鏃ヨ姳璐归噾棰�', + `times` int NULL DEFAULT NULL COMMENT '鏃ュ彇姘存鏁�', + `dt` date NULL DEFAULT NULL COMMENT '缁熻鏃ユ湡(yyyy-mm-dd)', + `open_dt_last` datetime NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″紑闃�鏃ユ湡鏃堕棿锛坹yyy-mm-dd HH:MM:SS锛�', + `close_dt_last` datetime NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″叧闃�鏃ユ湡鏃堕棿锛坹yyy-mm-dd HH:MM:SS锛�', + `this_amount_last` float(10, 2) NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″紑闃�鍙栨按閲�', + `this_money_last` float(10, 2) NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″紑闃�鑺辫垂閲戦', + `this_time_last` int NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″紑闃�鍙栨按鏃堕暱锛堝垎閽燂級', + `rtu_dt_last` datetime NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″叧闃�涓婃姤鎺у埗鍣ㄦ椂閽�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_client_amount_day_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛鏃ョ敤姘撮噺缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_client_amount_day_last +-- ---------------------------- +DROP TABLE IF EXISTS `rm_client_amount_day_last`; +CREATE TABLE `rm_client_amount_day_last` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `last_history_id` bigint NULL DEFAULT NULL COMMENT '鎸囧悜鍘嗗彶璁板綍涓殑鏈�鏂拌褰�', + `client_id` bigint NULL DEFAULT NULL COMMENT '鍐滄埛id', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '鏃ュ彇姘撮噺', + `money` float(10, 2) NULL DEFAULT NULL COMMENT '鏃ヨ姳璐归噾棰�', + `dt` date NULL DEFAULT NULL COMMENT '缁熻鏃ユ湡(yyyy-mm-dd)', + `open_dt_last` datetime NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″紑闃�鏃ユ湡鏃堕棿锛坹yyy-mm-dd HH:MM:SS锛�', + `close_dt_last` datetime NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″叧闃�鏃ユ湡鏃堕棿锛坹yyy-mm-dd HH:MM:SS锛�', + `this_amount_last` float(10, 2) NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″紑闃�鍙栨按閲�', + `this_money_last` float(10, 2) NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″紑闃�鑺辫垂閲戦', + `this_time_last` int NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″紑闃�鍙栨按鏃堕暱锛堝垎閽燂級', + `rtu_dt_last` datetime NULL DEFAULT NULL COMMENT '缁熻鏃ユ渶鍚庝竴娆″叧闃�涓婃姤鎺у埗鍣ㄦ椂閽�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_client_amount_day_last_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛鏃ョ敤姘撮噺缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_command_history +-- ---------------------------- +DROP TABLE IF EXISTS `rm_command_history`; +CREATE TABLE `rm_command_history` ( + `com_id` bigint NOT NULL COMMENT '涓婚敭锛堝彇鍚峜om_id锛岀洰鐨勬槸閬垮厤琚獻D鎷︽埅鍣ㄨ嚜鍔ㄨ祴鍊硷級', + `command_code` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍔熻兘鐮�', + `command_name` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔鍐呭', + `intake_id` bigint NOT NULL COMMENT '鍙栨按鍙D', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '闃�鎺у櫒鍦板潃', + `protocol` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '閫氳鍗忚', + `param` json NULL COMMENT '鍙傛暟鏁版嵁', + `send_time` datetime NOT NULL COMMENT '鍙戦�佸懡浠ゆ椂闂�', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜�', + `result` tinyint NULL DEFAULT NULL COMMENT '鍛戒护缁撴灉;0-澶辫触锛�1-鎴愬姛', + `result_time` datetime NULL DEFAULT NULL COMMENT '鏀跺埌鍛戒护缁撴灉鏃堕棿', + `result_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍛戒护缁撴灉鍐呭', + PRIMARY KEY (`com_id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍛戒护鏃ュ織琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_intake_amount_day +-- ---------------------------- +DROP TABLE IF EXISTS `rm_intake_amount_day`; +CREATE TABLE `rm_intake_amount_day` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙D锛堝閿級', + `dt` date NULL DEFAULT NULL COMMENT '缁熻鏃ユ湡(yyyy-mm-dd)', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '鏃ュ彇姘撮噺锛堜笉鍖呮嫭婕忔崯姘撮噺锛�', + `money` float(10, 2) NULL DEFAULT NULL COMMENT '鏃ュ彇娑堣垂閲戦', + `times` int NULL DEFAULT NULL COMMENT '鏃ュ彇姘存鏁�', + `dt_last` datetime NULL DEFAULT NULL COMMENT '鏈�鍚庤姘撮噺涓婃姤鏁版嵁鎺ユ敹鏃堕棿(yyyy-mm-dd hh:mm:ss)', + `rtu_addr_last` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏈�鍚庤姘撮噺鐨勬帶鍒跺櫒鍦板潃', + `controller_id_last` bigint NULL DEFAULT NULL COMMENT '鏈�鍚庤姘撮噺鐨勬帶鍒跺櫒ID锛堝閿級', + `total_amount_last` float(10, 2) NULL DEFAULT NULL COMMENT '鏈�鍚庤姘撮噺鏃舵帶鍒跺櫒绱姘撮噺', + `rtu_dt_last` datetime NULL DEFAULT NULL COMMENT '鏈�鍚庤姘撮噺鏃舵帶鍒跺櫒鏃堕挓锛坹yyy-mm-dd HH:MM:SS锛�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_intake_amount_day_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍙栨按鍙ｆ棩鍙栨按閲忔紡鎹熼噺' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_intake_amount_day_last +-- ---------------------------- +DROP TABLE IF EXISTS `rm_intake_amount_day_last`; +CREATE TABLE `rm_intake_amount_day_last` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `last_history_id` bigint NULL DEFAULT NULL COMMENT '瀵瑰簲鍘嗗彶璁板綍涓殑璁板綍', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙D锛堝閿級', + `dt` date NULL DEFAULT NULL COMMENT '缁熻鏃ユ湡(yyyy-mm-dd)', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '鏃ュ彇姘撮噺锛堜笉鍖呮嫭婕忔崯姘撮噺锛�', + `money` float(10, 2) NULL DEFAULT NULL COMMENT '鏃ュ彇娑堣垂閲戦', + `times` int NULL DEFAULT NULL COMMENT '鏃ュ彇姘存鏁�', + `dt_last` datetime NULL DEFAULT NULL COMMENT '鏈�鍚庤姘撮噺涓婃姤鏁版嵁鎺ユ敹鏃堕棿(yyyy-mm-dd hh:mm:ss)', + `rtu_addr_last` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏈�鍚庤姘撮噺鐨勬帶鍒跺櫒鍦板潃', + `controller_id_last` bigint NULL DEFAULT NULL COMMENT '鏈�鍚庤姘撮噺鐨勬帶鍒跺櫒ID锛堝閿級', + `total_amount_last` float(10, 2) NULL DEFAULT NULL COMMENT '鏈�鍚庤姘撮噺鏃舵帶鍒跺櫒绱姘撮噺', + `rtu_dt_last` datetime NULL DEFAULT NULL COMMENT '鏈�鍚庤姘撮噺鏃舵帶鍒跺櫒鏃堕挓锛坹yyy-mm-dd HH:MM:SS锛�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_intake_amount_day_last_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍙栨按鍙ｆ棩鍙栨按閲忔紡鎹熼噺鏈�鏂�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_irrigate_profile +-- ---------------------------- +DROP TABLE IF EXISTS `rm_irrigate_profile`; +CREATE TABLE `rm_irrigate_profile` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `default_value` int NOT NULL COMMENT '閰嶇疆榛樿鍊�', + `unit` tinyint NOT NULL COMMENT '璁￠噺鍗曚綅;1-鏃讹紙h锛夛紝2-鍒嗭紙min锛夛紝3-绔嬫柟绫筹紙cbm锛�', + `sort` int NULL DEFAULT NULL COMMENT '鎺掑簭', + `type` tinyint NULL DEFAULT NULL COMMENT '绫诲瀷;1-鐢ㄦ椂锛�2-鐢ㄦ按閲�', + `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `deleted` bigint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;鏈垹闄や负0锛屽凡鍒犻櫎涓哄垹闄ゆ椂闂�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐏屾簤閰嶇疆琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_loss_day +-- ---------------------------- +DROP TABLE IF EXISTS `rm_loss_day`; +CREATE TABLE `rm_loss_day` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D锛堝閿級', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙ｅ疄浣揑D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `dt` date NULL DEFAULT NULL COMMENT '缁熻鏃ユ湡锛坹yyy-mm-dd锛�', + `dt_last` datetime NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄦ渶鍚庝笂鎶ユ暟鎹棩鏈熸椂闂�', + `dt_rtu` datetime NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄦ椂閽�', + `loss_amount` float(10, 2) NULL DEFAULT NULL COMMENT '鏃ユ紡鎹熸祦閲�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_loss_history_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '婕忔崯鍘嗗彶璁板綍' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_loss_day_last +-- ---------------------------- +DROP TABLE IF EXISTS `rm_loss_day_last`; +CREATE TABLE `rm_loss_day_last` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `last_history_id` bigint NULL DEFAULT NULL COMMENT '鐢辨渶鏂版暟鎹寔鏈夊巻鍙叉暟鎹腑鐨勬渶鏂拌褰旾D', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D锛堝閿級', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙ｅ疄浣揑D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `dt` date NULL DEFAULT NULL COMMENT '鏃ユ湡锛坹yyy-mm-dd锛�', + `dt_last` datetime NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄦ渶鍚庝笂鎶ユ暟鎹棩鏈熸椂闂�', + `dt_rtu` datetime NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄦ椂閽�', + `loss_amount` float(10, 2) NULL DEFAULT NULL COMMENT '鏃ユ紡鎹熸祦閲�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_loss_last_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '婕忔崯鏈�鏂拌褰�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_on_hour_report_history +-- ---------------------------- +DROP TABLE IF EXISTS `rm_on_hour_report_history`; +CREATE TABLE `rm_on_hour_report_history` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D(澶栭敭)', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙ｅ疄浣揑D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�\n', + `dt` datetime NULL DEFAULT NULL COMMENT '鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿', + `rtu_dt` datetime NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄦ椂閽�', + `instant_amount` float(10, 3) NULL DEFAULT NULL COMMENT '鐬椂娴侀噺,鍗曚綅涓簃3/h', + `total_amount` float(10, 2) NULL DEFAULT NULL COMMENT '绱娴侀噺,鍗曚綅涓簃3', + `loss_amount` float(10, 2) NULL DEFAULT NULL COMMENT '鎹熷け娴侀噺(浠�0鏃跺埌褰撳墠鐨勬紡鎹熺疮璁℃祦閲忥紝24鏃朵竴涓懆鏈燂紝0鏃跺綊0)鍗曚綅涓簃3銆�', + `water_press` float(10, 2) NULL DEFAULT NULL COMMENT '姘村帇,鍗曚綅涓篕Pa', + `battery_volt` float(10, 2) NULL DEFAULT NULL COMMENT '钃勭數姹犵數鍘嬶紝鍗曚綅涓篤', + `signal_value` int NULL DEFAULT NULL COMMENT '淇″彿寮哄害锛屽彇鍊艰寖鍥�0~99', + `water_price` float(10, 2) NULL DEFAULT NULL COMMENT '姘翠环锛屽崟浣嶄负V銆�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_on_hour_report_history_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎺у埗鍣ㄦ暣鐐规姤锛堝彧鏈夐澇鎬诲崗璁湁锛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_on_hour_report_last +-- ---------------------------- +DROP TABLE IF EXISTS `rm_on_hour_report_last`; +CREATE TABLE `rm_on_hour_report_last` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D(澶栭敭)', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙ｅ疄浣揑D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�\n', + `dt` datetime NULL DEFAULT NULL COMMENT '鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿', + `rtu_dt` datetime NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄦ椂閽�', + `instant_amount` float(10, 3) NULL DEFAULT NULL COMMENT '鐬椂娴侀噺,鍗曚綅涓簃3/h', + `total_amount` float(10, 2) NULL DEFAULT NULL COMMENT '绱娴侀噺,鍗曚綅涓簃3', + `loss_amount` float(10, 2) NULL DEFAULT NULL COMMENT '鎹熷け娴侀噺(浠�0鏃跺埌褰撳墠鐨勬紡鎹熺疮璁℃祦閲忥紝24鏃朵竴涓懆鏈燂紝0鏃跺綊0)鍗曚綅涓簃3銆�', + `water_press` float(10, 2) NULL DEFAULT NULL COMMENT '姘村帇,鍗曚綅涓篕Pa', + `battery_volt` float(10, 2) NULL DEFAULT NULL COMMENT '钃勭數姹犵數鍘嬶紝鍗曚綅涓篤', + `signal_value` int NULL DEFAULT NULL COMMENT '淇″彿寮哄害锛屽彇鍊艰寖鍥�0~99', + `water_price` float(10, 2) NULL DEFAULT NULL COMMENT '姘翠环锛屽崟浣嶄负V銆�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_on_hour_report_last_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎺у埗鍣ㄦ暣鐐规姤锛堝彧鏈夐澇鎬诲崗璁湁锛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_open_close_valve_history +-- ---------------------------- +DROP TABLE IF EXISTS `rm_open_close_valve_history`; +CREATE TABLE `rm_open_close_valve_history` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '鍐滄埛瀹炰綋澶栭敭', + `client_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍐滄埛濮撳悕', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D锛堝閿級', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙ｅ疄浣揑D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `op_dt` datetime NULL DEFAULT NULL COMMENT '寮�闃�鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿', + `op_type` tinyint NULL DEFAULT NULL COMMENT '寮�闃�绫诲瀷', + `op_total_amount` float(10, 2) NULL DEFAULT NULL COMMENT '寮�闃�鏃剁疮璁℃祦閲�', + `op_ic_card_no` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '寮�闃�IC鍗＄紪鍙�', + `op_ic_card_addr` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '寮�闃�ic鍗″湴鍧�', + `op_remain_money` float(10, 2) NULL DEFAULT NULL COMMENT '寮�闃�鏃跺墿浣欓噾棰�', + `open_dt` datetime NULL DEFAULT NULL COMMENT '寮�闃�鏃舵帶鍒跺櫒鏃堕挓', + `op_order_no` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '寮�闃�璁㈠崟鍙凤紙16浣嶆暟瀛楋級', + `op_ele_total_amount` float(10, 2) NULL DEFAULT NULL COMMENT '寮�闃�鐢佃〃绱鐢甸噺', + `op_water_remain_user` float(10, 2) NULL DEFAULT NULL COMMENT '寮�闃�鏃剁敤姘存埛鍓╀綑姘撮噺', + `cl_dt` datetime NULL DEFAULT NULL COMMENT '鍏抽榾鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿', + `cl_type` tinyint NULL DEFAULT NULL COMMENT '鍏抽榾绫诲瀷', + `cl_total_amount` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鏃剁疮璁℃祦閲�', + `cl_ic_card_no` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍏抽榾鏃禝C鍗＄紪鍙�', + `cl_ic_card_addr` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍏抽榾鏃禝C鍗″湴鍧�', + `cl_remain_money` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鏃跺墿浣欓噾棰�', + `cl_this_amount` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鏈鐢ㄦ按閲�', + `cl_this_money` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鏈娑堣垂閲戦', + `cl_this_time` int NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鏈鐢ㄦ按鏃堕暱锛堝垎閽燂級', + `cl_price` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鐨勬按浠�', + `cl_open_dt` datetime NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鐨勫紑闃�鏃舵帶鍒跺櫒鏃堕挓', + `close_dt` datetime NULL DEFAULT NULL COMMENT '鍏抽榾鏃舵帶鍒跺櫒鏃堕挓', + `cl_order_no` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍏抽榾璁㈠崟鍙凤紙16浣嶆暟瀛楋級', + `cl_ele_total_amount` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鏃剁數琛ㄧ疮璁＄數閲�', + `cl_water_remain_user` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鏃堕棿鐢ㄦ埛鍓╀綑姘撮噺', + `cl_this_ele` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鏈鐢ㄧ數閲�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_open_close_valve_history_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_open_close_valve_last +-- ---------------------------- +DROP TABLE IF EXISTS `rm_open_close_valve_last`; +CREATE TABLE `rm_open_close_valve_last` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `last_history_id` bigint NULL DEFAULT NULL COMMENT '鐢辨渶鏂版暟鎹寔鏈夊巻鍙叉暟鎹腑鐨勬渶鏂拌褰旾D', + `client_id` bigint NULL DEFAULT NULL COMMENT '鍐滄埛id', + `client_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍐滄埛濮撳悕', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D锛堝閿級', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙ｅ疄浣揑D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `op_dt` datetime NULL DEFAULT NULL COMMENT '寮�闃�鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿', + `op_type` tinyint NULL DEFAULT NULL COMMENT '寮�闃�绫诲瀷', + `op_total_amount` float(10, 2) NULL DEFAULT NULL COMMENT '寮�闃�鏃剁疮璁℃祦閲�', + `op_ic_card_no` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '寮�闃�IC鍗＄紪鍙�', + `op_ic_card_addr` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '寮�闃�ic鍗″湴鍧�', + `op_remain_money` float(10, 2) NULL DEFAULT NULL COMMENT '寮�闃�鏃跺墿浣欓噾棰�', + `open_dt` datetime NULL DEFAULT NULL COMMENT '寮�闃�鏃舵帶鍒跺櫒鏃堕挓', + `op_order_no` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '寮�闃�璁㈠崟鍙凤紙16浣嶆暟瀛楋級', + `op_ele_total_amount` float(10, 2) NULL DEFAULT NULL COMMENT '寮�闃�鐢佃〃绱鐢甸噺', + `op_water_remain_user` float(10, 2) NULL DEFAULT NULL COMMENT '寮�闃�鏃剁敤姘存埛鍓╀綑姘撮噺', + `cl_dt` datetime NULL DEFAULT NULL COMMENT '鍏抽榾鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿', + `cl_type` tinyint NULL DEFAULT NULL COMMENT '鍏抽榾绫诲瀷', + `cl_total_amount` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鏃剁疮璁℃祦閲�', + `cl_ic_card_no` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍏抽榾鏃禝C鍗＄紪鍙�', + `cl_ic_card_addr` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍏抽榾鏃禝C鍗″湴鍧�', + `cl_remain_money` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鏃跺墿浣欓噾棰�', + `cl_this_amount` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鏈鐢ㄦ按閲�', + `cl_this_money` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鏈娑堣垂閲戦', + `cl_this_time` int NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鏈鐢ㄦ按鏃堕暱锛堝垎閽燂級', + `cl_price` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鐨勬按浠�', + `cl_open_dt` datetime NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鐨勫紑闃�鏃舵帶鍒跺櫒鏃堕挓', + `close_dt` datetime NULL DEFAULT NULL COMMENT '鍏抽榾鏃舵帶鍒跺櫒鏃堕挓', + `cl_order_no` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍏抽榾璁㈠崟鍙凤紙16浣嶆暟瀛楋級', + `cl_ele_total_amount` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鏃剁數琛ㄧ疮璁＄數閲�', + `cl_water_remain_user` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鏃堕棿鐢ㄦ埛鍓╀綑姘撮噺', + `cl_this_ele` float(10, 2) NULL DEFAULT NULL COMMENT '鍏抽榾鎶ヤ腑鏈鐢ㄧ數閲�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_open_close_valve_last_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_timing_report_history +-- ---------------------------- +DROP TABLE IF EXISTS `rm_timing_report_history`; +CREATE TABLE `rm_timing_report_history` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D锛堝閿級', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙ｅ疄浣揑D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `dt` datetime NULL DEFAULT NULL COMMENT '鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿', + `rtu_dt` datetime NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄦ椂閽�', + `data_dt` date NULL DEFAULT NULL COMMENT '鏁版嵁鏃堕棿', + `water_total_amount_year` float(10, 2) NULL DEFAULT NULL COMMENT '鏈勾绱娴侀噺', + `water_total_amount_meter` float(10, 2) NULL DEFAULT NULL COMMENT '姘磋〃绱娴侀噺', + `ele_total_amount_year` float(10, 2) NULL DEFAULT NULL COMMENT '鏈勾绱鐢甸噺', + `ele_total_amount_meter` float(10, 2) NULL DEFAULT NULL COMMENT '鐢佃〃绱鐢甸噺', + `water_total_amount_day` float(10, 2) NULL DEFAULT NULL COMMENT '褰撴棩姘磋〃鍑�娴侀噺', + `water_user_total_amount_day` float(10, 2) NULL DEFAULT NULL COMMENT '褰撴棩鐢ㄦ埛鐢ㄦ按閲�', + `loss_total_amount_day` float(10, 2) NULL DEFAULT NULL COMMENT '婕忔崯姘撮噺', + `battery_volt` float(10, 2) NULL DEFAULT NULL COMMENT '鍚庡鐢垫睜鐢靛帇', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瀹氭椂锛�0鐐癸級鎶ュ巻鍙叉暟鎹〃锛堝彧鏈夋睙娴峰崗璁湁锛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_timing_report_last +-- ---------------------------- +DROP TABLE IF EXISTS `rm_timing_report_last`; +CREATE TABLE `rm_timing_report_last` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D锛堝閿級', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙ｅ疄浣揑D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `dt` datetime NULL DEFAULT NULL COMMENT '鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿', + `rtu_dt` datetime NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄦ椂閽�', + `data_dt` date NULL DEFAULT NULL COMMENT '鏁版嵁鏃堕棿', + `water_total_amount_year` float(10, 2) NULL DEFAULT NULL COMMENT '鏈勾绱娴侀噺', + `water_total_amount_meter` float(10, 2) NULL DEFAULT NULL COMMENT '姘磋〃绱娴侀噺', + `ele_total_amount_year` float(10, 2) NULL DEFAULT NULL COMMENT '鏈勾绱鐢甸噺', + `ele_total_amount_meter` float(10, 2) NULL DEFAULT NULL COMMENT '鐢佃〃绱鐢甸噺', + `water_total_amount_day` float(10, 2) NULL DEFAULT NULL COMMENT '褰撴棩姘磋〃鍑�娴侀噺', + `water_user_total_amount_day` float(10, 2) NULL DEFAULT NULL COMMENT '褰撴棩鐢ㄦ埛鐢ㄦ按閲�', + `loss_total_amount_day` float(10, 2) NULL DEFAULT NULL COMMENT '婕忔崯姘撮噺', + `battery_volt` float(10, 2) NULL DEFAULT NULL COMMENT '鍚庡鐢垫睜鐢靛帇', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瀹氭椂锛�0鐐癸級鎶ユ渶鏂版暟鎹〃锛堝彧鏈夋睙娴峰崗璁湁锛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_work_report_history +-- ---------------------------- +DROP TABLE IF EXISTS `rm_work_report_history`; +CREATE TABLE `rm_work_report_history` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '鍐滄埛瀹炰綋澶栭敭', + `client_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍐滄埛濮撳悕', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D锛堝閿級', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙ｅ疄浣揑D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `dt` datetime NULL DEFAULT NULL COMMENT '鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿', + `rtu_dt` datetime NULL DEFAULT NULL COMMENT '寮�闃�鏃舵帶鍒跺櫒鏃堕挓', + `order_no` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '璁㈠崟鍙凤紙16浣嶆暟瀛楋級', + `ic_card_addr` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'IC鍗″湴鍧�(杩滅▼寮�娉�/闃�鏃跺叏涓�0)', + `ic_card_no` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'IC鍗＄紪鍙�', + `water_level` float NULL DEFAULT NULL COMMENT '姘翠綅锛堝崟浣�0.001绫筹級', + `water_press` float NULL DEFAULT NULL COMMENT '姘村帇锛堝崟浣�0.01鍗冨笗锛�', + `water_instant` float NULL DEFAULT NULL COMMENT '鐬椂娴侀噺锛堝崟浣�0.01m3/灏忔椂锛�', + `water_total` float NULL DEFAULT NULL COMMENT '姘磋〃绱娴侀噺(鍗曚綅0.01m3)', + `ele_total` float NULL DEFAULT NULL COMMENT '鐢佃〃绱鐢甸噺(鍗曚綅0.01搴�)', + `money_remain` float NULL DEFAULT NULL COMMENT '鐢ㄦ埛鍓╀綑閲戦(鍗曚綅0.01鍏�)', + `water_remain` float NULL DEFAULT NULL COMMENT '鐢ㄦ埛鍓╀綑姘撮噺(鍗曚綅0.01m3)', + `this_ele` float NULL DEFAULT NULL COMMENT '鏈浣跨敤鐢甸噺(鍗曚綅0.01搴�)', + `this_water` float NULL DEFAULT NULL COMMENT '鏈浣跨敤姘撮噺(鍗曚綅0.01m3)', + `this_money` float NULL DEFAULT NULL COMMENT '鏈浣跨敤閲戦(鍗曚綅0.01鍏�)', + `this_duration` int NULL DEFAULT NULL COMMENT '鏈浣跨敤鏃堕暱(鍗曚綅:鍒嗛挓 鏈�澶�9999鍒嗛挓)', + `water_price` float NULL DEFAULT NULL COMMENT '褰撳墠姘撮噺鍗曚环(鍗曚綅0.01鍏� 鏈�澶�99.99鍏�)', + `ele_price` float NULL DEFAULT NULL COMMENT '褰撳墠鐢甸噺鍗曚环(鍗曚綅0.01鍏� 鏈�澶�99.99鍏�)', + `a_volt` float NULL DEFAULT NULL COMMENT '浜ゆ祦A鐩哥數鍘�(鍗曚綅0.1浼忕壒)', + `b_volt` float NULL DEFAULT NULL COMMENT '浜ゆ祦B鐩哥數鍘�(鍗曚綅0.1浼忕壒)', + `c_volt` float NULL DEFAULT NULL COMMENT '浜ゆ祦C鐩哥數鍘�(鍗曚綅0.1浼忕壒)', + `a_current` float NULL DEFAULT NULL COMMENT '浜ゆ祦A鐩哥數娴�(鍗曚綅0.1瀹夊煿)', + `b_current` float NULL DEFAULT NULL COMMENT '浜ゆ祦B鐩哥數娴佹暟鎹�(鍗曚綅0.1瀹夊煿)', + `c_current` float NULL DEFAULT NULL COMMENT '浜ゆ祦C鐩哥數娴�(鍗曚綅0.1瀹夊煿)', + `battery_volt` float NULL DEFAULT NULL COMMENT '鍚庡鐢垫睜鐢靛帇(鍗曚綅0.01浼忕壒)', + `water_meter_trans_volt` float NULL DEFAULT NULL COMMENT '姘磋〃杩滀紶鐢靛帇(鍗曚綅0.01浼忕壒)', + `water_meter_work_volt` float NULL DEFAULT NULL COMMENT '姘磋〃宸ヤ綔鐢靛帇(鍗曚綅0.01浼忕壒)', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_work_report_history_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎺у埗鍣ㄩ榾寮�宸ヤ綔鎶ュ巻鍙叉暟鎹�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for rm_work_report_last +-- ---------------------------- +DROP TABLE IF EXISTS `rm_work_report_last`; +CREATE TABLE `rm_work_report_last` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '鍐滄埛瀹炰綋澶栭敭', + `client_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍐滄埛濮撳悕', + `controller_id` bigint NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ疄浣揑D锛堝閿級', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙ｅ疄浣揑D锛堝閿級', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `dt` datetime NULL DEFAULT NULL COMMENT '鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿', + `rtu_dt` datetime NULL DEFAULT NULL COMMENT '寮�闃�鏃舵帶鍒跺櫒鏃堕挓', + `order_no` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '璁㈠崟鍙凤紙16浣嶆暟瀛楋級', + `ic_card_addr` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'IC鍗″湴鍧�(杩滅▼寮�娉�/闃�鏃跺叏涓�0)', + `ic_card_no` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'IC鍗＄紪鍙�', + `water_level` float(10, 3) NULL DEFAULT NULL COMMENT '姘翠綅锛堝崟浣�0.001绫筹級', + `water_press` float(10, 2) NULL DEFAULT NULL COMMENT '姘村帇锛堝崟浣�0.01鍗冨笗锛�', + `water_instant` float(10, 2) NULL DEFAULT NULL COMMENT '鐬椂娴侀噺锛堝崟浣�0.01m3/灏忔椂锛�', + `water_total` float(10, 2) NULL DEFAULT NULL COMMENT '姘磋〃绱娴侀噺(鍗曚綅0.01m3)', + `ele_total` float(10, 2) NULL DEFAULT NULL COMMENT '鐢佃〃绱鐢甸噺(鍗曚綅0.01搴�)', + `money_remain` float(10, 2) NULL DEFAULT NULL COMMENT '鐢ㄦ埛鍓╀綑閲戦(鍗曚綅0.01鍏�)', + `water_remain` float(10, 2) NULL DEFAULT NULL COMMENT '鐢ㄦ埛鍓╀綑姘撮噺(鍗曚綅0.01m3)', + `this_ele` float(10, 2) NULL DEFAULT NULL COMMENT '鏈浣跨敤鐢甸噺(鍗曚綅0.01搴�)', + `this_water` float(10, 2) NULL DEFAULT NULL COMMENT '鏈浣跨敤姘撮噺(鍗曚綅0.01m3)', + `this_money` float(10, 2) NULL DEFAULT NULL COMMENT '鏈浣跨敤閲戦(鍗曚綅0.01鍏�)', + `this_duration` int NULL DEFAULT NULL COMMENT '鏈浣跨敤鏃堕暱(鍗曚綅:鍒嗛挓 鏈�澶�9999鍒嗛挓)', + `water_price` float(10, 2) NULL DEFAULT NULL COMMENT '褰撳墠姘撮噺鍗曚环(鍗曚綅0.01鍏� 鏈�澶�99.99鍏�)', + `ele_price` float(10, 2) NULL DEFAULT NULL COMMENT '褰撳墠鐢甸噺鍗曚环(鍗曚綅0.01鍏� 鏈�澶�99.99鍏�)', + `a_volt` float(10, 1) NULL DEFAULT NULL COMMENT '浜ゆ祦A鐩哥數鍘�(鍗曚綅0.1浼忕壒)', + `b_volt` float(10, 1) NULL DEFAULT NULL COMMENT '浜ゆ祦B鐩哥數鍘�(鍗曚綅0.1浼忕壒)', + `c_volt` float(10, 1) NULL DEFAULT NULL COMMENT '浜ゆ祦C鐩哥數鍘�(鍗曚綅0.1浼忕壒)', + `a_current` float(10, 1) NULL DEFAULT NULL COMMENT '浜ゆ祦A鐩哥數娴�(鍗曚綅0.1瀹夊煿)', + `b_current` float(10, 1) NULL DEFAULT NULL COMMENT '浜ゆ祦B鐩哥數娴佹暟鎹�(鍗曚綅0.1瀹夊煿)', + `c_current` float(10, 1) NULL DEFAULT NULL COMMENT '浜ゆ祦C鐩哥數娴�(鍗曚綅0.1瀹夊煿)', + `battery_volt` float(10, 2) NULL DEFAULT NULL COMMENT '鍚庡鐢垫睜鐢靛帇(鍗曚綅0.01浼忕壒)', + `water_meter_trans_volt` float(10, 2) NULL DEFAULT NULL COMMENT '姘磋〃杩滀紶鐢靛帇(鍗曚綅0.01浼忕壒)', + `water_meter_work_volt` float(10, 2) NULL DEFAULT NULL COMMENT '姘磋〃宸ヤ綔鐢靛帇(鍗曚綅0.01浼忕壒)', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `rm_work_report_last_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎺у埗鍣ㄩ榾寮�宸ヤ綔鎶ユ渶鏂版暟鎹�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_active_card +-- ---------------------------- +DROP TABLE IF EXISTS `se_active_card`; +CREATE TABLE `se_active_card` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `cardId` bigint NOT NULL COMMENT '姘村崱ID;姘村崱涓婚敭', + `clientId` bigint NOT NULL COMMENT '鍐滄埛ID;鍐滄埛涓婚敭', + `cardCost` int NULL DEFAULT 10 COMMENT '鍗＄墖璐圭敤', + `paymentId` bigint NOT NULL COMMENT '浠樻鏂瑰紡缂栧彿', + `reissueAmount` double NULL DEFAULT NULL COMMENT '琛ュ崱閲戦', + `operateType` tinyint NULL DEFAULT 1 COMMENT '鎿嶄綔绫诲瀷;1-寮�鍗★紝2-琛ュ崱', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '寮�鍗�/琛ュ崱琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_audits +-- ---------------------------- +DROP TABLE IF EXISTS `se_audits`; +CREATE TABLE `se_audits` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `general_id` bigint NULL DEFAULT NULL COMMENT '鎬昏处ID', + `audit_status` tinyint NULL DEFAULT NULL COMMENT '瀹℃牳鐘舵��;1-鏈鏍革紝2-鍚屾剰锛�3-椹冲洖', + `audit_opinion` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '瀹℃牳鎰忚', + `operator` bigint NULL DEFAULT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operate_dt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瀹℃牳璁板綍琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_cancel +-- ---------------------------- +DROP TABLE IF EXISTS `se_cancel`; +CREATE TABLE `se_cancel` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `cardId` bigint NOT NULL COMMENT '姘村崱缂栧彿', + `clientId` bigint NOT NULL COMMENT '鍐滄埛缂栧彿', + `refund` float(10, 2) NOT NULL COMMENT '閫�娆鹃噾棰�', + `refundType` tinyint NULL DEFAULT NULL COMMENT '閫�娆炬柟寮�;1-鐜伴噾', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '姘村崱娉ㄩ攢琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_card_operate +-- ---------------------------- +DROP TABLE IF EXISTS `se_card_operate`; +CREATE TABLE `se_card_operate` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `card_id` bigint NULL DEFAULT NULL COMMENT '姘村崱ID', + `client_id` bigint NULL DEFAULT NULL COMMENT '鍐滄埛ID', + `money` float(10, 2) NULL DEFAULT NULL COMMENT '鍗＄墖浣欓;鍏呭�笺�佹寕澶便�佸啿姝ｃ�佽В閿�', + `system_balance` float(10, 2) NULL DEFAULT NULL COMMENT '绯荤粺浣欓;鍐叉鏃朵娇鐢�', + `trade_amount` float(10, 2) NULL DEFAULT NULL COMMENT '浜ゆ槗閲戦;璐按閲戦銆侀��娆鹃噾棰�', + `price` float(4, 2) NULL DEFAULT NULL COMMENT '姘翠环;鍏呭�兼椂浣跨敤', + `card_cost` int NULL DEFAULT 10 COMMENT '璐崱閲戦', + `gift` float(10, 2) NULL DEFAULT NULL COMMENT '璧犻�侀噾棰�', + `refund_amount` float(10, 2) NULL DEFAULT NULL COMMENT '杩旇繕閲戦;琛ユ墸鎿嶄綔鏃惰繑杩樼殑閲戦', + `no_trade_amount` float(10, 2) NULL DEFAULT NULL COMMENT '闈炰氦鏄撻噾棰�;琛ュ崱閲戦銆佽ˉ鎵ｉ噾棰濄�佸墿浣欓噾棰濓紙瑙ｉ攣锛�', + `operate_type` tinyint NULL DEFAULT NULL COMMENT '鎿嶄綔绫诲瀷;1-寮�鍗★紝2-鍏呭�硷紝3-閿�鍗★紝4-琛ュ崱锛�5-琛ユ墸锛�6-鎸傚け锛�7-鍐叉锛�8-瑙ｉ攣锛�9-娑堣垂', + `payment_id` bigint NULL DEFAULT NULL COMMENT '浠樻鏂瑰紡缂栧彿', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operate_dt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `operate_valid` tinyint NULL DEFAULT 1 COMMENT '鎿嶄綔鏄惁鏈夋晥;1-鏃犳晥锛�2-鏈夋晥', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '姘村崱鎿嶄綔琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_client +-- ---------------------------- +DROP TABLE IF EXISTS `se_client`; +CREATE TABLE `se_client` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `countyId` bigint NULL DEFAULT NULL COMMENT '鍘縄D', + `townId` bigint NULL DEFAULT NULL COMMENT '闀嘔D', + `villageId` bigint NOT NULL COMMENT '鏉慖D', + `blockId` bigint NULL DEFAULT NULL COMMENT '鐗囧尯ID', + `divideId` bigint NULL DEFAULT NULL COMMENT '鍒嗘按鎴縄D', + `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍐滄埛濮撳悕', + `virtualId` bigint NULL DEFAULT NULL COMMENT '铏氭嫙鍗″彿;10浣嶏紝浠�1000000000寮�濮�', + `clientNum` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍐滄埛缂栧彿;8浣嶅尯鍒� + 4涓洪『搴忓彿', + `districtNum` bigint NOT NULL COMMENT '鍖哄垝缂栫爜涓�;鐪佸尯鍒�+甯傚尯鍒�+鍘垮尯鍒�+闀囧尯鍒�+鏉戝尯鍒�', + `districtTitle` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍖哄垝鍚嶇О涓�;鍘垮悕+闀囧悕+鏉戝悕锛岀敤浜庡綊灞炲湴', + `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鎵嬫満鍙�', + `idCard` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '韬唤璇佸彿', + `area` double NULL DEFAULT NULL COMMENT '绉嶆闈㈢Н', + `typeId` bigint NULL DEFAULT NULL COMMENT '鐢ㄦ按绫诲瀷ID', + `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '琛楅亾鍙婇棬鐗屽彿', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT NULL COMMENT '鎿嶄綔鏃堕棿', + `disabled` tinyint NULL DEFAULT 0 COMMENT '绂佹鏍囧織;0-鏈锛�1-宸茬', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_client_2 +-- ---------------------------- +DROP TABLE IF EXISTS `se_client_2`; +CREATE TABLE `se_client_2` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `countyId` bigint NOT NULL COMMENT '鍘縄D', + `townId` bigint NOT NULL COMMENT '闀嘔D', + `villageId` bigint NOT NULL COMMENT '鏉慖D', + `blockId` bigint NOT NULL COMMENT '鐗囧尯ID', + `divideId` bigint NULL DEFAULT NULL COMMENT '鍒嗘按鎴縄D', + `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍐滄埛濮撳悕', + `virtualId` bigint NULL DEFAULT NULL COMMENT '铏氭嫙鍗″彿;10浣嶏紝浠�1000000000寮�濮�', + `clientNum` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍐滄埛缂栧彿;8浣嶅尯鍒� + 4涓洪『搴忓彿', + `districtNum` bigint NOT NULL COMMENT '鍖哄垝缂栫爜涓�;鐪佸尯鍒�+甯傚尯鍒�+鍘垮尯鍒�+闀囧尯鍒�+鏉戝尯鍒�', + `districtTitle` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍖哄垝鍚嶇О涓�;鍘垮悕+闀囧悕+鏉戝悕锛岀敤浜庡綊灞炲湴', + `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鎵嬫満鍙�', + `idCard` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '韬唤璇佸彿', + `area` double NULL DEFAULT NULL COMMENT '绉嶆闈㈢Н', + `typeId` bigint NULL DEFAULT NULL COMMENT '鐢ㄦ按绫诲瀷ID', + `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '琛楅亾鍙婇棬鐗屽彿', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT NULL COMMENT '鎿嶄綔鏃堕棿', + `disabled` tinyint NULL DEFAULT 0 COMMENT '绂佹鏍囧織;0-鏈锛�1-宸茬', + `deleted` tinyint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滀复鏃舵埛琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for se_client_card +-- ---------------------------- +DROP TABLE IF EXISTS `se_client_card`; +CREATE TABLE `se_client_card` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `protocol` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '閫氳鍗忚', + `cardAddr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姘村崱鍦板潃;鐗╃悊鍗¤嚜甯﹀湴鍧�', + `cardNum` bigint NOT NULL COMMENT '姘村崱缂栧彿;16浣嶆按鍗＄紪鍙�', + `clientId` bigint NULL DEFAULT NULL COMMENT '鍐滄埛ID;鍐滄埛涓婚敭', + `money` float(10, 2) NULL DEFAULT 0.00 COMMENT '浣欓', + `state` tinyint NULL DEFAULT 1 COMMENT '鍗＄墖鐘舵��;1-姝ｅ父锛�2-宸叉敞閿�锛�3-宸叉寕澶�', + `original_card_id` bigint NULL DEFAULT NULL COMMENT '鍘熸按鍗D;琛ュ崱鏃舵寕澶卞崱鐨処D', + `createDt` datetime NULL DEFAULT NULL COMMENT '寮�鍗℃椂闂�', + `replaceDt` datetime NULL DEFAULT NULL COMMENT '琛ュ崱鏃堕棿', + `rechargeDt` datetime NULL DEFAULT NULL COMMENT '鍏呭�兼椂闂�', + `lossDtDt` datetime NULL DEFAULT NULL COMMENT '鎸傚け鏃堕棿', + `cancelDt` datetime NULL DEFAULT NULL COMMENT '娉ㄩ攢鏃堕棿', + `unlockDt` datetime NULL DEFAULT NULL COMMENT '瑙ｉ攣鏃堕棿', + `reversalDt` datetime NULL DEFAULT NULL COMMENT '鍐叉鏃堕棿', + `refundDt` datetime NULL DEFAULT NULL COMMENT '琛ユ墸鏃堕棿', + `consumeDt` datetime NULL DEFAULT NULL COMMENT '娑堣垂鏃堕棿', + `lastOper` tinyint NULL DEFAULT NULL COMMENT '鏈�鍚庢搷浣滅被鍨�;1-寮�鍗★紝2-琛ュ崱锛�3-鍏呭�硷紝4-鎸傚け锛�5-娉ㄩ攢锛�6-瑙ｉ攣锛�7-鍐叉锛�8-娑堣垂', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛姘村崱琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_code_verify +-- ---------------------------- +DROP TABLE IF EXISTS `se_code_verify`; +CREATE TABLE `se_code_verify` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鎵嬫満鍙�', + `security_code` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '楠岃瘉鐮�', + `expires` bigint NOT NULL COMMENT '杩囨湡鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '楠岃瘉鐮佽褰曡〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_consume +-- ---------------------------- +DROP TABLE IF EXISTS `se_consume`; +CREATE TABLE `se_consume` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `wallet_id` bigint NOT NULL COMMENT '閽卞寘ID', + `client_id` bigint NOT NULL COMMENT '鍐滄埛ID', + `money` float(10, 2) NULL DEFAULT NULL COMMENT '閽卞寘浣欓', + `consumption` float(10, 2) NOT NULL COMMENT '娑堣垂閲戦', + `after_consume` float(10, 2) NULL DEFAULT NULL COMMENT '娑堣垂鍚庝綑棰�', + `duration` float(4, 2) NULL DEFAULT NULL COMMENT '鐢ㄦ按鏃堕暱', + `vot` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '寮�闃�鏃堕棿', + `vct` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍏抽榾鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢靛瓙閽卞寘娑堣垂琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_general +-- ---------------------------- +DROP TABLE IF EXISTS `se_general`; +CREATE TABLE `se_general` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `cashier_id` bigint NULL DEFAULT NULL COMMENT '鏀堕摱鍛業D', + `cashier_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏀堕摱鍛樺鍚�', + `trade_amount` float(10, 2) NULL DEFAULT NULL COMMENT '瀹炴敹閲戦', + `gift` float(10, 2) NULL DEFAULT NULL COMMENT '璧犻�侀噾棰�', + `refund_amount` float(10, 2) NULL DEFAULT NULL COMMENT '杩斿洖閲戦', + `operate_date` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '浜ゆ槗鏃ユ湡', + `audit_status` tinyint NULL DEFAULT 1 COMMENT '瀹℃牳鐘舵��;1-鏈鏍革紝2-鍚屾剰锛�3-椹冲洖', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎬昏处琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_issue_report +-- ---------------------------- +DROP TABLE IF EXISTS `se_issue_report`; +CREATE TABLE `se_issue_report` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `content` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍙嶉鍐呭', + `images` json NULL COMMENT '鐓х墖鍒楄〃', + `audios` json NULL COMMENT '闊抽鍒楄〃', + `videos` json NULL COMMENT '瑙嗛鍒楄〃', + `lng` decimal(18, 15) NULL DEFAULT NULL COMMENT '缁忓害', + `lat` decimal(18, 15) NULL DEFAULT NULL COMMENT '绾害', + `client_id` bigint NULL DEFAULT NULL COMMENT '鍐滄埛ID', + `report_time` datetime NULL DEFAULT NULL COMMENT '涓婃姤鏃堕棿', + `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鑱旂郴鐢佃瘽', + `state` tinyint NULL DEFAULT NULL COMMENT '鐘舵��;1-鏈彈鐞嗭紝2-宸插彈鐞嗭紝3宸插垹闄�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '闂涓婃姤璁板綍琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for se_loss +-- ---------------------------- +DROP TABLE IF EXISTS `se_loss`; +CREATE TABLE `se_loss` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `cardId` bigint NOT NULL COMMENT '姘村崱缂栧彿', + `clientId` bigint NOT NULL COMMENT '鍐滄埛缂栧彿', + `money` float(10, 2) NULL DEFAULT 0.00 COMMENT '浣欓', + `refund` float(10, 2) NULL DEFAULT 0.00 COMMENT '閫�娆鹃噾棰�', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '姘村崱鎸傚け琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_manager_card +-- ---------------------------- +DROP TABLE IF EXISTS `se_manager_card`; +CREATE TABLE `se_manager_card` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `card_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍗＄墖鍦板潃', + `card_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍗＄墖缂栧彿', + `card_type` tinyint NOT NULL DEFAULT 1 COMMENT '鍗＄墖绫诲瀷;2-绠＄悊绉戯紝4-寮�鍏抽榾鍗★紝5娓呯┖鍗�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '寮�鍗℃椂闂�', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绠＄悊鍛樻按鍗¤〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_open_id +-- ---------------------------- +DROP TABLE IF EXISTS `se_open_id`; +CREATE TABLE `se_open_id` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NOT NULL COMMENT '鍐滄埛ID', + `open_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鐢ㄦ埛鍞竴鏍囪瘑', + `session_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '浼氳瘽瀵嗛挜', + `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '寰俊鐢ㄦ埛璐︽埛琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_payment_method +-- ---------------------------- +DROP TABLE IF EXISTS `se_payment_method`; +CREATE TABLE `se_payment_method` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍚嶇О', + `remarks` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `deleted` tinyint NULL DEFAULT NULL COMMENT '閫昏緫鍒犻櫎鏍囪瘑;0-鏈垹闄わ紝1-鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `se_payment_method_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_recharge +-- ---------------------------- +DROP TABLE IF EXISTS `se_recharge`; +CREATE TABLE `se_recharge` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `cardId` bigint NOT NULL COMMENT '姘村崱ID;姘村崱涓婚敭', + `clientId` bigint NOT NULL COMMENT '鍐滄埛ID;鍐滆涓婚敭', + `money` float(10, 2) NOT NULL COMMENT '鍗＄墖浣欓', + `amount` float(10, 2) NOT NULL COMMENT '鍏呭�奸噾棰�', + `gift` float(10, 2) NULL DEFAULT NULL COMMENT '璧犻�侀噾棰�', + `afterRecharge` float(10, 2) NULL DEFAULT NULL COMMENT '鍏呭�煎悗浣欓', + `paymentId` bigint NOT NULL COMMENT '浠樻鏂瑰紡缂栧彿', + `price` float(4, 2) NULL DEFAULT NULL COMMENT '姘翠环', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '姘村崱鍏呭�艰〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_recharge_history +-- ---------------------------- +DROP TABLE IF EXISTS `se_recharge_history`; +CREATE TABLE `se_recharge_history` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `cardId` bigint NOT NULL COMMENT '姘村崱缂栧彿', + `clientId` bigint NOT NULL COMMENT '鍐滄埛缂栧彿', + `money` float(10, 2) NOT NULL COMMENT '鍗＄墖浣欓', + `amount` float(10, 2) NOT NULL COMMENT '鍏呭�奸噾棰�', + `gift` float(10, 2) NULL DEFAULT NULL COMMENT '璧犻�侀噾棰�', + `afterRecharge` float(10, 2) NULL DEFAULT NULL COMMENT '鍏呭�煎悗浣欓', + `paymentId` bigint NOT NULL COMMENT '浠樻鏂瑰紡缂栧彿', + `price` float(4, 2) NULL DEFAULT NULL COMMENT '姘翠环', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + `operate_valid` tinyint NULL DEFAULT 1 COMMENT '鎿嶄綔鏄惁鏈夋晥;1-鏃犳晥锛�2-鏈夋晥', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍏呭�煎巻鍙茶〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_recharge_profile +-- ---------------------------- +DROP TABLE IF EXISTS `se_recharge_profile`; +CREATE TABLE `se_recharge_profile` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `recharge_amount` float(10, 2) NOT NULL COMMENT '鍏呭�奸噾棰�', + `sort` int NOT NULL COMMENT '鎺掑簭', + `deleted` bigint NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎鏍囪瘑;鏈垹闄や负0锛屽凡鍒犻櫎涓哄垹闄ゆ椂闂�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '甯哥敤鍏呭�奸噾棰濋厤缃〃' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for se_refund +-- ---------------------------- +DROP TABLE IF EXISTS `se_refund`; +CREATE TABLE `se_refund` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `vc_id` bigint NULL DEFAULT NULL COMMENT '铏氭嫙鍗D', + `client_id` bigint NOT NULL COMMENT '鍐滄埛ID', + `money` float(10, 2) NULL DEFAULT NULL COMMENT '閽卞寘浣欓', + `refund_amount` float(10, 2) NULL DEFAULT NULL COMMENT '閫�娆鹃噾棰�', + `after_refund` float(10, 2) NULL DEFAULT NULL COMMENT '閫�娆惧悗浣欓', + `application_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鐢宠鏃堕棿', + `auditor` bigint NULL DEFAULT NULL COMMENT '瀹℃牳浜�', + `audit_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '瀹℃牳鏃堕棿', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '瀹℃牳澶囨敞', + `refund_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '閫�娆惧崟鍙�;12浣嶅啘鎴峰彿+17浣嶆椂闂存埑+2浣嶆暟閲�', + `refund_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '閫�娆惧畬鎴愭椂闂�', + `refund_status` tinyint NULL DEFAULT 1 COMMENT '閫�娆剧姸鎬�;1-寰呭鏍革紝2-寰呴��娆撅紝3-宸查��娆�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '铏氭嫙鍗￠��娆捐〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_report_reply +-- ---------------------------- +DROP TABLE IF EXISTS `se_report_reply`; +CREATE TABLE `se_report_reply` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `report_id` bigint NOT NULL COMMENT '闂涓婃姤ID', + `reply_content` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍥炲鍐呭', + `reply_time` datetime NULL DEFAULT NULL COMMENT '鍥炲鏃堕棿', + `replier_id` bigint NOT NULL COMMENT '鍥炲浜篒D', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '涓婃姤鍥炲璁板綍琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for se_reversal +-- ---------------------------- +DROP TABLE IF EXISTS `se_reversal`; +CREATE TABLE `se_reversal` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `cardId` bigint NOT NULL COMMENT '姘村崱缂栧彿', + `clientId` bigint NOT NULL COMMENT '鍐滄埛缂栧彿', + `cardBalance` float(10, 2) NOT NULL COMMENT '鍗＄墖浣欓', + `systemBalance` float(10, 2) NOT NULL COMMENT '绯荤粺浣欓', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐叉琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_unlock +-- ---------------------------- +DROP TABLE IF EXISTS `se_unlock`; +CREATE TABLE `se_unlock` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `cardId` bigint NOT NULL COMMENT '姘村崱缂栧彿', + `clientId` bigint NOT NULL COMMENT '鍐滄埛缂栧彿', + `money` float(10, 2) NOT NULL COMMENT '鍓╀綑閲戦', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜虹紪鍙�', + `operateDt` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '姘村崱瑙ｉ攣琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_vc_operate +-- ---------------------------- +DROP TABLE IF EXISTS `se_vc_operate`; +CREATE TABLE `se_vc_operate` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `vc_id` bigint NULL DEFAULT NULL COMMENT '铏氭嫙鍗D', + `client_id` bigint NULL DEFAULT NULL COMMENT '鍐滄埛ID', + `operate_type` tinyint NULL DEFAULT NULL COMMENT '鎿嶄綔绫诲瀷;1-寮�鎴凤紝2-鍏呭�硷紝3-娑堣垂锛�4-閿�鎴凤紝5-鐢宠閫�娆撅紝6-閫�娆惧鏍革紝7-閫�娆�', + `recharge_id` bigint NULL DEFAULT NULL COMMENT '鍏呭�糏D;鍏呭�兼椂濉啓', + `operator` bigint NOT NULL COMMENT '鎿嶄綔浜�', + `operate_time` datetime NULL DEFAULT NULL COMMENT '鎿嶄綔鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '铏氭嫙鍗℃搷浣滆〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_vc_recharge +-- ---------------------------- +DROP TABLE IF EXISTS `se_vc_recharge`; +CREATE TABLE `se_vc_recharge` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `vc_id` bigint NOT NULL COMMENT '铏氭嫙鍗D', + `client_id` bigint NOT NULL COMMENT '鍐滄埛ID', + `money` float(10, 2) NULL DEFAULT NULL COMMENT '铏氭嫙鍗′綑棰�', + `after_recharge` float(10, 2) NULL DEFAULT NULL COMMENT '鍏呭�煎悗浣欓', + `order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '璁㈠崟鍙�', + `recharge_amount` float(10, 2) NOT NULL COMMENT '鍏呭�奸噾棰�', + `order_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '涓嬪崟鏃堕棿', + `recharge_time` datetime NULL DEFAULT NULL COMMENT '鍏呭�煎畬鎴愭椂闂�', + `order_state` tinyint NULL DEFAULT 1 COMMENT '璁㈠崟鐘舵��;1-鏈敮浠橈紝2-宸叉敮浠�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '铏氭嫙鍗″厖鍊艰〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_vc_refund +-- ---------------------------- +DROP TABLE IF EXISTS `se_vc_refund`; +CREATE TABLE `se_vc_refund` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `vc_id` bigint NULL DEFAULT NULL COMMENT '铏氭嫙鍗D', + `client_id` bigint NOT NULL COMMENT '鍐滄埛ID', + `money` float(10, 2) NULL DEFAULT NULL COMMENT '铏氭嫙鍗′綑棰�', + `refund_amount` float(10, 2) NULL DEFAULT NULL COMMENT '閫�娆鹃噾棰�', + `after_refund` float(10, 2) NULL DEFAULT NULL COMMENT '閫�娆惧悗浣欓', + `application_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鐢宠鏃堕棿', + `auditor` bigint NULL DEFAULT NULL COMMENT '瀹℃牳浜�', + `audit_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '瀹℃牳鏃堕棿', + `remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '瀹℃牳澶囨敞', + `refund_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '閫�娆惧崟鍙�;12浣嶅啘鎴峰彿+17浣嶆椂闂存埑+2浣嶆暟閲�', + `refund_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '閫�娆惧畬鎴愭椂闂�', + `refund_status` tinyint NULL DEFAULT 1 COMMENT '閫�娆剧姸鎬�;1-寰呭鏍革紝2-寰呴��娆撅紝3-宸查��娆�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '铏氭嫙鍗￠��娆捐〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_vc_refund_item +-- ---------------------------- +DROP TABLE IF EXISTS `se_vc_refund_item`; +CREATE TABLE `se_vc_refund_item` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `refund_id` bigint NOT NULL COMMENT '閫�娆綢D', + `order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '璁㈠崟鍙�;12浣嶅啘鎴峰ソ+17浣嶆椂闂存埑', + `refund_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '閫�娆惧崟鍙�;12浣嶅啘鎴峰彿+17浣嶆椂闂存埑+2浣嶆暟閲�', + `refund_amount` int NULL DEFAULT NULL COMMENT '閫�娆鹃噾棰�;涓庤鍗曞搴旂殑閫�娆鹃噾棰�', + `create_time` datetime NOT NULL COMMENT '閫�娆惧崟鍒涘缓鏃堕棿', + `refund_time` datetime NULL DEFAULT NULL COMMENT '閫�娆惧畬鎴愭椂闂�', + `refund_status` tinyint NOT NULL COMMENT '閫�娆剧姸鎬�;1-鏈��娆撅紝2-宸查��娆�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '铏氭嫙鍗￠��娆惧垎椤硅〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_virtual_card +-- ---------------------------- +DROP TABLE IF EXISTS `se_virtual_card`; +CREATE TABLE `se_virtual_card` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `vc_num` bigint NOT NULL COMMENT '铏氭嫙鍗＄紪鍙�', + `client_id` bigint NOT NULL COMMENT '鍐滄埛ID', + `money` float(10, 2) NULL DEFAULT 0.00 COMMENT '璐︽埛浣欓', + `state` tinyint NULL DEFAULT 1 COMMENT '姘村崱鐘舵��;1-姝ｅ父锛�2-宸叉敞閿�', + `last_operate` tinyint NULL DEFAULT 1 COMMENT '鏈�鍚庢搷浣�;1-寮�鎴凤紝2-鍏呭�硷紝3-娑堣垂锛�4-鐢宠閫�娆撅紝5-閫�娆惧鏍�', + `last_operate_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鏈�鍚庢搷浣滄椂闂�', + `in_use` tinyint NULL DEFAULT NULL COMMENT '鏄惁浣跨敤涓�;0-鏈娇鐢紝1-浣跨敤涓�', + `intake_id` bigint NULL DEFAULT NULL COMMENT '铏氭嫙鍗′娇鐢ㄦ椂鎵�搴旂敤鐨勫彇姘村彛ID', + `open_time` datetime NULL DEFAULT NULL COMMENT '寮�闃�鏃堕棿', + `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '铏氭嫙鍗¤〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_wallet +-- ---------------------------- +DROP TABLE IF EXISTS `se_wallet`; +CREATE TABLE `se_wallet` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NOT NULL COMMENT '鍐滄埛ID', + `money` float(10, 2) NULL DEFAULT 0.00 COMMENT '閽卞寘浣欓', + `last_operate` tinyint NULL DEFAULT 1 COMMENT '鏈�鍚庢搷浣�;1-寮�鎴凤紝2-鍏呭�硷紝3-娑堣垂锛�4-鐢宠閫�娆撅紝5-閫�娆惧鏍�', + `last_operate_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鏈�鍚庢搷浣滄椂闂�', + `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢靛瓙閽卞寘琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_wallet_recharge +-- ---------------------------- +DROP TABLE IF EXISTS `se_wallet_recharge`; +CREATE TABLE `se_wallet_recharge` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `wallet_id` bigint NOT NULL COMMENT '閽卞寘ID', + `client_id` bigint NOT NULL COMMENT '鍐滄埛ID', + `money` float(10, 2) NULL DEFAULT NULL COMMENT '閽卞寘浣欓', + `amount` float(10, 2) NOT NULL COMMENT '鍏呭�奸噾棰�', + `after_recharge` float(10, 2) NULL DEFAULT NULL COMMENT '鍏呭�煎悗浣欓', + `recharge_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍏呭�兼椂闂�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢靛瓙閽卞寘鍏呭�艰〃' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_water_type +-- ---------------------------- +DROP TABLE IF EXISTS `se_water_type`; +CREATE TABLE `se_water_type` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `typeName` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鐢ㄦ按绫诲瀷', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢ㄦ按绫诲瀷琛�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for se_wechatpay +-- ---------------------------- +DROP TABLE IF EXISTS `se_wechatpay`; +CREATE TABLE `se_wechatpay` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `app_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '灏忕▼搴忓敮涓�鏍囪瘑', + `app_secret` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '灏忕▼搴忕閽�', + `mch_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍟嗘埛鍙�', + `mch_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '绉橀挜key', + `serial_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'API璇佷功搴忓垪鍙�', + `notify_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏀粯缁撴灉閫氱煡url', + `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞淇℃伅', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '寰俊鏀粯淇℃伅琛�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for st_client_amount_day +-- ---------------------------- +DROP TABLE IF EXISTS `st_client_amount_day`; +CREATE TABLE `st_client_amount_day` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `month` int NULL DEFAULT NULL COMMENT '鏈堜唤', + `amount1` float(10, 2) NULL DEFAULT NULL COMMENT '1鍙风敤姘撮噺缁熻', + `money1` float(10, 2) NULL DEFAULT NULL COMMENT '1鍙疯姳璐归噾棰�', + `times1` int NULL DEFAULT NULL COMMENT '1鍙风敤姘存鏁�', + `amount2` float(10, 2) NULL DEFAULT NULL COMMENT '2鍙风敤姘撮噺缁熻', + `money2` float(10, 2) NULL DEFAULT NULL COMMENT '2鍙疯姳璐归噾棰�', + `times2` int NULL DEFAULT NULL COMMENT '2鍙风敤姘存鏁�', + `amount3` float(10, 2) NULL DEFAULT NULL COMMENT '3鍙风敤姘撮噺缁熻', + `money3` float(10, 2) NULL DEFAULT NULL COMMENT '3鍙疯姳璐归噾棰�', + `times3` int NULL DEFAULT NULL COMMENT '3鍙风敤姘存鏁�', + `amount4` float(10, 2) NULL DEFAULT NULL COMMENT '4鍙风敤姘撮噺缁熻', + `money4` float(10, 2) NULL DEFAULT NULL COMMENT '4鍙疯姳璐归噾棰�', + `times4` int NULL DEFAULT NULL COMMENT '4鍙风敤姘存鏁�', + `amount5` float(10, 2) NULL DEFAULT NULL COMMENT '5鍙风敤姘撮噺缁熻', + `money5` float(10, 2) NULL DEFAULT NULL COMMENT '5鍙疯姳璐归噾棰�', + `times5` int NULL DEFAULT NULL COMMENT '5鍙风敤姘存鏁�', + `amount6` float(10, 2) NULL DEFAULT NULL COMMENT '6鍙风敤姘撮噺缁熻', + `money6` float(10, 2) NULL DEFAULT NULL COMMENT '6鍙疯姳璐归噾棰�', + `times6` int NULL DEFAULT NULL COMMENT '6鍙风敤姘存鏁�', + `amount7` float(10, 2) NULL DEFAULT NULL COMMENT '7鍙风敤姘撮噺缁熻', + `money7` float(10, 2) NULL DEFAULT NULL COMMENT '7鍙疯姳璐归噾棰�', + `times7` int NULL DEFAULT NULL COMMENT '7鍙风敤姘存鏁�', + `amount8` float(10, 2) NULL DEFAULT NULL COMMENT '8鍙风敤姘撮噺缁熻', + `money8` float(10, 2) NULL DEFAULT NULL COMMENT '8鍙疯姳璐归噾棰�', + `times8` int NULL DEFAULT NULL COMMENT '8鍙风敤姘存鏁�', + `amount9` float(10, 2) NULL DEFAULT NULL COMMENT '9鍙风敤姘撮噺缁熻', + `money9` float(10, 2) NULL DEFAULT NULL COMMENT '9鍙疯姳璐归噾棰�', + `times9` int NULL DEFAULT NULL COMMENT '9鍙风敤姘存鏁�', + `amount10` float(10, 2) NULL DEFAULT NULL COMMENT '10鍙风敤姘撮噺缁熻', + `money10` float(10, 2) NULL DEFAULT NULL COMMENT '10鍙疯姳璐归噾棰�', + `times10` int NULL DEFAULT NULL COMMENT '10鍙风敤姘存鏁�', + `amount11` float(10, 2) NULL DEFAULT NULL COMMENT '11鍙风敤姘撮噺缁熻', + `money11` float(10, 2) NULL DEFAULT NULL COMMENT '11鍙疯姳璐归噾棰�', + `times11` int NULL DEFAULT NULL COMMENT '11鍙风敤姘存鏁�', + `amount12` float(10, 2) NULL DEFAULT NULL COMMENT '12鍙风敤姘撮噺缁熻', + `money12` float(10, 2) NULL DEFAULT NULL COMMENT '12鍙疯姳璐归噾棰�', + `times12` int NULL DEFAULT NULL COMMENT '12鍙风敤姘存鏁�', + `amount13` float(10, 2) NULL DEFAULT NULL COMMENT '13鍙风敤姘撮噺缁熻', + `money13` float(10, 2) NULL DEFAULT NULL COMMENT '13鍙疯姳璐归噾棰�', + `times13` int NULL DEFAULT NULL COMMENT '13鍙风敤姘存鏁�', + `amount14` float(10, 2) NULL DEFAULT NULL COMMENT '14鍙风敤姘撮噺缁熻', + `money14` float(10, 2) NULL DEFAULT NULL COMMENT '14鍙疯姳璐归噾棰�', + `times14` int NULL DEFAULT NULL COMMENT '14鍙风敤姘存鏁�', + `amount15` float(10, 2) NULL DEFAULT NULL COMMENT '15鍙风敤姘撮噺缁熻', + `money15` float(10, 2) NULL DEFAULT NULL COMMENT '15鍙疯姳璐归噾棰�', + `times15` int NULL DEFAULT NULL COMMENT '15鍙风敤姘存鏁�', + `amount16` float(10, 2) NULL DEFAULT NULL COMMENT '16鍙风敤姘撮噺缁熻', + `money16` float(10, 2) NULL DEFAULT NULL COMMENT '16鍙疯姳璐归噾棰�', + `times16` int NULL DEFAULT NULL COMMENT '16鍙风敤姘存鏁�', + `amount17` float(10, 2) NULL DEFAULT NULL COMMENT '17鍙风敤姘撮噺缁熻', + `money17` float(10, 2) NULL DEFAULT NULL COMMENT '17鍙疯姳璐归噾棰�', + `times17` int NULL DEFAULT NULL COMMENT '17鍙风敤姘存鏁�', + `amount18` float(10, 2) NULL DEFAULT NULL COMMENT '18鍙风敤姘撮噺缁熻', + `money18` float(10, 2) NULL DEFAULT NULL COMMENT '18鍙疯姳璐归噾棰�', + `times18` int NULL DEFAULT NULL COMMENT '18鍙风敤姘存鏁�', + `amount19` float(10, 2) NULL DEFAULT NULL COMMENT '19鍙风敤姘撮噺缁熻', + `money19` float(10, 2) NULL DEFAULT NULL COMMENT '19鍙疯姳璐归噾棰�', + `times19` int NULL DEFAULT NULL COMMENT '19鍙风敤姘存鏁�', + `amount20` float(10, 2) NULL DEFAULT NULL COMMENT '20鍙风敤姘撮噺缁熻', + `money20` float(10, 2) NULL DEFAULT NULL COMMENT '20鍙疯姳璐归噾棰�', + `times20` int NULL DEFAULT NULL COMMENT '20鍙风敤姘存鏁�', + `amount21` float(10, 2) NULL DEFAULT NULL COMMENT '21鍙风敤姘撮噺缁熻', + `money21` float(10, 2) NULL DEFAULT NULL COMMENT '21鍙疯姳璐归噾棰�', + `times21` int NULL DEFAULT NULL COMMENT '21鍙风敤姘存鏁�', + `amount22` float(10, 2) NULL DEFAULT NULL COMMENT '22鍙风敤姘撮噺缁熻', + `money22` float(10, 2) NULL DEFAULT NULL COMMENT '22鍙疯姳璐归噾棰�', + `times22` int NULL DEFAULT NULL COMMENT '22鍙风敤姘存鏁�', + `amount23` float(10, 2) NULL DEFAULT NULL COMMENT '23鍙风敤姘撮噺缁熻', + `money23` float(10, 2) NULL DEFAULT NULL COMMENT '23鍙疯姳璐归噾棰�', + `times23` int NULL DEFAULT NULL COMMENT '23鍙风敤姘存鏁�', + `amount24` float(10, 2) NULL DEFAULT NULL COMMENT '24鍙风敤姘撮噺缁熻', + `money24` float(10, 2) NULL DEFAULT NULL COMMENT '24鍙疯姳璐归噾棰�', + `times24` int NULL DEFAULT NULL COMMENT '24鍙风敤姘存鏁�', + `amount25` float(10, 2) NULL DEFAULT NULL COMMENT '25鍙风敤姘撮噺缁熻', + `money25` float(10, 2) NULL DEFAULT NULL COMMENT '25鍙疯姳璐归噾棰�', + `times25` int NULL DEFAULT NULL COMMENT '25鍙风敤姘存鏁�', + `amount26` float(10, 2) NULL DEFAULT NULL COMMENT '26鍙风敤姘撮噺缁熻', + `money26` float(10, 2) NULL DEFAULT NULL COMMENT '26鍙疯姳璐归噾棰�', + `times26` int NULL DEFAULT NULL COMMENT '26鍙风敤姘存鏁�', + `amount27` float(10, 2) NULL DEFAULT NULL COMMENT '27鍙风敤姘撮噺缁熻', + `money27` float(10, 2) NULL DEFAULT NULL COMMENT '27鍙疯姳璐归噾棰�', + `times27` int NULL DEFAULT NULL COMMENT '27鍙风敤姘存鏁�', + `amount28` float(10, 2) NULL DEFAULT NULL COMMENT '28鍙风敤姘撮噺缁熻', + `money28` float(10, 2) NULL DEFAULT NULL COMMENT '28鍙疯姳璐归噾棰�', + `times28` int NULL DEFAULT NULL COMMENT '28鍙风敤姘存鏁�', + `amount29` float(10, 2) NULL DEFAULT NULL COMMENT '29鍙风敤姘撮噺缁熻', + `money29` float(10, 2) NULL DEFAULT NULL COMMENT '29鍙疯姳璐归噾棰�', + `times29` int NULL DEFAULT NULL COMMENT '29鍙风敤姘存鏁�', + `amount30` float(10, 2) NULL DEFAULT NULL COMMENT '30鍙风敤姘撮噺缁熻', + `money30` float(10, 2) NULL DEFAULT NULL COMMENT '30鍙疯姳璐归噾棰�', + `times30` int NULL DEFAULT NULL COMMENT '30鍙风敤姘存鏁�', + `amount31` float(10, 2) NULL DEFAULT NULL COMMENT '31鍙风敤姘撮噺缁熻', + `money31` float(10, 2) NULL DEFAULT NULL COMMENT '31鍙疯姳璐归噾棰�', + `times31` int NULL DEFAULT NULL COMMENT '31鍙风敤姘存鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_client_amount_day_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛鐢ㄦ按閲忔棩缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_client_amount_month +-- ---------------------------- +DROP TABLE IF EXISTS `st_client_amount_month`; +CREATE TABLE `st_client_amount_month` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `amount1` float(10, 2) NULL DEFAULT NULL COMMENT '1鏈堢敤姘撮噺缁熻', + `money1` float(10, 2) NULL DEFAULT NULL COMMENT '1鏈堣姳璐归噾棰�', + `times1` int NULL DEFAULT NULL COMMENT '1鏈堢敤姘存鏁�', + `amount2` float(10, 2) NULL DEFAULT NULL COMMENT '2鏈堢敤姘撮噺缁熻', + `money2` float(10, 2) NULL DEFAULT NULL COMMENT '2鏈堣姳璐归噾棰�', + `times2` int NULL DEFAULT NULL COMMENT '2鏈堢敤姘存鏁�', + `amount3` float(10, 2) NULL DEFAULT NULL COMMENT '3鏈堢敤姘撮噺缁熻', + `money3` float(10, 2) NULL DEFAULT NULL COMMENT '3鏈堣姳璐归噾棰�', + `times3` int NULL DEFAULT NULL COMMENT '3鏈堢敤姘存鏁�', + `amount4` float(10, 2) NULL DEFAULT NULL COMMENT '4鏈堢敤姘撮噺缁熻', + `money4` float(10, 2) NULL DEFAULT NULL COMMENT '4鏈堣姳璐归噾棰�', + `times4` int NULL DEFAULT NULL COMMENT '4鏈堢敤姘存鏁�', + `amount5` float(10, 2) NULL DEFAULT NULL COMMENT '5鏈堢敤姘撮噺缁熻', + `money5` float(10, 2) NULL DEFAULT NULL COMMENT '5鏈堣姳璐归噾棰�', + `times5` int NULL DEFAULT NULL COMMENT '5鏈堢敤姘存鏁�', + `amount6` float(10, 2) NULL DEFAULT NULL COMMENT '6鏈堢敤姘撮噺缁熻', + `money6` float(10, 2) NULL DEFAULT NULL COMMENT '6鏈堣姳璐归噾棰�', + `times6` int NULL DEFAULT NULL COMMENT '6鏈堢敤姘存鏁�', + `amount7` float(10, 2) NULL DEFAULT NULL COMMENT '7鏈堢敤姘撮噺缁熻', + `money7` float(10, 2) NULL DEFAULT NULL COMMENT '7鏈堣姳璐归噾棰�', + `times7` int NULL DEFAULT NULL COMMENT '7鏈堢敤姘存鏁�', + `amount8` float(10, 2) NULL DEFAULT NULL COMMENT '8鏈堢敤姘撮噺缁熻', + `money8` float(10, 2) NULL DEFAULT NULL COMMENT '8鏈堣姳璐归噾棰�', + `times8` int NULL DEFAULT NULL COMMENT '8鏈堢敤姘存鏁�', + `amount9` float(10, 2) NULL DEFAULT NULL COMMENT '9鏈堢敤姘撮噺缁熻', + `money9` float(10, 2) NULL DEFAULT NULL COMMENT '9鏈堣姳璐归噾棰�', + `times9` int NULL DEFAULT NULL COMMENT '9鏈堢敤姘存鏁�', + `amount10` float(10, 2) NULL DEFAULT NULL COMMENT '10鏈堢敤姘撮噺缁熻', + `money10` float(10, 2) NULL DEFAULT NULL COMMENT '10鏈堣姳璐归噾棰�', + `times10` int NULL DEFAULT NULL COMMENT '10鏈堢敤姘存鏁�', + `amount11` float(10, 2) NULL DEFAULT NULL COMMENT '11鏈堢敤姘撮噺缁熻', + `money11` float(10, 2) NULL DEFAULT NULL COMMENT '11鏈堣姳璐归噾棰�', + `times11` int NULL DEFAULT NULL COMMENT '11鏈堢敤姘存鏁�', + `amount12` float(10, 2) NULL DEFAULT NULL COMMENT '12鏈堢敤姘撮噺缁熻', + `money12` float(10, 2) NULL DEFAULT NULL COMMENT '12鏈堣姳璐归噾棰�', + `times12` int NULL DEFAULT NULL COMMENT '12鏈堢敤姘存鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_client_amount_month_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛鐢ㄦ按閲忔湀缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_client_amount_year +-- ---------------------------- +DROP TABLE IF EXISTS `st_client_amount_year`; +CREATE TABLE `st_client_amount_year` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '骞寸敤姘撮噺缁熻', + `money` float(10, 2) NULL DEFAULT NULL COMMENT '骞磋姳璐归噾棰�', + `times` int NULL DEFAULT NULL COMMENT '骞寸敤姘存鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_client_amount_year_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛鐢ㄦ按閲忓勾缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_consume_client_day +-- ---------------------------- +DROP TABLE IF EXISTS `st_consume_client_day`; +CREATE TABLE `st_consume_client_day` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `month` int NULL DEFAULT NULL COMMENT '鏈堜唤', + `amount1` float(10, 2) NULL DEFAULT NULL COMMENT '1鍙锋秷璐圭粺璁�', + `times1` int NULL DEFAULT NULL COMMENT '1鍙锋秷璐规鏁�', + `amount2` float(10, 2) NULL DEFAULT NULL COMMENT '2鍙锋秷璐圭粺璁�', + `times2` int NULL DEFAULT NULL COMMENT '2鍙锋秷璐规鏁�', + `amount3` float(10, 2) NULL DEFAULT NULL COMMENT '3鍙锋秷璐圭粺璁�', + `times3` int NULL DEFAULT NULL COMMENT '3鍙锋秷璐规鏁�', + `amount4` float(10, 2) NULL DEFAULT NULL COMMENT '4鍙锋秷璐圭粺璁�', + `times4` int NULL DEFAULT NULL COMMENT '4鍙锋秷璐规鏁�', + `amount5` float(10, 2) NULL DEFAULT NULL COMMENT '5鍙锋秷璐圭粺璁�', + `times5` int NULL DEFAULT NULL COMMENT '5鍙锋秷璐规鏁�', + `amount6` float(10, 2) NULL DEFAULT NULL COMMENT '6鍙锋秷璐圭粺璁�', + `times6` int NULL DEFAULT NULL COMMENT '6鍙锋秷璐规鏁�', + `amount7` float(10, 2) NULL DEFAULT NULL COMMENT '7鍙锋秷璐圭粺璁�', + `times7` int NULL DEFAULT NULL COMMENT '7鍙锋秷璐规鏁�', + `amount8` float(10, 2) NULL DEFAULT NULL COMMENT '8鍙锋秷璐圭粺璁�', + `times8` int NULL DEFAULT NULL COMMENT '8鍙锋秷璐规鏁�', + `amount9` float(10, 2) NULL DEFAULT NULL COMMENT '9鍙锋秷璐圭粺璁�', + `times9` int NULL DEFAULT NULL COMMENT '9鍙锋秷璐规鏁�', + `amount10` float(10, 2) NULL DEFAULT NULL COMMENT '10鍙锋秷璐圭粺璁�', + `times10` int NULL DEFAULT NULL COMMENT '10鍙锋秷璐规鏁�', + `amount11` float(10, 2) NULL DEFAULT NULL COMMENT '11鍙锋秷璐圭粺璁�', + `times11` int NULL DEFAULT NULL COMMENT '11鍙锋秷璐规鏁�', + `amount12` float(10, 2) NULL DEFAULT NULL COMMENT '12鍙锋秷璐圭粺璁�', + `times12` int NULL DEFAULT NULL COMMENT '12鍙锋秷璐规鏁�', + `amount13` float(10, 2) NULL DEFAULT NULL COMMENT '13鍙锋秷璐圭粺璁�', + `times13` int NULL DEFAULT NULL COMMENT '13鍙锋秷璐规鏁�', + `amount14` float(10, 2) NULL DEFAULT NULL COMMENT '14鍙锋秷璐圭粺璁�', + `times14` int NULL DEFAULT NULL COMMENT '14鍙锋秷璐规鏁�', + `amount15` float(10, 2) NULL DEFAULT NULL COMMENT '15鍙锋秷璐圭粺璁�', + `times15` int NULL DEFAULT NULL COMMENT '15鍙锋秷璐规鏁�', + `amount16` float(10, 2) NULL DEFAULT NULL COMMENT '16鍙锋秷璐圭粺璁�', + `times16` int NULL DEFAULT NULL COMMENT '16鍙锋秷璐规鏁�', + `amount17` float(10, 2) NULL DEFAULT NULL COMMENT '17鍙锋秷璐圭粺璁�', + `times17` int NULL DEFAULT NULL COMMENT '17鍙锋秷璐规鏁�', + `amount18` float(10, 2) NULL DEFAULT NULL COMMENT '18鍙锋秷璐圭粺璁�', + `times18` int NULL DEFAULT NULL COMMENT '18鍙锋秷璐规鏁�', + `amount19` float(10, 2) NULL DEFAULT NULL COMMENT '19鍙锋秷璐圭粺璁�', + `times19` int NULL DEFAULT NULL COMMENT '19鍙锋秷璐规鏁�', + `amount20` float(10, 2) NULL DEFAULT NULL COMMENT '20鍙锋秷璐圭粺璁�', + `times20` int NULL DEFAULT NULL COMMENT '20鍙锋秷璐规鏁�', + `amount21` float(10, 2) NULL DEFAULT NULL COMMENT '21鍙锋秷璐圭粺璁�', + `times21` int NULL DEFAULT NULL COMMENT '21鍙锋秷璐规鏁�', + `amount22` float(10, 2) NULL DEFAULT NULL COMMENT '22鍙锋秷璐圭粺璁�', + `times22` int NULL DEFAULT NULL COMMENT '22鍙锋秷璐规鏁�', + `amount23` float(10, 2) NULL DEFAULT NULL COMMENT '23鍙锋秷璐圭粺璁�', + `times23` int NULL DEFAULT NULL COMMENT '23鍙锋秷璐规鏁�', + `amount24` float(10, 2) NULL DEFAULT NULL COMMENT '24鍙锋秷璐圭粺璁�', + `times24` int NULL DEFAULT NULL COMMENT '24鍙锋秷璐规鏁�', + `amount25` float(10, 2) NULL DEFAULT NULL COMMENT '25鍙锋秷璐圭粺璁�', + `times25` int NULL DEFAULT NULL COMMENT '25鍙锋秷璐规鏁�', + `amount26` float(10, 2) NULL DEFAULT NULL COMMENT '26鍙锋秷璐圭粺璁�', + `times26` int NULL DEFAULT NULL COMMENT '26鍙锋秷璐规鏁�', + `amount27` float(10, 2) NULL DEFAULT NULL COMMENT '27鍙锋秷璐圭粺璁�', + `times27` int NULL DEFAULT NULL COMMENT '27鍙锋秷璐规鏁�', + `amount28` float(10, 2) NULL DEFAULT NULL COMMENT '28鍙锋秷璐圭粺璁�', + `times28` int NULL DEFAULT NULL COMMENT '28鍙锋秷璐规鏁�', + `amount29` float(10, 2) NULL DEFAULT NULL COMMENT '29鍙锋秷璐圭粺璁�', + `times29` int NULL DEFAULT NULL COMMENT '29鍙锋秷璐规鏁�', + `amount30` float(10, 2) NULL DEFAULT NULL COMMENT '30鍙锋秷璐圭粺璁�', + `times30` int NULL DEFAULT NULL COMMENT '30鍙锋秷璐规鏁�', + `amount31` float(10, 2) NULL DEFAULT NULL COMMENT '31鍙锋秷璐圭粺璁�', + `times31` int NULL DEFAULT NULL COMMENT '31鍙锋秷璐规鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_consume_client_day_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛娑堣垂鏃ョ粺璁�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_consume_client_month +-- ---------------------------- +DROP TABLE IF EXISTS `st_consume_client_month`; +CREATE TABLE `st_consume_client_month` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `amount1` float(10, 2) NULL DEFAULT NULL COMMENT '1鏈堟秷璐圭粺璁�', + `times1` int NULL DEFAULT NULL COMMENT '1鏈堟秷璐规鏁�', + `amount2` float(10, 2) NULL DEFAULT NULL COMMENT '2鏈堟秷璐圭粺璁�', + `times2` int NULL DEFAULT NULL COMMENT '2鏈堟秷璐规鏁�', + `amount3` float(10, 2) NULL DEFAULT NULL COMMENT '3鏈堟秷璐圭粺璁�', + `times3` int NULL DEFAULT NULL COMMENT '3鏈堟秷璐规鏁�', + `amount4` float(10, 2) NULL DEFAULT NULL COMMENT '4鏈堟秷璐圭粺璁�', + `times4` int NULL DEFAULT NULL COMMENT '4鏈堟秷璐规鏁�', + `amount5` float(10, 2) NULL DEFAULT NULL COMMENT '5鏈堟秷璐圭粺璁�', + `times5` int NULL DEFAULT NULL COMMENT '5鏈堟秷璐规鏁�', + `amount6` float(10, 2) NULL DEFAULT NULL COMMENT '6鏈堟秷璐圭粺璁�', + `times6` int NULL DEFAULT NULL COMMENT '6鏈堟秷璐规鏁�', + `amount7` float(10, 2) NULL DEFAULT NULL COMMENT '7鏈堟秷璐圭粺璁�', + `times7` int NULL DEFAULT NULL COMMENT '7鏈堟秷璐规鏁�', + `amount8` float(10, 2) NULL DEFAULT NULL COMMENT '8鏈堟秷璐圭粺璁�', + `times8` int NULL DEFAULT NULL COMMENT '8鏈堟秷璐规鏁�', + `amount9` float(10, 2) NULL DEFAULT NULL COMMENT '9鏈堟秷璐圭粺璁�', + `times9` int NULL DEFAULT NULL COMMENT '9鏈堟秷璐规鏁�', + `amount10` float(10, 2) NULL DEFAULT NULL COMMENT '10鏈堟秷璐圭粺璁�', + `times10` int NULL DEFAULT NULL COMMENT '10鏈堟秷璐规鏁�', + `amount11` float(10, 2) NULL DEFAULT NULL COMMENT '11鏈堟秷璐圭粺璁�', + `times11` int NULL DEFAULT NULL COMMENT '11鏈堟秷璐规鏁�', + `amount12` float(10, 2) NULL DEFAULT NULL COMMENT '12鏈堟秷璐圭粺璁�', + `times12` int NULL DEFAULT NULL COMMENT '12鏈堟秷璐规鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_consume_client_month_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛娑堣垂鏈堢粺璁�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_consume_client_year +-- ---------------------------- +DROP TABLE IF EXISTS `st_consume_client_year`; +CREATE TABLE `st_consume_client_year` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '骞存秷璐圭粺璁�', + `times` int NULL DEFAULT NULL COMMENT '骞存秷璐规鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_consume_client_year_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛娑堣垂骞寸粺璁�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_consume_ic_day +-- ---------------------------- +DROP TABLE IF EXISTS `st_consume_ic_day`; +CREATE TABLE `st_consume_ic_day` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `card_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴稩C鍗�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `month` int NULL DEFAULT NULL COMMENT '鏈堜唤', + `amount1` float(10, 2) NULL DEFAULT NULL COMMENT '1鍙锋秷璐圭粺璁�', + `times1` int NULL DEFAULT NULL COMMENT '1鍙锋秷璐规鏁�', + `amount2` float(10, 2) NULL DEFAULT NULL COMMENT '2鍙锋秷璐圭粺璁�', + `times2` int NULL DEFAULT NULL COMMENT '2鍙锋秷璐规鏁�', + `amount3` float(10, 2) NULL DEFAULT NULL COMMENT '3鍙锋秷璐圭粺璁�', + `times3` int NULL DEFAULT NULL COMMENT '3鍙锋秷璐规鏁�', + `amount4` float(10, 2) NULL DEFAULT NULL COMMENT '4鍙锋秷璐圭粺璁�', + `times4` int NULL DEFAULT NULL COMMENT '4鍙锋秷璐规鏁�', + `amount5` float(10, 2) NULL DEFAULT NULL COMMENT '5鍙锋秷璐圭粺璁�', + `times5` int NULL DEFAULT NULL COMMENT '5鍙锋秷璐规鏁�', + `amount6` float(10, 2) NULL DEFAULT NULL COMMENT '6鍙锋秷璐圭粺璁�', + `times6` int NULL DEFAULT NULL COMMENT '6鍙锋秷璐规鏁�', + `amount7` float(10, 2) NULL DEFAULT NULL COMMENT '7鍙锋秷璐圭粺璁�', + `times7` int NULL DEFAULT NULL COMMENT '7鍙锋秷璐规鏁�', + `amount8` float(10, 2) NULL DEFAULT NULL COMMENT '8鍙锋秷璐圭粺璁�', + `times8` int NULL DEFAULT NULL COMMENT '8鍙锋秷璐规鏁�', + `amount9` float(10, 2) NULL DEFAULT NULL COMMENT '9鍙锋秷璐圭粺璁�', + `times9` int NULL DEFAULT NULL COMMENT '9鍙锋秷璐规鏁�', + `amount10` float(10, 2) NULL DEFAULT NULL COMMENT '10鍙锋秷璐圭粺璁�', + `times10` int NULL DEFAULT NULL COMMENT '10鍙锋秷璐规鏁�', + `amount11` float(10, 2) NULL DEFAULT NULL COMMENT '11鍙锋秷璐圭粺璁�', + `times11` int NULL DEFAULT NULL COMMENT '11鍙锋秷璐规鏁�', + `amount12` float(10, 2) NULL DEFAULT NULL COMMENT '12鍙锋秷璐圭粺璁�', + `times12` int NULL DEFAULT NULL COMMENT '12鍙锋秷璐规鏁�', + `amount13` float(10, 2) NULL DEFAULT NULL COMMENT '13鍙锋秷璐圭粺璁�', + `times13` int NULL DEFAULT NULL COMMENT '13鍙锋秷璐规鏁�', + `amount14` float(10, 2) NULL DEFAULT NULL COMMENT '14鍙锋秷璐圭粺璁�', + `times14` int NULL DEFAULT NULL COMMENT '14鍙锋秷璐规鏁�', + `amount15` float(10, 2) NULL DEFAULT NULL COMMENT '15鍙锋秷璐圭粺璁�', + `times15` int NULL DEFAULT NULL COMMENT '15鍙锋秷璐规鏁�', + `amount16` float(10, 2) NULL DEFAULT NULL COMMENT '16鍙锋秷璐圭粺璁�', + `times16` int NULL DEFAULT NULL COMMENT '16鍙锋秷璐规鏁�', + `amount17` float(10, 2) NULL DEFAULT NULL COMMENT '17鍙锋秷璐圭粺璁�', + `times17` int NULL DEFAULT NULL COMMENT '17鍙锋秷璐规鏁�', + `amount18` float(10, 2) NULL DEFAULT NULL COMMENT '18鍙锋秷璐圭粺璁�', + `times18` int NULL DEFAULT NULL COMMENT '18鍙锋秷璐规鏁�', + `amount19` float(10, 2) NULL DEFAULT NULL COMMENT '19鍙锋秷璐圭粺璁�', + `times19` int NULL DEFAULT NULL COMMENT '19鍙锋秷璐规鏁�', + `amount20` float(10, 2) NULL DEFAULT NULL COMMENT '20鍙锋秷璐圭粺璁�', + `times20` int NULL DEFAULT NULL COMMENT '20鍙锋秷璐规鏁�', + `amount21` float(10, 2) NULL DEFAULT NULL COMMENT '21鍙锋秷璐圭粺璁�', + `times21` int NULL DEFAULT NULL COMMENT '21鍙锋秷璐规鏁�', + `amount22` float(10, 2) NULL DEFAULT NULL COMMENT '22鍙锋秷璐圭粺璁�', + `times22` int NULL DEFAULT NULL COMMENT '22鍙锋秷璐规鏁�', + `amount23` float(10, 2) NULL DEFAULT NULL COMMENT '23鍙锋秷璐圭粺璁�', + `times23` int NULL DEFAULT NULL COMMENT '23鍙锋秷璐规鏁�', + `amount24` float(10, 2) NULL DEFAULT NULL COMMENT '24鍙锋秷璐圭粺璁�', + `times24` int NULL DEFAULT NULL COMMENT '24鍙锋秷璐规鏁�', + `amount25` float(10, 2) NULL DEFAULT NULL COMMENT '25鍙锋秷璐圭粺璁�', + `times25` int NULL DEFAULT NULL COMMENT '25鍙锋秷璐规鏁�', + `amount26` float(10, 2) NULL DEFAULT NULL COMMENT '26鍙锋秷璐圭粺璁�', + `times26` int NULL DEFAULT NULL COMMENT '26鍙锋秷璐规鏁�', + `amount27` float(10, 2) NULL DEFAULT NULL COMMENT '27鍙锋秷璐圭粺璁�', + `times27` int NULL DEFAULT NULL COMMENT '27鍙锋秷璐规鏁�', + `amount28` float(10, 2) NULL DEFAULT NULL COMMENT '28鍙锋秷璐圭粺璁�', + `times28` int NULL DEFAULT NULL COMMENT '28鍙锋秷璐规鏁�', + `amount29` float(10, 2) NULL DEFAULT NULL COMMENT '29鍙锋秷璐圭粺璁�', + `times29` int NULL DEFAULT NULL COMMENT '29鍙锋秷璐规鏁�', + `amount30` float(10, 2) NULL DEFAULT NULL COMMENT '30鍙锋秷璐圭粺璁�', + `times30` int NULL DEFAULT NULL COMMENT '30鍙锋秷璐规鏁�', + `amount31` float(10, 2) NULL DEFAULT NULL COMMENT '31鍙锋秷璐圭粺璁�', + `times31` int NULL DEFAULT NULL COMMENT '31鍙锋秷璐规鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_consume_ic_day_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'IC鍗℃秷璐规棩缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_consume_ic_month +-- ---------------------------- +DROP TABLE IF EXISTS `st_consume_ic_month`; +CREATE TABLE `st_consume_ic_month` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `card_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴稩C鍗�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `amount1` float(10, 2) NULL DEFAULT NULL COMMENT '1鏈堟秷璐圭粺璁�', + `times1` int NULL DEFAULT NULL COMMENT '1鏈堟秷璐规鏁�', + `amount2` float(10, 2) NULL DEFAULT NULL COMMENT '2鏈堟秷璐圭粺璁�', + `times2` int NULL DEFAULT NULL COMMENT '2鏈堟秷璐规鏁�', + `amount3` float(10, 2) NULL DEFAULT NULL COMMENT '3鏈堟秷璐圭粺璁�', + `times3` int NULL DEFAULT NULL COMMENT '3鏈堟秷璐规鏁�', + `amount4` float(10, 2) NULL DEFAULT NULL COMMENT '4鏈堟秷璐圭粺璁�', + `times4` int NULL DEFAULT NULL COMMENT '4鏈堟秷璐规鏁�', + `amount5` float(10, 2) NULL DEFAULT NULL COMMENT '5鏈堟秷璐圭粺璁�', + `times5` int NULL DEFAULT NULL COMMENT '5鏈堟秷璐规鏁�', + `amount6` float(10, 2) NULL DEFAULT NULL COMMENT '6鏈堟秷璐圭粺璁�', + `times6` int NULL DEFAULT NULL COMMENT '6鏈堟秷璐规鏁�', + `amount7` float(10, 2) NULL DEFAULT NULL COMMENT '7鏈堟秷璐圭粺璁�', + `times7` int NULL DEFAULT NULL COMMENT '7鏈堟秷璐规鏁�', + `amount8` float(10, 2) NULL DEFAULT NULL COMMENT '8鏈堟秷璐圭粺璁�', + `times8` int NULL DEFAULT NULL COMMENT '8鏈堟秷璐规鏁�', + `amount9` float(10, 2) NULL DEFAULT NULL COMMENT '9鏈堟秷璐圭粺璁�', + `times9` int NULL DEFAULT NULL COMMENT '9鏈堟秷璐规鏁�', + `amount10` float(10, 2) NULL DEFAULT NULL COMMENT '10鏈堟秷璐圭粺璁�', + `times10` int NULL DEFAULT NULL COMMENT '10鏈堟秷璐规鏁�', + `amount11` float(10, 2) NULL DEFAULT NULL COMMENT '11鏈堟秷璐圭粺璁�', + `times11` int NULL DEFAULT NULL COMMENT '11鏈堟秷璐规鏁�', + `amount12` float(10, 2) NULL DEFAULT NULL COMMENT '12鏈堟秷璐圭粺璁�', + `times12` int NULL DEFAULT NULL COMMENT '12鏈堟秷璐规鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_consume_ic_month_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'IC鍗℃秷璐规湀缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_consume_ic_year +-- ---------------------------- +DROP TABLE IF EXISTS `st_consume_ic_year`; +CREATE TABLE `st_consume_ic_year` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `card_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴稩C鍗�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '骞存秷璐圭粺璁�', + `times` int NULL DEFAULT NULL COMMENT '骞存秷璐规鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_consume_ic_year_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'IC鍗℃秷璐瑰勾缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_intake_amount_month +-- ---------------------------- +DROP TABLE IF EXISTS `st_intake_amount_month`; +CREATE TABLE `st_intake_amount_month` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙D', + `year` int NULL DEFAULT NULL COMMENT '缁熻骞村害', + `month` int NULL DEFAULT NULL COMMENT '缁熻鏈堜唤', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '鏈堝彇姘撮噺', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_intake_amount_month_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍙栨按鍙ｅ彇姘撮噺鏈堢粺璁�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_intake_amount_year +-- ---------------------------- +DROP TABLE IF EXISTS `st_intake_amount_year`; +CREATE TABLE `st_intake_amount_year` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙D', + `year` int NULL DEFAULT NULL COMMENT '缁熻骞村害', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '骞村彇姘撮噺', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_intake_amount_year_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍙栨按鍙ｅ勾鍙栨按閲忕粺璁�' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_loss_month +-- ---------------------------- +DROP TABLE IF EXISTS `st_loss_month`; +CREATE TABLE `st_loss_month` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙D', + `year` int NULL DEFAULT NULL COMMENT '缁熻骞�', + `month` int NULL DEFAULT NULL COMMENT '缁熻鏈�', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '鏈堢粺璁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_loss_month_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍙栨按鍙ｆ紡鎹熸湀缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_loss_year +-- ---------------------------- +DROP TABLE IF EXISTS `st_loss_year`; +CREATE TABLE `st_loss_year` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `intake_id` bigint NULL DEFAULT NULL COMMENT '鍙栨按鍙D', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '骞存紡鎹熺粺璁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_loss_year_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍙栨按鍙ｆ紡鎹熷勾缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_recharge_client_day +-- ---------------------------- +DROP TABLE IF EXISTS `st_recharge_client_day`; +CREATE TABLE `st_recharge_client_day` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `month` int NULL DEFAULT NULL COMMENT '鏈堜唤', + `amount1` float(10, 2) NULL DEFAULT NULL COMMENT '1鍙峰厖鍊肩粺璁�', + `gift1` float(10, 2) NULL DEFAULT NULL COMMENT '1鍙疯禒閫佺粺璁�', + `times1` int NULL DEFAULT NULL COMMENT '1鍙峰厖鍊兼鏁�', + `amount2` float(10, 2) NULL DEFAULT NULL COMMENT '2鍙峰厖鍊肩粺璁�', + `gift2` float(10, 2) NULL DEFAULT NULL COMMENT '2鍙疯禒閫佺粺璁�', + `times2` int NULL DEFAULT NULL COMMENT '2鍙峰厖鍊兼鏁�', + `amount3` float(10, 2) NULL DEFAULT NULL COMMENT '3鍙峰厖鍊肩粺璁�', + `gift3` float(10, 2) NULL DEFAULT NULL COMMENT '3鍙疯禒閫佺粺璁�', + `times3` int NULL DEFAULT NULL COMMENT '3鍙峰厖鍊兼鏁�', + `amount4` float(10, 2) NULL DEFAULT NULL COMMENT '4鍙峰厖鍊肩粺璁�', + `gift4` float(10, 2) NULL DEFAULT NULL COMMENT '4鍙疯禒閫佺粺璁�', + `times4` int NULL DEFAULT NULL COMMENT '4鍙峰厖鍊兼鏁�', + `amount5` float(10, 2) NULL DEFAULT NULL COMMENT '5鍙峰厖鍊肩粺璁�', + `gift5` float(10, 2) NULL DEFAULT NULL COMMENT '5鍙疯禒閫佺粺璁�', + `times5` int NULL DEFAULT NULL COMMENT '5鍙峰厖鍊兼鏁�', + `amount6` float(10, 2) NULL DEFAULT NULL COMMENT '6鍙峰厖鍊肩粺璁�', + `gift6` float(10, 2) NULL DEFAULT NULL COMMENT '6鍙疯禒閫佺粺璁�', + `times6` int NULL DEFAULT NULL COMMENT '6鍙峰厖鍊兼鏁�', + `amount7` float(10, 2) NULL DEFAULT NULL COMMENT '7鍙峰厖鍊肩粺璁�', + `gift7` float(10, 2) NULL DEFAULT NULL COMMENT '7鍙疯禒閫佺粺璁�', + `times7` int NULL DEFAULT NULL COMMENT '7鍙峰厖鍊兼鏁�', + `amount8` float(10, 2) NULL DEFAULT NULL COMMENT '8鍙峰厖鍊肩粺璁�', + `gift8` float(10, 2) NULL DEFAULT NULL COMMENT '8鍙疯禒閫佺粺璁�', + `times8` int NULL DEFAULT NULL COMMENT '8鍙峰厖鍊兼鏁�', + `amount9` float(10, 2) NULL DEFAULT NULL COMMENT '9鍙峰厖鍊肩粺璁�', + `gift9` float(10, 2) NULL DEFAULT NULL COMMENT '9鍙疯禒閫佺粺璁�', + `times9` int NULL DEFAULT NULL COMMENT '9鍙峰厖鍊兼鏁�', + `amount10` float(10, 2) NULL DEFAULT NULL COMMENT '10鍙峰厖鍊肩粺璁�', + `gift10` float(10, 2) NULL DEFAULT NULL COMMENT '10鍙疯禒閫佺粺璁�', + `times10` int NULL DEFAULT NULL COMMENT '10鍙峰厖鍊兼鏁�', + `amount11` float(10, 2) NULL DEFAULT NULL COMMENT '11鍙峰厖鍊肩粺璁�', + `gift11` float(10, 2) NULL DEFAULT NULL COMMENT '11鍙疯禒閫佺粺璁�', + `times11` int NULL DEFAULT NULL COMMENT '11鍙峰厖鍊兼鏁�', + `amount12` float(10, 2) NULL DEFAULT NULL COMMENT '12鍙峰厖鍊肩粺璁�', + `gift12` float(10, 2) NULL DEFAULT NULL COMMENT '12鍙疯禒閫佺粺璁�', + `times12` int NULL DEFAULT NULL COMMENT '12鍙峰厖鍊兼鏁�', + `amount13` float(10, 2) NULL DEFAULT NULL COMMENT '13鍙峰厖鍊肩粺璁�', + `gift13` float(10, 2) NULL DEFAULT NULL COMMENT '13鍙疯禒閫佺粺璁�', + `times13` int NULL DEFAULT NULL COMMENT '13鍙峰厖鍊兼鏁�', + `amount14` float(10, 2) NULL DEFAULT NULL COMMENT '14鍙峰厖鍊肩粺璁�', + `gift14` float(10, 2) NULL DEFAULT NULL COMMENT '14鍙疯禒閫佺粺璁�', + `times14` int NULL DEFAULT NULL COMMENT '14鍙峰厖鍊兼鏁�', + `amount15` float(10, 2) NULL DEFAULT NULL COMMENT '15鍙峰厖鍊肩粺璁�', + `gift15` float(10, 2) NULL DEFAULT NULL COMMENT '15鍙疯禒閫佺粺璁�', + `times15` int NULL DEFAULT NULL COMMENT '15鍙峰厖鍊兼鏁�', + `amount16` float(10, 2) NULL DEFAULT NULL COMMENT '16鍙峰厖鍊肩粺璁�', + `gift16` float(10, 2) NULL DEFAULT NULL COMMENT '16鍙疯禒閫佺粺璁�', + `times16` int NULL DEFAULT NULL COMMENT '16鍙峰厖鍊兼鏁�', + `amount17` float(10, 2) NULL DEFAULT NULL COMMENT '17鍙峰厖鍊肩粺璁�', + `gift17` float(10, 2) NULL DEFAULT NULL COMMENT '17鍙疯禒閫佺粺璁�', + `times17` int NULL DEFAULT NULL COMMENT '17鍙峰厖鍊兼鏁�', + `amount18` float(10, 2) NULL DEFAULT NULL COMMENT '18鍙峰厖鍊肩粺璁�', + `gift18` float(10, 2) NULL DEFAULT NULL COMMENT '18鍙疯禒閫佺粺璁�', + `times18` int NULL DEFAULT NULL COMMENT '18鍙峰厖鍊兼鏁�', + `amount19` float(10, 2) NULL DEFAULT NULL COMMENT '19鍙峰厖鍊肩粺璁�', + `gift19` float(10, 2) NULL DEFAULT NULL COMMENT '19鍙疯禒閫佺粺璁�', + `times19` int NULL DEFAULT NULL COMMENT '19鍙峰厖鍊兼鏁�', + `amount20` float(10, 2) NULL DEFAULT NULL COMMENT '20鍙峰厖鍊肩粺璁�', + `gift20` float(10, 2) NULL DEFAULT NULL COMMENT '20鍙疯禒閫佺粺璁�', + `times20` int NULL DEFAULT NULL COMMENT '20鍙峰厖鍊兼鏁�', + `amount21` float(10, 2) NULL DEFAULT NULL COMMENT '21鍙峰厖鍊肩粺璁�', + `gift21` float(10, 2) NULL DEFAULT NULL COMMENT '21鍙疯禒閫佺粺璁�', + `times21` int NULL DEFAULT NULL COMMENT '21鍙峰厖鍊兼鏁�', + `amount22` float(10, 2) NULL DEFAULT NULL COMMENT '22鍙峰厖鍊肩粺璁�', + `gift22` float(10, 2) NULL DEFAULT NULL COMMENT '22鍙疯禒閫佺粺璁�', + `times22` int NULL DEFAULT NULL COMMENT '22鍙峰厖鍊兼鏁�', + `amount23` float(10, 2) NULL DEFAULT NULL COMMENT '23鍙峰厖鍊肩粺璁�', + `gift23` float(10, 2) NULL DEFAULT NULL COMMENT '23鍙疯禒閫佺粺璁�', + `times23` int NULL DEFAULT NULL COMMENT '23鍙峰厖鍊兼鏁�', + `amount24` float(10, 2) NULL DEFAULT NULL COMMENT '24鍙峰厖鍊肩粺璁�', + `gift24` float(10, 2) NULL DEFAULT NULL COMMENT '24鍙疯禒閫佺粺璁�', + `times24` int NULL DEFAULT NULL COMMENT '24鍙峰厖鍊兼鏁�', + `amount25` float(10, 2) NULL DEFAULT NULL COMMENT '25鍙峰厖鍊肩粺璁�', + `gift25` float(10, 2) NULL DEFAULT NULL COMMENT '25鍙疯禒閫佺粺璁�', + `times25` int NULL DEFAULT NULL COMMENT '25鍙峰厖鍊兼鏁�', + `amount26` float(10, 2) NULL DEFAULT NULL COMMENT '26鍙峰厖鍊肩粺璁�', + `gift26` float(10, 2) NULL DEFAULT NULL COMMENT '26鍙疯禒閫佺粺璁�', + `times26` int NULL DEFAULT NULL COMMENT '26鍙峰厖鍊兼鏁�', + `amount27` float(10, 2) NULL DEFAULT NULL COMMENT '27鍙峰厖鍊肩粺璁�', + `gift27` float(10, 2) NULL DEFAULT NULL COMMENT '27鍙疯禒閫佺粺璁�', + `times27` int NULL DEFAULT NULL COMMENT '27鍙峰厖鍊兼鏁�', + `amount28` float(10, 2) NULL DEFAULT NULL COMMENT '28鍙峰厖鍊肩粺璁�', + `gift28` float(10, 2) NULL DEFAULT NULL COMMENT '28鍙疯禒閫佺粺璁�', + `times28` int NULL DEFAULT NULL COMMENT '28鍙峰厖鍊兼鏁�', + `amount29` float(10, 2) NULL DEFAULT NULL COMMENT '29鍙峰厖鍊肩粺璁�', + `gift29` float(10, 2) NULL DEFAULT NULL COMMENT '29鍙疯禒閫佺粺璁�', + `times29` int NULL DEFAULT NULL COMMENT '29鍙峰厖鍊兼鏁�', + `amount30` float(10, 2) NULL DEFAULT NULL COMMENT '30鍙峰厖鍊肩粺璁�', + `gift30` float(10, 2) NULL DEFAULT NULL COMMENT '30鍙疯禒閫佺粺璁�', + `times30` int NULL DEFAULT NULL COMMENT '30鍙峰厖鍊兼鏁�', + `amount31` float(10, 2) NULL DEFAULT NULL COMMENT '31鍙峰厖鍊肩粺璁�', + `gift31` float(10, 2) NULL DEFAULT NULL COMMENT '31鍙疯禒閫佺粺璁�', + `times31` int NULL DEFAULT NULL COMMENT '31鍙峰厖鍊兼鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_recharge_client_day_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛鍏呭�兼棩缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_recharge_client_month +-- ---------------------------- +DROP TABLE IF EXISTS `st_recharge_client_month`; +CREATE TABLE `st_recharge_client_month` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `amount1` float(10, 2) NULL DEFAULT NULL COMMENT '1鏈堝厖鍊肩粺璁�', + `gift1` float(10, 2) NULL DEFAULT NULL COMMENT '1鏈堣禒閫佺粺璁�', + `times1` int NULL DEFAULT NULL COMMENT '1鏈堝厖鍊兼鏁�', + `amount2` float(10, 2) NULL DEFAULT NULL COMMENT '2鏈堝厖鍊肩粺璁�', + `gift2` float(10, 2) NULL DEFAULT NULL COMMENT '2鏈堣禒閫佺粺璁�', + `times2` int NULL DEFAULT NULL COMMENT '2鏈堝厖鍊兼鏁�', + `amount3` float(10, 2) NULL DEFAULT NULL COMMENT '3鏈堝厖鍊肩粺璁�', + `gift3` float(10, 2) NULL DEFAULT NULL COMMENT '3鏈堣禒閫佺粺璁�', + `times3` int NULL DEFAULT NULL COMMENT '3鏈堝厖鍊兼鏁�', + `amount4` float(10, 2) NULL DEFAULT NULL COMMENT '4鏈堝厖鍊肩粺璁�', + `gift4` float(10, 2) NULL DEFAULT NULL COMMENT '4鏈堣禒閫佺粺璁�', + `times4` int NULL DEFAULT NULL COMMENT '4鏈堝厖鍊兼鏁�', + `amount5` float(10, 2) NULL DEFAULT NULL COMMENT '5鏈堝厖鍊肩粺璁�', + `gift5` float(10, 2) NULL DEFAULT NULL COMMENT '5鏈堣禒閫佺粺璁�', + `times5` int NULL DEFAULT NULL COMMENT '5鏈堝厖鍊兼鏁�', + `amount6` float(10, 2) NULL DEFAULT NULL COMMENT '6鏈堝厖鍊肩粺璁�', + `gift6` float(10, 2) NULL DEFAULT NULL COMMENT '6鏈堣禒閫佺粺璁�', + `times6` int NULL DEFAULT NULL COMMENT '6鏈堝厖鍊兼鏁�', + `amount7` float(10, 2) NULL DEFAULT NULL COMMENT '7鏈堝厖鍊肩粺璁�', + `gift7` float(10, 2) NULL DEFAULT NULL COMMENT '7鏈堣禒閫佺粺璁�', + `times7` int NULL DEFAULT NULL COMMENT '7鏈堝厖鍊兼鏁�', + `amount8` float(10, 2) NULL DEFAULT NULL COMMENT '8鏈堝厖鍊肩粺璁�', + `gift8` float(10, 2) NULL DEFAULT NULL COMMENT '8鏈堣禒閫佺粺璁�', + `times8` int NULL DEFAULT NULL COMMENT '8鏈堝厖鍊兼鏁�', + `amount9` float(10, 2) NULL DEFAULT NULL COMMENT '9鏈堝厖鍊肩粺璁�', + `gift9` float(10, 2) NULL DEFAULT NULL COMMENT '9鏈堣禒閫佺粺璁�', + `times9` int NULL DEFAULT NULL COMMENT '9鏈堝厖鍊兼鏁�', + `amount10` float(10, 2) NULL DEFAULT NULL COMMENT '10鏈堝厖鍊肩粺璁�', + `gift10` float(10, 2) NULL DEFAULT NULL COMMENT '10鏈堣禒閫佺粺璁�', + `times10` int NULL DEFAULT NULL COMMENT '10鏈堝厖鍊兼鏁�', + `amount11` float(10, 2) NULL DEFAULT NULL COMMENT '11鏈堝厖鍊肩粺璁�', + `gift11` float(10, 2) NULL DEFAULT NULL COMMENT '11鏈堣禒閫佺粺璁�', + `times11` int NULL DEFAULT NULL COMMENT '11鏈堝厖鍊兼鏁�', + `amount12` float(10, 2) NULL DEFAULT NULL COMMENT '12鏈堝厖鍊肩粺璁�', + `gift12` float(10, 2) NULL DEFAULT NULL COMMENT '12鏈堣禒閫佺粺璁�', + `times12` int NULL DEFAULT NULL COMMENT '12鏈堝厖鍊兼鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_recharge_client_month_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鍐滄埛鍏呭�兼湀缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_recharge_client_year +-- ---------------------------- +DROP TABLE IF EXISTS `st_recharge_client_year`; +CREATE TABLE `st_recharge_client_year` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '骞村厖鍊肩粺璁�', + `gift` float(10, 2) NULL DEFAULT NULL COMMENT '骞磋禒閫佺粺璁�', + `times` int NULL DEFAULT NULL COMMENT '骞村厖鍊兼鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_recharge_client_year_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'IC鍗″厖鍊兼湀缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_recharge_ic_day +-- ---------------------------- +DROP TABLE IF EXISTS `st_recharge_ic_day`; +CREATE TABLE `st_recharge_ic_day` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `card_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴稩C鍗�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `month` int NULL DEFAULT NULL COMMENT '鏈堜唤', + `amount1` float(10, 2) NULL DEFAULT NULL COMMENT '1鍙峰厖鍊肩粺璁�', + `gift1` float(10, 2) NULL DEFAULT NULL COMMENT '1鍙疯禒閫佺粺璁�', + `times1` int NULL DEFAULT NULL COMMENT '1鍙峰厖鍊兼鏁�', + `amount2` float(10, 2) NULL DEFAULT NULL COMMENT '2鍙峰厖鍊肩粺璁�', + `gift2` float(10, 2) NULL DEFAULT NULL COMMENT '2鍙疯禒閫佺粺璁�', + `times2` int NULL DEFAULT NULL COMMENT '2鍙峰厖鍊兼鏁�', + `amount3` float(10, 2) NULL DEFAULT NULL COMMENT '3鍙峰厖鍊肩粺璁�', + `gift3` float(10, 2) NULL DEFAULT NULL COMMENT '3鍙疯禒閫佺粺璁�', + `times3` int NULL DEFAULT NULL COMMENT '3鍙峰厖鍊兼鏁�', + `amount4` float(10, 2) NULL DEFAULT NULL COMMENT '4鍙峰厖鍊肩粺璁�', + `gift4` float(10, 2) NULL DEFAULT NULL COMMENT '4鍙疯禒閫佺粺璁�', + `times4` int NULL DEFAULT NULL COMMENT '4鍙峰厖鍊兼鏁�', + `amount5` float(10, 2) NULL DEFAULT NULL COMMENT '5鍙峰厖鍊肩粺璁�', + `gift5` float(10, 2) NULL DEFAULT NULL COMMENT '5鍙疯禒閫佺粺璁�', + `times5` int NULL DEFAULT NULL COMMENT '5鍙峰厖鍊兼鏁�', + `amount6` float(10, 2) NULL DEFAULT NULL COMMENT '6鍙峰厖鍊肩粺璁�', + `gift6` float(10, 2) NULL DEFAULT NULL COMMENT '6鍙疯禒閫佺粺璁�', + `times6` int NULL DEFAULT NULL COMMENT '6鍙峰厖鍊兼鏁�', + `amount7` float(10, 2) NULL DEFAULT NULL COMMENT '7鍙峰厖鍊肩粺璁�', + `gift7` float(10, 2) NULL DEFAULT NULL COMMENT '7鍙疯禒閫佺粺璁�', + `times7` int NULL DEFAULT NULL COMMENT '7鍙峰厖鍊兼鏁�', + `amount8` float(10, 2) NULL DEFAULT NULL COMMENT '8鍙峰厖鍊肩粺璁�', + `gift8` float(10, 2) NULL DEFAULT NULL COMMENT '8鍙疯禒閫佺粺璁�', + `times8` int NULL DEFAULT NULL COMMENT '8鍙峰厖鍊兼鏁�', + `amount9` float(10, 2) NULL DEFAULT NULL COMMENT '9鍙峰厖鍊肩粺璁�', + `gift9` float(10, 2) NULL DEFAULT NULL COMMENT '9鍙疯禒閫佺粺璁�', + `times9` int NULL DEFAULT NULL COMMENT '9鍙峰厖鍊兼鏁�', + `amount10` float(10, 2) NULL DEFAULT NULL COMMENT '10鍙峰厖鍊肩粺璁�', + `gift10` float(10, 2) NULL DEFAULT NULL COMMENT '10鍙疯禒閫佺粺璁�', + `times10` int NULL DEFAULT NULL COMMENT '10鍙峰厖鍊兼鏁�', + `amount11` float(10, 2) NULL DEFAULT NULL COMMENT '11鍙峰厖鍊肩粺璁�', + `gift11` float(10, 2) NULL DEFAULT NULL COMMENT '11鍙疯禒閫佺粺璁�', + `times11` int NULL DEFAULT NULL COMMENT '11鍙峰厖鍊兼鏁�', + `amount12` float(10, 2) NULL DEFAULT NULL COMMENT '12鍙峰厖鍊肩粺璁�', + `gift12` float(10, 2) NULL DEFAULT NULL COMMENT '12鍙疯禒閫佺粺璁�', + `times12` int NULL DEFAULT NULL COMMENT '12鍙峰厖鍊兼鏁�', + `amount13` float(10, 2) NULL DEFAULT NULL COMMENT '13鍙峰厖鍊肩粺璁�', + `gift13` float(10, 2) NULL DEFAULT NULL COMMENT '13鍙疯禒閫佺粺璁�', + `times13` int NULL DEFAULT NULL COMMENT '13鍙峰厖鍊兼鏁�', + `amount14` float(10, 2) NULL DEFAULT NULL COMMENT '14鍙峰厖鍊肩粺璁�', + `gift14` float(10, 2) NULL DEFAULT NULL COMMENT '14鍙疯禒閫佺粺璁�', + `times14` int NULL DEFAULT NULL COMMENT '14鍙峰厖鍊兼鏁�', + `amount15` float(10, 2) NULL DEFAULT NULL COMMENT '15鍙峰厖鍊肩粺璁�', + `gift15` float(10, 2) NULL DEFAULT NULL COMMENT '15鍙疯禒閫佺粺璁�', + `times15` int NULL DEFAULT NULL COMMENT '15鍙峰厖鍊兼鏁�', + `amount16` float(10, 2) NULL DEFAULT NULL COMMENT '16鍙峰厖鍊肩粺璁�', + `gift16` float(10, 2) NULL DEFAULT NULL COMMENT '16鍙疯禒閫佺粺璁�', + `times16` int NULL DEFAULT NULL COMMENT '16鍙峰厖鍊兼鏁�', + `amount17` float(10, 2) NULL DEFAULT NULL COMMENT '17鍙峰厖鍊肩粺璁�', + `gift17` float(10, 2) NULL DEFAULT NULL COMMENT '17鍙疯禒閫佺粺璁�', + `times17` int NULL DEFAULT NULL COMMENT '17鍙峰厖鍊兼鏁�', + `amount18` float(10, 2) NULL DEFAULT NULL COMMENT '18鍙峰厖鍊肩粺璁�', + `gift18` float(10, 2) NULL DEFAULT NULL COMMENT '18鍙疯禒閫佺粺璁�', + `times18` int NULL DEFAULT NULL COMMENT '18鍙峰厖鍊兼鏁�', + `amount19` float(10, 2) NULL DEFAULT NULL COMMENT '19鍙峰厖鍊肩粺璁�', + `gift19` float(10, 2) NULL DEFAULT NULL COMMENT '19鍙疯禒閫佺粺璁�', + `times19` int NULL DEFAULT NULL COMMENT '19鍙峰厖鍊兼鏁�', + `amount20` float(10, 2) NULL DEFAULT NULL COMMENT '20鍙峰厖鍊肩粺璁�', + `gift20` float(10, 2) NULL DEFAULT NULL COMMENT '20鍙疯禒閫佺粺璁�', + `times20` int NULL DEFAULT NULL COMMENT '20鍙峰厖鍊兼鏁�', + `amount21` float(10, 2) NULL DEFAULT NULL COMMENT '21鍙峰厖鍊肩粺璁�', + `gift21` float(10, 2) NULL DEFAULT NULL COMMENT '21鍙疯禒閫佺粺璁�', + `times21` int NULL DEFAULT NULL COMMENT '21鍙峰厖鍊兼鏁�', + `amount22` float(10, 2) NULL DEFAULT NULL COMMENT '22鍙峰厖鍊肩粺璁�', + `gift22` float(10, 2) NULL DEFAULT NULL COMMENT '22鍙疯禒閫佺粺璁�', + `times22` int NULL DEFAULT NULL COMMENT '22鍙峰厖鍊兼鏁�', + `amount23` float(10, 2) NULL DEFAULT NULL COMMENT '23鍙峰厖鍊肩粺璁�', + `gift23` float(10, 2) NULL DEFAULT NULL COMMENT '23鍙疯禒閫佺粺璁�', + `times23` int NULL DEFAULT NULL COMMENT '23鍙峰厖鍊兼鏁�', + `amount24` float(10, 2) NULL DEFAULT NULL COMMENT '24鍙峰厖鍊肩粺璁�', + `gift24` float(10, 2) NULL DEFAULT NULL COMMENT '24鍙疯禒閫佺粺璁�', + `times24` int NULL DEFAULT NULL COMMENT '24鍙峰厖鍊兼鏁�', + `amount25` float(10, 2) NULL DEFAULT NULL COMMENT '25鍙峰厖鍊肩粺璁�', + `gift25` float(10, 2) NULL DEFAULT NULL COMMENT '25鍙疯禒閫佺粺璁�', + `times25` int NULL DEFAULT NULL COMMENT '25鍙峰厖鍊兼鏁�', + `amount26` float(10, 2) NULL DEFAULT NULL COMMENT '26鍙峰厖鍊肩粺璁�', + `gift26` float(10, 2) NULL DEFAULT NULL COMMENT '26鍙疯禒閫佺粺璁�', + `times26` int NULL DEFAULT NULL COMMENT '26鍙峰厖鍊兼鏁�', + `amount27` float(10, 2) NULL DEFAULT NULL COMMENT '27鍙峰厖鍊肩粺璁�', + `gift27` float(10, 2) NULL DEFAULT NULL COMMENT '27鍙疯禒閫佺粺璁�', + `times27` int NULL DEFAULT NULL COMMENT '27鍙峰厖鍊兼鏁�', + `amount28` float(10, 2) NULL DEFAULT NULL COMMENT '28鍙峰厖鍊肩粺璁�', + `gift28` float(10, 2) NULL DEFAULT NULL COMMENT '28鍙疯禒閫佺粺璁�', + `times28` int NULL DEFAULT NULL COMMENT '28鍙峰厖鍊兼鏁�', + `amount29` float(10, 2) NULL DEFAULT NULL COMMENT '29鍙峰厖鍊肩粺璁�', + `gift29` float(10, 2) NULL DEFAULT NULL COMMENT '29鍙疯禒閫佺粺璁�', + `times29` int NULL DEFAULT NULL COMMENT '29鍙峰厖鍊兼鏁�', + `amount30` float(10, 2) NULL DEFAULT NULL COMMENT '30鍙峰厖鍊肩粺璁�', + `gift30` float(10, 2) NULL DEFAULT NULL COMMENT '30鍙疯禒閫佺粺璁�', + `times30` int NULL DEFAULT NULL COMMENT '30鍙峰厖鍊兼鏁�', + `amount31` float(10, 2) NULL DEFAULT NULL COMMENT '31鍙峰厖鍊肩粺璁�', + `gift31` float(10, 2) NULL DEFAULT NULL COMMENT '31鍙疯禒閫佺粺璁�', + `times31` int NULL DEFAULT NULL COMMENT '31鍙峰厖鍊兼鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_recharge_ic_day_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'IC鍗″厖鍊兼棩缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_recharge_ic_month +-- ---------------------------- +DROP TABLE IF EXISTS `st_recharge_ic_month`; +CREATE TABLE `st_recharge_ic_month` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `card_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴稩C鍗�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `amount1` float(10, 2) NULL DEFAULT NULL COMMENT '1鏈堝厖鍊肩粺璁�', + `gift1` float(10, 2) NULL DEFAULT NULL COMMENT '1鏈堣禒閫佺粺璁�', + `times1` int NULL DEFAULT NULL COMMENT '1鏈堝厖鍊兼鏁�', + `amount2` float(10, 2) NULL DEFAULT NULL COMMENT '2鏈堝厖鍊肩粺璁�', + `gift2` float(10, 2) NULL DEFAULT NULL COMMENT '2鏈堣禒閫佺粺璁�', + `times2` int NULL DEFAULT NULL COMMENT '2鏈堝厖鍊兼鏁�', + `amount3` float(10, 2) NULL DEFAULT NULL COMMENT '3鏈堝厖鍊肩粺璁�', + `gift3` float(10, 2) NULL DEFAULT NULL COMMENT '3鏈堣禒閫佺粺璁�', + `times3` int NULL DEFAULT NULL COMMENT '3鏈堝厖鍊兼鏁�', + `amount4` float(10, 2) NULL DEFAULT NULL COMMENT '4鏈堝厖鍊肩粺璁�', + `gift4` float(10, 2) NULL DEFAULT NULL COMMENT '4鏈堣禒閫佺粺璁�', + `times4` int NULL DEFAULT NULL COMMENT '4鏈堝厖鍊兼鏁�', + `amount5` float(10, 2) NULL DEFAULT NULL COMMENT '5鏈堝厖鍊肩粺璁�', + `gift5` float(10, 2) NULL DEFAULT NULL COMMENT '5鏈堣禒閫佺粺璁�', + `times5` int NULL DEFAULT NULL COMMENT '5鏈堝厖鍊兼鏁�', + `amount6` float(10, 2) NULL DEFAULT NULL COMMENT '6鏈堝厖鍊肩粺璁�', + `gift6` float(10, 2) NULL DEFAULT NULL COMMENT '6鏈堣禒閫佺粺璁�', + `times6` int NULL DEFAULT NULL COMMENT '6鏈堝厖鍊兼鏁�', + `amount7` float(10, 2) NULL DEFAULT NULL COMMENT '7鏈堝厖鍊肩粺璁�', + `gift7` float(10, 2) NULL DEFAULT NULL COMMENT '7鏈堣禒閫佺粺璁�', + `times7` int NULL DEFAULT NULL COMMENT '7鏈堝厖鍊兼鏁�', + `amount8` float(10, 2) NULL DEFAULT NULL COMMENT '8鏈堝厖鍊肩粺璁�', + `gift8` float(10, 2) NULL DEFAULT NULL COMMENT '8鏈堣禒閫佺粺璁�', + `times8` int NULL DEFAULT NULL COMMENT '8鏈堝厖鍊兼鏁�', + `amount9` float(10, 2) NULL DEFAULT NULL COMMENT '9鏈堝厖鍊肩粺璁�', + `gift9` float(10, 2) NULL DEFAULT NULL COMMENT '9鏈堣禒閫佺粺璁�', + `times9` int NULL DEFAULT NULL COMMENT '9鏈堝厖鍊兼鏁�', + `amount10` float(10, 2) NULL DEFAULT NULL COMMENT '10鏈堝厖鍊肩粺璁�', + `gift10` float(10, 2) NULL DEFAULT NULL COMMENT '10鏈堣禒閫佺粺璁�', + `times10` int NULL DEFAULT NULL COMMENT '10鏈堝厖鍊兼鏁�', + `amount11` float(10, 2) NULL DEFAULT NULL COMMENT '11鏈堝厖鍊肩粺璁�', + `gift11` float(10, 2) NULL DEFAULT NULL COMMENT '11鏈堣禒閫佺粺璁�', + `times11` int NULL DEFAULT NULL COMMENT '11鏈堝厖鍊兼鏁�', + `amount12` float(10, 2) NULL DEFAULT NULL COMMENT '12鏈堝厖鍊肩粺璁�', + `gift12` float(10, 2) NULL DEFAULT NULL COMMENT '12鏈堣禒閫佺粺璁�', + `times12` int NULL DEFAULT NULL COMMENT '12鏈堝厖鍊兼鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_recharge_ic_month_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'IC鍗″厖鍊兼湀缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for st_recharge_ic_year +-- ---------------------------- +DROP TABLE IF EXISTS `st_recharge_ic_year`; +CREATE TABLE `st_recharge_ic_year` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `client_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴�', + `card_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝啘鎴稩C鍗�', + `year` int NULL DEFAULT NULL COMMENT '骞村害', + `amount` float(10, 2) NULL DEFAULT NULL COMMENT '骞村厖鍊肩粺璁�', + `gift` float(10, 2) NULL DEFAULT NULL COMMENT '骞磋禒閫佺粺璁�', + `times` int NULL DEFAULT NULL COMMENT '骞村厖鍊兼鏁�', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `st_recharge_ic_year_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'IC鍗″厖鍊煎勾缁熻' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ug_rtu_controller +-- ---------------------------- +DROP TABLE IF EXISTS `ug_rtu_controller`; +CREATE TABLE `ug_rtu_controller` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `task_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝崌绾т换鍔�', + `controller_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戞帶鍒跺櫒', + `rtu_addr` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎺у埗鍣ㄥ湴鍧�', + `is_over` tinyint NULL DEFAULT NULL COMMENT '鏄惁鍗囩骇瀹屾垚(1鏄�0鍚�)', + `ug_state` int NULL DEFAULT NULL COMMENT '鍗囩骇鐘舵��', + `over_dt` timestamp NULL DEFAULT NULL COMMENT '鍗囩骇瀹屾垚鏃堕棿', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'RTU杩滅▼鍗囩骇鎵�鍏宠仈鐨勬祴鎺т竴浣撻榾' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ug_rtu_program +-- ---------------------------- +DROP TABLE IF EXISTS `ug_rtu_program`; +CREATE TABLE `ug_rtu_program` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `hex_file_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂囦欢鍚�', + `store_ram_addr` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍗囩骇绋嬪簭瀛樻斁鍦板潃(4瀛楄妭锛�8浣嶅崄鍏繘鍒跺瓧绗�)', + `start_ram_addr` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '绋嬪簭瑕嗙洊瓒呭鍦板潃锛�4瀛楄妭锛�8浣嶅崄鍏繘鍒跺瓧绗︼級', + `program_calculate_bytes` int NULL DEFAULT NULL COMMENT '鍗囩骇绋嬪簭璁＄畻瀛楄妭鏁�', + `program_crc16` int NULL DEFAULT NULL COMMENT '鍗囩骇绋嬪簭CRC16鏍￠獙鐮�', + `program_bytes` longblob NULL COMMENT '鍗囩骇绋嬪簭鍐呭锛堣В鏋愬悗绋嬪簭鏈夋晥鍐呭瀛楄妭鏁扮粍锛�', + `file_bytes` longblob NULL COMMENT '鍗囩骇绋嬪簭鏂囦欢鍐呭锛堣В鏋愬墠鐨勭▼搴忔枃浠跺唴瀹瑰瓧鑺傛暟缁勶級', + `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞', + `dt` timestamp NULL DEFAULT NULL COMMENT '涓婁紶鏃堕棿', + `deleted` tinyint NULL DEFAULT NULL COMMENT '鍒犻櫎鏍囪瘑', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'RTU杩滅▼鍗囩骇绋嬪簭' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for ug_rtu_task +-- ---------------------------- +DROP TABLE IF EXISTS `ug_rtu_task`; +CREATE TABLE `ug_rtu_task` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `program_id` bigint NULL DEFAULT NULL COMMENT '澶栭敭锛屾寚鍚戝崌绾х▼搴�', + `creator` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍒涘缓浜�', + `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞', + `dt` timestamp NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `is_execute` tinyint NULL DEFAULT NULL COMMENT '鏄惁鎵ц', + `is_over` tinyint NULL DEFAULT NULL COMMENT '鏄惁缁撴潫锛�1鏄紝0鍚︼級', + `deleted` tinyint NULL DEFAULT NULL COMMENT '鍒犻櫎鏍囪瘑', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'RTU杩滅▼鍗囩骇浠诲姟' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for web_file +-- ---------------------------- +DROP TABLE IF EXISTS `web_file`; +CREATE TABLE `web_file` ( + `id` bigint NOT NULL COMMENT '涓婚敭', + `org_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '鏂囦欢鍘熷悕绉�', + `ext_name` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '鎵╁睍鍚�', + `new_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '涓婁紶鏂囦欢鍚庣郴缁熻嚜鍔ㄧ粰鏂囦欢璧嬬殑鏂板悕绉�', + `hash` int NULL DEFAULT NULL COMMENT '鏂囦欢hash鍊�', + `file_path` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '鏂囦欢鍦ㄦ湇鍔＄瀛樺偍鐨勭浉瀵硅矾寰�', + `dt` timestamp NULL DEFAULT NULL COMMENT '鏂囦欢涓婅浇鏃ユ湡', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `oth_file_id_uindex`(`id` ASC) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '涓婅浇鐨勬枃浠朵俊鎭�' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- View structure for v_operate +-- ---------------------------- +DROP VIEW IF EXISTS `v_operate`; +CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_operate` AS select `act`.`id` AS `orderNumber`,`cli`.`villageId` AS `villageId`,`cli`.`districtTitle` AS `districtTitle`,`cli`.`clientNum` AS `clientNum`,`cli`.`name` AS `name`,`card`.`cardNum` AS `cardNum`,`cli`.`idCard` AS `idCard`,`cli`.`phone` AS `phone`,0 AS `money`,0 AS `gift`,`act`.`cardCost` AS `cardCost`,0 AS `afterRecharge`,`act`.`paymentId` AS `paymentId`,(select `se_payment_method`.`name` from `se_payment_method` where (`se_payment_method`.`id` = `act`.`paymentId`)) AS `paymentMethod`,'寮�鍗�' AS `operateType`,`act`.`operateDt` AS `operateDt`,`user`.`name` AS `operatorName` from (((`se_active_card` `act` join `se_client` `cli` on((`act`.`clientId` = `cli`.`id`))) join `se_client_card` `card` on((`act`.`cardId` = `card`.`id`))) join `ba_user` `user` on((`act`.`operator` = `user`.`id`))) union all select `rec`.`id` AS `orderNumber`,`cli`.`villageId` AS `villageId`,`cli`.`districtTitle` AS `districtTitle`,`cli`.`clientNum` AS `clientNum`,`cli`.`name` AS `name`,`card`.`cardNum` AS `cardNum`,`cli`.`idCard` AS `idCard`,`cli`.`phone` AS `phone`,`rec`.`amount` AS `money`,`rec`.`gift` AS `gift`,0 AS `cardCost`,`rec`.`afterRecharge` AS `afterRecharge`,`rec`.`paymentId` AS `paymentId`,(select `se_payment_method`.`name` from `se_payment_method` where (`se_payment_method`.`id` = `rec`.`paymentId`)) AS `paymentMethod`,'鍏呭��' AS `operateType`,`rec`.`operateDt` AS `operateDt`,`user`.`name` AS `operatorName` from (((`se_recharge_history` `rec` join `se_client` `cli` on((`rec`.`clientId` = `cli`.`id`))) join `se_client_card` `card` on((`rec`.`cardId` = `card`.`id`))) join `ba_user` `user` on((`rec`.`operator` = `user`.`id`))) union all select `can`.`id` AS `orderNumber`,`cli`.`villageId` AS `villageId`,`cli`.`districtTitle` AS `districtTitle`,`cli`.`clientNum` AS `clientNum`,`cli`.`name` AS `name`,`card`.`cardNum` AS `cardNum`,`cli`.`idCard` AS `idCard`,`cli`.`phone` AS `phone`,-(`can`.`refund`) AS `money`,0 AS `gift`,0 AS `cardCost`,0 AS `afterRecharge`,1 AS `paymentId`,(case when (`can`.`refundType` = 1) then '鐜伴噾' end) AS `paymentMethod`,'娉ㄩ攢' AS `operateType`,`can`.`operateDt` AS `operateDt`,`user`.`name` AS `operatorName` from (((`se_cancel` `can` join `se_client` `cli` on((`can`.`clientId` = `cli`.`id`))) join `se_client_card` `card` on((`can`.`cardId` = `card`.`id`))) join `ba_user` `user` on((`can`.`operator` = `user`.`id`))); + +-- ---------------------------- +-- View structure for v_trade_details +-- ---------------------------- +DROP VIEW IF EXISTS `v_trade_details`; +CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_trade_details` AS select `ope`.`id` AS `orderNumber`,`cli`.`name` AS `clientName`,`card`.`cardNum` AS `cardNum`,`cli`.`idCard` AS `idCard`,`cli`.`clientNum` AS `clientNum`,`cli`.`phone` AS `phone`,(case `ope`.`operate_type` when 1 then '寮�鍗�' when 2 then '鍏呭��' when 3 then '閿�鍗�' when 5 then '琛ユ墸' when 10 then '杩旇繕' end) AS `operateType`,(ifnull(`ope`.`trade_amount`,0.00) + ifnull(`ope`.`card_cost`,0.00)) AS `tradeAmount`,ifnull(`ope`.`trade_amount`,0.00) AS `waterCost`,ifnull(`ope`.`card_cost`,0.00) AS `cardCost`,ifnull(`ope`.`gift`,0.00) AS `gift`,ifnull(`ope`.`refund_amount`,0.00) AS `refundAmount`,`card`.`money` AS `money`,`pay`.`name` AS `paymentName`,`ope`.`operate_dt` AS `tradeTime`,`us`.`id` AS `cashierId`,`us`.`name` AS `cashierName`,(case `card`.`state` when 1 then '姝ｅ父' when 2 then '宸叉敞閿�' when 3 then '宸叉寕澶�' end) AS `cardState`,`cli`.`districtTitle` AS `districtTitle`,`cli`.`villageId` AS `villageId` from ((((`se_card_operate` `ope` left join `se_client` `cli` on((`ope`.`client_id` = `cli`.`id`))) left join `se_client_card` `card` on((`card`.`id` = `ope`.`card_id`))) left join `se_payment_method` `pay` on((`ope`.`payment_id` = `pay`.`id`))) left join `ba_user` `us` on((`ope`.`operator` = `us`.`id`))) where ((`ope`.`operate_type` in (1,2,3,5,10)) and (`ope`.`operate_valid` = 2)); + +-- ---------------------------- +-- View structure for v_trade_summary +-- ---------------------------- +DROP VIEW IF EXISTS `v_trade_summary`; +CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_trade_summary` AS select (case `ope`.`operate_type` when 1 then '寮�鍗�' when 2 then '鍏呭��' when 3 then '閿�鍗�' when 5 then '琛ユ墸' end) AS `operateType`,cast(`ope`.`operate_dt` as date) AS `tradeDate`,count(0) AS `count`,(ifnull(sum(`ope`.`trade_amount`),0) + ifnull(sum(`ope`.`card_cost`),0)) AS `received`,ifnull(sum(`ope`.`gift`),0) AS `gift`,ifnull(sum(`ope`.`refund_amount`),0) AS `refundAmount`,cast(`us`.`id` as char charset utf8mb4) AS `cashierId` from ((`se_card_operate` `ope` join `se_payment_method` `pay` on((`ope`.`payment_id` = `pay`.`id`))) join `ba_user` `us` on((`ope`.`operator` = `us`.`id`))) where (`ope`.`operate_type` in (1,2,3,5)) group by `ope`.`operate_type`,cast(`ope`.`operate_dt` as date),`us`.`id` union all select '鍏呭��' AS `operateType`,cast(`se_wallet_recharge`.`recharge_time` as date) AS `tradeDate`,count(0) AS `count`,ifnull(sum(`se_wallet_recharge`.`amount`),0) AS `received`,0 AS `gift`,0 AS `refundAmount`,cast(1000000 as char charset utf8mb4) AS `cashierId` from `se_wallet_recharge` group by cast(`se_wallet_recharge`.`recharge_time` as date) union all select '閿�鍗�' AS `operateType`,cast(`se_refund`.`audit_time` as date) AS `tradeDate`,count(0) AS `count`,ifnull(-(sum(`se_refund`.`refund_amount`)),0) AS `received`,0 AS `gift`,0 AS `refundAmount`,cast(1000000 as char charset utf8mb4) AS `cashierId` from `se_refund` where (`se_refund`.`refund_status` = 2) group by cast(`se_refund`.`audit_time` as date); + +-- ---------------------------- +-- View structure for v_transactionstatistics +-- ---------------------------- +DROP VIEW IF EXISTS `v_transactionstatistics`; +CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_transactionstatistics` AS select (case `ope`.`operate_type` when 1 then '寮�鍗�' when 2 then '鍏呭��' when 3 then '閿�鍗�' when 4 then '琛ュ崱' end) AS `operateType`,cast(`ope`.`operate_dt` as date) AS `tradeDate`,count(0) AS `count`,(ifnull(sum(`ope`.`trade_amount`),0) + ifnull(sum(`ope`.`card_cost`),0)) AS `received`,ifnull(sum(`ope`.`gift`),0) AS `gift` from (`se_card_operate` `ope` join `se_payment_method` `pay` on((`ope`.`payment_id` = `pay`.`id`))) where (`ope`.`operate_type` in (1,2,3,4)) group by `ope`.`operate_type`,cast(`ope`.`operate_dt` as date); + +SET FOREIGN_KEY_CHECKS = 1; -- Gitblit v1.8.0