diff --git a/gitbucket.erd b/gitbucket.erd index 7b63794..74f5fb4 100644 --- a/gitbucket.erd +++ b/gitbucket.erd @@ -23,8 +23,8 @@ -1 -1 - 37 - 36 + 33 + 18 @@ -51,8 +51,8 @@ -1 -1 - 751 - 47 + 723 + 138 @@ -79,8 +79,8 @@ -1 -1 - 882 - 239 + 1182 + 339 @@ -108,8 +108,8 @@ -1 -1 - 940 - 615 + 1301 + 836 @@ -138,8 +138,8 @@ -1 -1 - 420 - 758 + 684 + 858 @@ -167,8 +167,8 @@ -1 -1 - 307 - 356 + 293 + 478 @@ -210,8 +210,8 @@ -1 -1 - 641 - 569 + 875 + 677 @@ -283,9 +283,14 @@ - MILESTONE_NAME - Milestone Name - + TITLE + Title + + VARCHAR + 文字列 + true + 12 + 100 true false @@ -293,6 +298,49 @@ false + + DESCRIPTION + Description + + TEXT + 文字列 + true + 2005 + + + false + false + + false + + + + DUE_DATE + Due Date + + TIMESTAMP + 日時 + false + 93 + + 10 + false + false + + false + + + + CLOSED_DATE + Closed Date + + 10 + false + false + + false + + @@ -350,6 +398,36 @@ + + + + + + 2 + + + + + + + ISSUE_FK_2 + + + + + ASSIGNED_USER_NAME + Assinged User Name + + 100 + false + false + + false + + + + + @@ -375,8 +453,8 @@ -1 -1 - 26 - 660 + 18 + 776 @@ -462,6 +540,22 @@ true + + ACTION + Action + + VARCHAR + 文字列 + true + 12 + + 20 + true + false + Expand to VARCHAR(20) from VARCHAR(10) in 1.3 + false + + CONTENT @@ -498,7 +592,7 @@ UPDATED_DATE Updated Date - + 10 true false @@ -572,10 +666,11 @@ false + TITLE Title - + true false @@ -586,7 +681,7 @@ CONTENT Content - + true false @@ -597,7 +692,7 @@ REGISTERED_DATE Registered Date - + 10 true false @@ -608,7 +703,7 @@ UPDATED_DATE Updated Date - + 10 true false @@ -801,8 +896,8 @@ -1 -1 - 388 - 166 + 481 + 361 @@ -862,6 +957,250 @@ + + + + + + 2 + + + + + + + + + + 2 + + + + + + -1 + -1 + 1199 + 25 + + + + + + + + + 2 + + + + + + + ACTIVITY_FK_2 + + + + + ACTIVITY_USER_NAME + Activity User Name + + 100 + true + false + + false + + + + + + + + + + ACTIVITY + Activity + Since 1.2 + + + ACTIVITY_ID + Activity ID + + INT + 整数 + false + 4 + + 10 + true + true + + true + + + + USER_NAME + User Name + + 100 + true + false + + false + + + + REPOSITORY_NAME + Repository Name + + 100 + true + false + + false + + + + + ACTIVITY_TYPE + Activity Type + + 100 + true + false + + false + + + + MESSAGE + Message + + + true + false + + false + + + + ADDITIONAL_INFO + Additional Information + + + false + false + + false + + + + ACTIVITY_DATE + Activity Date + + 10 + true + false + + false + + + + + + 255 + 255 + 206 + + + + + ACTIVITY_FK_1 + + + + + + + + 2 + + + + + + + + + + 2 + + + + + + -1 + -1 + 1451 + 577 + + + + + + + + COMMIT_LOG + Commit Log + Since 1.2 + + + USER_NAME + User Name + + 100 + true + true + + false + + + + REPOSITORY_NAME + Repository Name + + 100 + true + true + + false + + + + COMMIT_ID + Commit ID + + 40 + true + true + + false + + + + + + 255 + 255 + 206 + + + + + COMMIT_LOG_FK_1 + + @@ -1062,6 +1401,100 @@ + + + + + + + + 2 + + + + + + + + + + 2 + + + + + + -1 + -1 + 432 + 240 + + + + + + + + + 2 + + + + + + + GROUP_MEMBER_FK_2 + + + + + + + GROUP_MEMBER + Group Member + Since 1.4 + + + GROUP_NAME + Group Name + + 100 + true + true + + false + + + + USER_NAME + User Name + + 100 + true + true + + false + + + + + + 255 + 255 + 206 + + + + + GROUP_MEMBER_FK_1 + + + + + + + + @@ -1089,8 +1522,8 @@ PASSWORD Password - - 20 + + 40 true false @@ -1098,18 +1531,18 @@ - USER_TYPE - User Type + ADMINISTRATOR + Administrator - INT - 整数 + BOOLEAN + 真偽値 false - 4 + 16 10 true false - 0:Normal 1:Administrator + false 0 @@ -1157,6 +1590,33 @@ false + + IMAGE + Image + + 100 + false + false + Since 1.3 + false + + + + GROUP_ACCOUNT + Group Account + + BOOLEAN + 真偽値 + false + 16 + + 10 + true + false + Since 1.4 + false + FALSE + @@ -1184,6 +1644,91 @@ + + + + + + + + + 2 + + + + + + -1 + -1 + 410 + 860 + + + + + + ISSUE_OUTLINE_VIEW + Issue Outline View + Since 1.4 + + + USER_NAME + User Name + + 100 + false + false + + false + + + + REPOSITORY_NAME + Repository Name + + 100 + false + false + + false + + + + ISSUE_ID + Issue ID + + INT + 整数 + false + 4 + + 10 + false + false + + false + + + + COMMENT_COUNT + Comment Count + + 10 + false + false + + false + + + + + + 210 + 232 + 249 + + + H2