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/PropertyService/create_table.sql | 64 +++++++++++++++++++++++++++++---
1 files changed, 58 insertions(+), 6 deletions(-)
diff --git a/java110-config/db/PropertyService/create_table.sql b/java110-config/db/PropertyService/create_table.sql
index 8c4611a..a4b892f 100644
--- a/java110-config/db/PropertyService/create_table.sql
+++ b/java110-config/db/PropertyService/create_table.sql
@@ -120,7 +120,49 @@
property_user_id VARCHAR(30) NOT NULL COMMENT '鐗╀笟鐢ㄦ埛ID',
property_id VARCHAR(30) NOT NULL COMMENT '鐗╀笟ID',
b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',,
+ user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
+ rel_cd varchar(30) not null comment '鐢ㄦ埛鍜岀墿涓氬叧绯� 璇︽儏鏌ョ湅 property_user_rel琛�',
+ `month` INT NOT NULL COMMENT '鏈堜唤',
+ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
+);
+
+-- 鐗╀笟璐� 鍋滆溅璐�
+CREATE TABLE business_property_fee(
+ fee_id VARCHAR(30) NOT NULL COMMENT 'ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
+ property_id VARCHAR(30) NOT NULL COMMENT '鐗╀笟ID',
+ fee_type_cd VARCHAR(10) NOT NULL COMMENT '璐圭敤绫诲瀷,鐗╀笟璐癸紝鍋滆溅璐� 璇锋煡鐪媝roperty_fee_type琛�',
+ fee_money VARCHAR(20) NOT NULL COMMENT '璐圭敤閲戦',
+ fee_time VARCHAR(10) NOT NULL COMMENT '璐圭敤鍛ㄦ湡锛屼竴涓湀锛屽崐骞达紝鎴栦竴骞� 璇锋煡鐪媝roperty_fee_time琛�',
+ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ start_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '寮�濮嬫椂闂�',
+ end_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '缁撴潫鏃堕棿',
+ `month` INT NOT NULL COMMENT '鏈堜唤',
+ operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
+);
+
+CREATE TABLE business_property_house(
+ house_id VARCHAR(30) NOT NULL COMMENT 'ID',
+ property_id VARCHAR(30) NOT NULL COMMENT '鐗╀笟ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
+ house_num VARCHAR(30) NOT NULL COMMENT '闂ㄧ墝鍙�',
+ house_name VARCHAR(50) NOT NULL COMMENT '浣忔埛鍚嶇О',
+ house_phone VARCHAR(11) COMMENT '浣忔埛鑱旂郴鍙风爜',
+ house_area VARCHAR(30) NOT NULL COMMENT '鎴垮眿闈㈢Н',
+ fee_type_cd VARCHAR(10) NOT NULL COMMENT '璐圭敤绫诲瀷 property_fee_type琛�',
+ fee_price VARCHAR(30) NOT NULL COMMENT '璐圭敤鍗曚环',
+ `month` INT NOT NULL COMMENT '鏈堜唤',
+ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
+);
+
+CREATE TABLE business_property_house_attr(
+ b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
+ attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
+ house_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
+ spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�',
+ VALUE VARCHAR(50) NOT NULL COMMENT '灞炴�у��',
`month` INT NOT NULL COMMENT '鏈堜唤',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
operate VARCHAR(3) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
@@ -197,8 +239,8 @@
property_user_id VARCHAR(30) NOT NULL COMMENT '鐗╀笟鐢ㄦ埛ID',
property_id VARCHAR(30) NOT NULL COMMENT '鐗╀笟ID',
b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',,
- `month` INT NOT NULL COMMENT '鏈堜唤',
+ user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
+ rel_cd varchar(30) not null comment '鐢ㄦ埛鍜岀墿涓氬叧绯� 璇︽儏鏌ョ湅 property_user_rel琛�',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
unique KEY (property_user_id)
@@ -208,7 +250,6 @@
fee_id VARCHAR(30) NOT NULL COMMENT 'ID',
b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
property_id VARCHAR(30) NOT NULL COMMENT '鐗╀笟ID',
- user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
fee_type_cd VARCHAR(10) NOT NULL COMMENT '璐圭敤绫诲瀷,鐗╀笟璐癸紝鍋滆溅璐� 璇锋煡鐪媝roperty_fee_type琛�',
fee_money VARCHAR(20) NOT NULL COMMENT '璐圭敤閲戦',
fee_time VARCHAR(10) NOT NULL COMMENT '璐圭敤鍛ㄦ湡锛屼竴涓湀锛屽崐骞达紝鎴栦竴骞� 璇锋煡鐪媝roperty_fee_time琛�',
@@ -222,21 +263,22 @@
CREATE INDEX idx_property_fee_b_id ON p_property_fee(b_id);
CREATE TABLE p_property_house(
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
house_id VARCHAR(30) NOT NULL COMMENT 'ID',
+ property_id VARCHAR(30) NOT NULL COMMENT '鐗╀笟ID',
house_num VARCHAR(30) NOT NULL COMMENT '闂ㄧ墝鍙�',
house_name VARCHAR(50) NOT NULL COMMENT '浣忔埛鍚嶇О',
house_phone VARCHAR(11) COMMENT '浣忔埛鑱旂郴鍙风爜',
house_area VARCHAR(30) NOT NULL COMMENT '鎴垮眿闈㈢Н',
fee_type_cd VARCHAR(10) NOT NULL COMMENT '璐圭敤绫诲瀷 property_fee_type琛�',
fee_price VARCHAR(30) NOT NULL COMMENT '璐圭敤鍗曚环',
- user_id VARCHAR(10) NOT NULL COMMENT '褰曞叆浜�',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥',
UNIQUE KEY (house_id)
);
CREATE TABLE p_property_house_attr(
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
house_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�',
@@ -259,6 +301,16 @@
UNIQUE KEY (fee_type_cd)
);
+CREATE TABLE property_user_rel(
+ id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
+ rel_cd VARCHAR(12) NOT NULL COMMENT '鐗╀笟鐢ㄦ埛鍏崇郴缂栫爜',
+ `name` VARCHAR(50) NOT NULL COMMENT '鐗╀笟鐢ㄦ埛鍏崇郴缂栫爜鍚嶇О',
+ description VARCHAR(200) COMMENT '鎻忚堪',
+ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ UNIQUE KEY (rel_cd)
+);
+
+
-- 鏀惰垂鍛ㄦ湡琛�
CREATE TABLE property_fee_time(
id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
--
Gitblit v1.8.0