From e546f6e157e79e4074ca23f7e4e48a5c9aea4fdb Mon Sep 17 00:00:00 2001 From: wuxw <928255095@qq.com> Date: 星期四, 09 五月 2019 14:30:08 +0800 Subject: [PATCH] 房屋管理开发测试完成 --- java110-config/db/CommunityService/create_room.sql | 108 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 107 insertions(+), 1 deletions(-) diff --git a/java110-config/db/CommunityService/create_room.sql b/java110-config/db/CommunityService/create_room.sql index 92688d5..ce36434 100644 --- a/java110-config/db/CommunityService/create_room.sql +++ b/java110-config/db/CommunityService/create_room.sql @@ -27,4 +27,110 @@ UNIQUE KEY (floor_id) ); CREATE INDEX idx_floor_b_id ON f_floor(b_id); -CREATE UNIQUE INDEX idx_floor_id ON f_floor(floor_id); \ No newline at end of file +CREATE UNIQUE INDEX idx_floor_id ON f_floor(floor_id); + + +-- 鍗曞厓淇℃伅 building 妤煎畤绠＄悊 +CREATE TABLE business_building_unit( + unit_id VARCHAR(30) NOT NULL COMMENT '鍗曞厓ID', + b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id', + unit_num VARCHAR(12) NOT NULL COMMENT '鍗曞厓缂栧彿', + floor_id VARCHAR(30) NOT NULL COMMENT '妤糏D', + layer_count int NOT NULL COMMENT '鎬诲眰鏁�', + lift varchar(4) NOT NULL COMMENT '鏄惁鏈夌數姊� 1010鏈� 2020 鏃�', + user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID', + remark VARCHAR(200) NOT NULL COMMENT '澶囨敞', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + operate VARCHAR(4) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL' +); + + +CREATE INDEX idx_business_unit_id ON business_building_unit(unit_id); +CREATE INDEX idx_business_unit_b_id ON business_building_unit(b_id); + + +CREATE TABLE building_unit( + unit_id VARCHAR(30) NOT NULL COMMENT '鍗曞厓ID', + b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id', + unit_num VARCHAR(12) NOT NULL COMMENT '鍗曞厓缂栧彿', + floor_id VARCHAR(30) NOT NULL COMMENT '妤糏D', + layer_count int NOT NULL COMMENT '鎬诲眰鏁�', + lift varchar(4) NOT NULL COMMENT '鏄惁鏈夌數姊� 1010鏈� 2020 鏃�', + user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID', + remark VARCHAR(200) NOT NULL COMMENT '澶囨敞', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥', + UNIQUE KEY (unit_id) +); +CREATE INDEX idx_unit_b_id ON building_unit(b_id); +CREATE UNIQUE INDEX idx_unit_id ON building_unit(unit_id); + + + +-- 鍗曞厓淇℃伅 building 妤煎畤绠＄悊 +CREATE TABLE business_building_room( + room_id VARCHAR(30) NOT NULL COMMENT '鎴垮眿ID', + b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id', + room_num VARCHAR(12) NOT NULL COMMENT '鎴垮眿缂栧彿', + unit_id VARCHAR(30) NOT NULL COMMENT '鍗曞厓ID', + layer int NOT NULL COMMENT '灞傛暟', + section int NOT NULL COMMENT '瀹�', + apartment varchar(4) NOT NULL COMMENT '鎴峰瀷', + built_up_area decimal(6,2) NOT NULL COMMENT '寤虹瓚闈㈢Н', + unit_price DECIMAL(12,2) NOT NULL COMMENT '姣忓钩绫冲崟浠�', + user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID', + remark VARCHAR(200) NOT NULL COMMENT '澶囨敞', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + operate VARCHAR(4) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL' +); + + +CREATE INDEX idx_business_room_id ON business_building_room(room_id); +CREATE INDEX idx_business_room_b_id ON business_building_room(b_id); + + +CREATE TABLE building_room( + room_id VARCHAR(30) NOT NULL COMMENT '鎴垮眿ID', + b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id', + room_num VARCHAR(12) NOT NULL COMMENT '鎴垮眿缂栧彿', + unit_id VARCHAR(30) NOT NULL COMMENT '鍗曞厓ID', + layer int NOT NULL COMMENT '灞傛暟', + section int NOT NULL COMMENT '瀹�', + apartment varchar(4) NOT NULL COMMENT '鎴峰瀷', + built_up_area decimal(6,2) NOT NULL COMMENT '寤虹瓚闈㈢Н', + unit_price DECIMAL(12,2) NOT NULL COMMENT '姣忓钩绫冲崟浠�', + user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID', + remark VARCHAR(200) NOT NULL COMMENT '澶囨敞', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥', + UNIQUE KEY (room_id) +); +CREATE INDEX idx_room_b_id ON building_room(b_id); +CREATE UNIQUE INDEX idx_room_id ON building_room(room_id); + +create table business_building_room_attr( + b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID', + attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d', + room_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID', + spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�', + `value` VARCHAR(50) NOT NULL COMMENT '灞炴�у��', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL' +); + +CREATE INDEX idx_business_b_room_attr ON business_building_room_attr(room_id); +CREATE INDEX idx_business_b_room_attr_b_id ON business_building_room_attr(b_id); + + +CREATE TABLE building_room_attr( + b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID', + attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d', + room_id VARCHAR(30) NOT NULL COMMENT '鎴垮眿ID', + spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�', + `value` VARCHAR(50) NOT NULL COMMENT '灞炴�у��', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥', + UNIQUE KEY (attr_id) +); +CREATE INDEX idx_b_attr_b_id ON building_room_attr(b_id); +CREATE INDEX idx_attr_room_id ON building_room_attr(room_id); \ No newline at end of file -- Gitblit v1.8.0