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/UserService/create_table.db | 79 ++++++++++++++++++++++++++-------------
1 files changed, 52 insertions(+), 27 deletions(-)
diff --git a/java110-config/db/UserService/create_table.db b/java110-config/db/UserService/create_table.db
index 633f48a..568f96b 100644
--- a/java110-config/db/UserService/create_table.db
+++ b/java110-config/db/UserService/create_table.db
@@ -2,8 +2,8 @@
create table business_user(
id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- b_id VARCHAR(18) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(12) NOT NULL COMMENT '鐢ㄦ埛ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
+ user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
name VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
email VARCHAR(30) COMMENT '閭鍦板潃',
address VARCHAR(200) COMMENT '鐜板眳浣忓湴鍧�',
@@ -41,9 +41,9 @@
-- business_user_attr
CREATE TABLE business_user_attr(
- b_id VARCHAR(18) NOT NULL COMMENT '璁㈠崟ID',
- attr_id VARCHAR(18) NOT NULL COMMENT '灞炴�d',
- user_id VARCHAR(12) NOT NULL COMMENT '鐢ㄦ埛ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '璁㈠崟ID',
+ attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
+ user_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 '鍒涘缓鏃堕棿',
@@ -53,7 +53,7 @@
-- u_user
create table u_user(
id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- user_id VARCHAR(12) NOT NULL UNIQUE COMMENT '鐢ㄦ埛ID',
+ user_id VARCHAR(30) NOT NULL UNIQUE COMMENT '鐢ㄦ埛ID',
name VARCHAR(50) NOT NULL COMMENT '鍚嶇О',
email VARCHAR(30) COMMENT '閭鍦板潃',
address VARCHAR(200) COMMENT '鐜板眳浣忓湴鍧�',
@@ -63,7 +63,7 @@
sex varchar(1) comment '鎬у埆锛�0琛ㄧず鐢峰 1琛ㄧず濂冲',
tel varchar(11) comment '鐢ㄦ埛鎵嬫満',
level_cd varchar(2) not null default '0' comment '鐢ㄦ埛绾у埆,鍏宠仈user_level',
- b_id VARCHAR(18) NOT NULL COMMENT '涓氬姟Id',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥'
);
@@ -73,19 +73,19 @@
CREATE TABLE u_user_attr(
id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- attr_id VARCHAR(18) NOT NULL COMMENT '灞炴�d',
- user_id VARCHAR(12) NOT NULL COMMENT '鐢ㄦ埛ID',
+ attr_id VARCHAR(30) NOT NULL COMMENT '灞炴�d',
+ user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
spec_cd VARCHAR(12) NOT NULL COMMENT '瑙勬牸id,鍙傝�僺pec琛�',
value VARCHAR(50) NOT NULL COMMENT '灞炴�у��',
- b_id VARCHAR(18) NOT NULL COMMENT '涓氬姟ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟ID',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0鍦ㄧ敤锛�1澶辨晥'
);
-- 鐢ㄦ埛 鐗╂祦鍦板潃
create table business_user_address(
- address_id VARCHAR(18) NOT NULL COMMENT '鍦板潃ID',
- b_id VARCHAR(18) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(12) NOT NULL COMMENT '鐢ㄦ埛ID',
+ address_id VARCHAR(30) NOT NULL COMMENT '鍦板潃ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
+ user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
tel varchar(11) not null comment '鐢佃瘽',
postal_code varchar(10) not null comment '閭斂缂栫爜',
address varchar(200) not null comment '鍦板潃',
@@ -97,9 +97,9 @@
-- u_user_address
create table u_user_address(
id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
- address_id VARCHAR(18) NOT NULL COMMENT '鍦板潃ID',
- b_id VARCHAR(18) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(12) NOT NULL COMMENT '鐢ㄦ埛ID',
+ address_id VARCHAR(30) NOT NULL COMMENT '鍦板潃ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
+ user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
tel varchar(11) not null comment '鐢佃瘽',
postal_code varchar(10) not null comment '閭斂缂栫爜',
address varchar(200) not null comment '鍦板潃',
@@ -109,9 +109,9 @@
);
-- 鐢ㄦ埛鏍囩
create table business_user_tag(
- id VARCHAR(12) NOT NULL COMMENT 'Id',
- b_id VARCHAR(18) NOT NULL COMMENT '涓氬姟Id',
- user_id VARCHAR(12) NOT NULL COMMENT '鐢ㄦ埛ID',
+ tag_id VARCHAR(30) NOT NULL COMMENT '鎵撴爣ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
+ user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
tag_cd VARCHAR(12) NOT NULL COMMENT '鏍囩缂栫爜,鍙傝�僼ag琛�',
remark VARCHAR(200) COMMENT '澶囨敞',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
@@ -121,11 +121,11 @@
-- 鐢ㄦ埛鏍囩
create table u_user_tag(
- id VARCHAR(12) NOT NULL COMMENT 'Id',
- user_id VARCHAR(12) NOT NULL COMMENT '鐢ㄦ埛ID',
+ id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
+ tag_id VARCHAR(30) NOT NULL COMMENT '鎵撴爣ID',
+ user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
tag_cd VARCHAR(12) NOT NULL COMMENT '鏍囩缂栫爜,鍙傝�僼ag琛�',
- b_id VARCHAR(18) NOT NULL COMMENT '涓氬姟Id',
- tag_count int not null default 1 comment '鎵撴爣鏁伴噺',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
remark VARCHAR(200) COMMENT '澶囨敞',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
status_cd VARCHAR(2) NOT NULL default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0鍦ㄧ敤锛�1澶辨晥'
@@ -140,10 +140,35 @@
description VARCHAR(200) COMMENT '鎻忚堪',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿'
);
-
--- 绠＄悊鍛樿〃
-create business_manage(
-
+-- 鐢ㄦ埛璇佷欢 琛紙杩囩▼琛級
+create table business_user_credentials(
+ credentials_id VARCHAR(30) NOT NULL COMMENT '璇佷欢ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
+ user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
+ credentials_cd varchar(12) not null comment '璇佷欢绫诲瀷',
+ 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 table u_user_credentials(
+ id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
+ credentials_id VARCHAR(30) NOT NULL COMMENT '璇佷欢ID',
+ b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id',
+ user_id VARCHAR(30) NOT NULL COMMENT '鐢ㄦ埛ID',
+ credentials_cd varchar(12) not null comment '璇佷欢绫诲瀷',
+ 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澶辨晥'
+);
+
+-- 鏍囩
+create table credentials(
+ id INT NOT NULL AUTO_INCREMENT KEY COMMENT 'id',
+ credentials_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 '鍒涘缓鏃堕棿'
+);
\ No newline at end of file
--
Gitblit v1.8.0