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 | 38 ++++++++++++++++++++++++++++++++------ 1 files changed, 32 insertions(+), 6 deletions(-) diff --git a/java110-config/db/CommunityService/create_room.sql b/java110-config/db/CommunityService/create_room.sql index 1d39bd2..ce36434 100644 --- a/java110-config/db/CommunityService/create_room.sql +++ b/java110-config/db/CommunityService/create_room.sql @@ -74,10 +74,10 @@ room_num VARCHAR(12) NOT NULL COMMENT '鎴垮眿缂栧彿', unit_id VARCHAR(30) NOT NULL COMMENT '鍗曞厓ID', layer int NOT NULL COMMENT '灞傛暟', - section varchar(4) NOT NULL COMMENT '瀹�', + section int NOT NULL COMMENT '瀹�', apartment varchar(4) NOT NULL COMMENT '鎴峰瀷', - built_up_area varchar(4) NOT NULL COMMENT '寤虹瓚闈㈢Н', - unit_price 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 '鍒涘缓鏃堕棿', @@ -95,10 +95,10 @@ room_num VARCHAR(12) NOT NULL COMMENT '鎴垮眿缂栧彿', unit_id VARCHAR(30) NOT NULL COMMENT '鍗曞厓ID', layer int NOT NULL COMMENT '灞傛暟', - section varchar(4) NOT NULL COMMENT '瀹�', + section int NOT NULL COMMENT '瀹�', apartment varchar(4) NOT NULL COMMENT '鎴峰瀷', - built_up_area varchar(4) NOT NULL COMMENT '寤虹瓚闈㈢Н', - unit_price 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 '鍒涘缓鏃堕棿', @@ -108,3 +108,29 @@ 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