diff --git a/gitbucket.erd b/gitbucket.erd
index 759b3cf..7b63794 100644
--- a/gitbucket.erd
+++ b/gitbucket.erd
@@ -51,8 +51,8 @@
-1
-1
- 463
- 37
+ 751
+ 47
@@ -79,71 +79,822 @@
-1
-1
- 381
- 179
+ 882
+ 239
+
+
+
+
+
+ 2
+
+
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+ -1
+ -1
+ 940
+ 615
+
+
+
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+ -1
+ -1
+ 420
+ 758
+
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+ -1
+ -1
+ 307
+ 356
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+
+ ISSUE_FK_1
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+ -1
+ -1
+ 641
+ 569
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+
+ MILESTONE_FK_1
+
+
+
+
+
+
+
+
+ MILESTONE
+ Milestone
+
+
+
+ USER_NAME
+ User Name
+
+ VARCHAR
+ 文字列
+ true
+ 12
+
+ 100
+ true
+ true
+
+ false
+
+
+
+ REPOSITORY_NAME
+ Repository Name
+
+ 100
+ true
+ true
+
+ false
+
+
+
+ MILESTONE_ID
+ Milestone ID
+
+ INT
+ 整数
+ false
+ 4
+
+ 10
+ true
+ true
+
+ true
+
+
+
+ MILESTONE_NAME
+ Milestone Name
+
+ 100
+ true
+ false
+
+ false
+
+
+
+
+
+ 255
+ 255
+ 206
+
+
+
+ ISSUE_FK_2
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+
+ ISSUE_FK_2
+
+
+
+ USER_NAME
+ User Name
+
+ VARCHAR
+ 文字列
+ true
+ 12
+
+ 100
+ true
+ true
+
+ false
+
+
+
+ OPENED_USER_NAME
+ Opened User Name
+
+ 100
+ true
+ false
+
+ false
+
+
+
+
+
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+ -1
+ -1
+ 26
+ 660
+
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+
+ ISSUE_COMMENT_FK_2
+
+
+
+
+ COMMENTED_USER_NAME
+ Commented User Name
+
+ 100
+ true
+ false
+
+ false
+
+
+
+
+
+
+
+
+
+ ISSUE_COMMENT
+ Issue Comment
+
+
+
+ USER_NAME
+ User Name
+
+ 100
+ true
+ true
+
+ false
+
+
+
+ REPOSITORY_NAME
+ Repository Name
+
+ 100
+ true
+ true
+
+ false
+
+
+
+ ISSUE_ID
+ Issue ID
+
+ 10
+ true
+ true
+
+ false
+
+
+
+ COMMENT_ID
+ Comment ID
+
+ 10
+ true
+ true
+
+ true
+
+
+
+
+ CONTENT
+ Content
+
+ TEXT
+ 文字列
+ true
+ 2005
+
+
+ true
+ false
+
+ false
+
+
+
+ REGISTERED_DATE
+ Registered Date
+
+ TIMESTAMP
+ 日時
+ false
+ 93
+
+ 10
+ true
+ false
+
+ false
+
+
+
+ UPDATED_DATE
+ Updated Date
+
+ 10
+ true
+ false
+
+ false
+
+
+
+
+
+ 255
+ 255
+ 206
+
+
+
+
+ ISSUE_COMMENT_FK_1
+
+
+
+
+
+
+ ISSUE
+ Issue
+
+
+
+ USER_NAME
+ User Name
+
+ 100
+ true
+ true
+
+ false
+
+
+
+ REPOSITORY_NAME
+ Repository Name
+
+ 100
+ true
+ true
+
+ false
+
+
+
+ ISSUE_ID
+ Issue ID
+
+ 10
+ true
+ true
+
+ false
+
+
+
+
+ MILESTONE_ID
+ Milestone ID
+
+ 10
+ false
+ false
+
+ false
+
+
+
+ TITLE
+ Title
+
+
+ true
+ false
+
+ false
+
+
+
+ CONTENT
+ Content
+
+
+ true
+ false
+
+ false
+
+
+
+ REGISTERED_DATE
+ Registered Date
+
+ 10
+ true
+ false
+
+ false
+
+
+
+ UPDATED_DATE
+ Updated Date
+
+ 10
+ true
+ false
+
+ false
+
+
+
+
+
+ 255
+ 255
+ 206
+
+
+
+ ISSUE_LABEL_FK_2
+
+
+
+
+
+
+ ISSUE_LABEL
+ Issue Label
+
+
+
+ USER_NAME
+ User Name
+
+ 100
+ true
+ true
+
+ false
+
+
+
+ REPOSITORY_NAME
+ Repository Name
+
+ 100
+ true
+ true
+
+ false
+
+
+
+ ISSUE_ID
+ Issue ID
+
+ 10
+ true
+ true
+
+ false
+
+
+
+ LABEL_ID
+ Label ID
+
+ 10
+ true
+ true
+
+ false
+
+
+
+
+
+ 255
+ 255
+ 206
+
+
+
+
+ ISSUE_LABEL_FK_1
+
+
+
+
+
+ LABEL
+ Label
+
+
+
+ USER_NAME
+ User Name
+
+ 100
+ false
+ true
+
+ false
+
+
+
+ REPOSITORY_NAME
+ Repository Name
+
+ 100
+ false
+ true
+
+ false
+
+
+
+ LABEL_ID
+ Label ID
+
+ INT
+ 整数
+ false
+ 4
+
+ 10
+ true
+ true
+
+ true
+
+
+
+ LABEL_NAME
+ Label Name
+
+ 100
+ true
+ false
+
+ false
+
+
+
+ COLOR
+ Color
+
+ CHAR
+ 文字
+ true
+ 1
+
+ 6
+ true
+ false
+
+ false
+
+
+
+
+
+ 255
+ 255
+ 206
+
+
+
+
+ LABEL_FK_1
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+
+
+
+
+ 2
+
+
+
+
+
+ -1
+ -1
+ 388
+ 166
+
+
+
+
+
+
+
+ ISSUE_ID
+ Issue ID
+
+
+
+ USER_NAME
+ User Name
+
+ 100
+ false
+ false
+
+ false
+
+
+
+ REPOSITORY_NAME
+ Repository Name
+
+ 100
+ false
+ false
+
+ false
+
+
+
+ ISSUE_ID
+ Issue ID
+
+ 10
+ true
+ false
+
+ false
+
+
+
+
+
+ 255
+ 255
+ 206
+
+
+
+
+ ISSUE_ID_FK_1
+
+
+
+
- PROJECT
- Project
+ REPOSITORY
+ Repository
- PROJECT_ID
- Project ID
-
- INT
- 整数
- false
- 4
-
- 10
+ USER_NAME
+ User Name
+
+ 100
true
true
- true
+ false
- PROJECT_NAME
- Project Name
-
- VARCHAR
- 文字列
- true
- 12
-
+ REPOSITORY_NAME
+ Repository Name
+
100
true
- false
+ true
false
- USER_ID
- User ID
-
- 20
- true
- false
-
- false
-
-
-
- PROJECT_TYPE
- Project Type
-
- INT
- 整数
- false
- 4
-
+ REPOSITORY_TYPE
+ Repository Type
+
10
true
false
@@ -202,7 +953,7 @@
UPDATED_DATE
Updated Date
-
+
10
true
false
@@ -213,7 +964,7 @@
LAST_ACTIVITY_DATE
Last Activity Date
-
+
10
true
false
@@ -242,33 +993,49 @@
PROJECT_ACCOUNT_FK_1
-
+
+
+
+
+ REPOSITORY_NAME
+ Repository Name
+
+ 100
+ true
+ true
+
+ false
+
+
+
+
- PROJECT_ACCOUNT
- Project Account
+ COLLABORATORS
+ Collaborators
- PROJECT_ID
- Project ID
-
- 10
+ USER_NAME
+ User Name
+
+ 100
true
true
false
+
- USER_ID
- User ID
-
- 10
+ COLLABORATOR_NAME
+ Collaborator Name
+
+ 100
true
true
@@ -286,8 +1053,15 @@
PROJECT_ACCOUNT_FK_2
-
+
+
+
+
+
+
+
+
@@ -295,20 +1069,10 @@
Account
+
- USER_ID
- User ID
-
- 20
- true
- true
-
- true
-
-
-
- USER_NAME
- User Name
+ MAIL_ADDRESS
+ Mail Address
VARCHAR
文字列
@@ -323,17 +1087,6 @@
- MAIL_ADDRESS
- Mail Address
-
- 100
- true
- false
-
- false
-
-
-
PASSWORD
Password
@@ -347,7 +1100,12 @@
USER_TYPE
User Type
-
+
+ INT
+ 整数
+ false
+ 4
+
10
true
false
@@ -369,7 +1127,7 @@
REGISTERED_DATE
Registered Date
-
+
10
true
false
@@ -380,7 +1138,7 @@
UPDATED_DATE
Updated Date
-
+
10
true
false
@@ -391,7 +1149,7 @@
LAST_LOGIN_DATE
Last Login Date
-
+
10
false
false
@@ -420,6 +1178,12 @@
+
+
+
+
+
+
H2