diff --git a/gitbucket.erd b/gitbucket.erd new file mode 100644 index 0000000..25ae404 --- /dev/null +++ b/gitbucket.erd @@ -0,0 +1,420 @@ + + + + + + + 2 + + + + + + + + + + + 2 + + + + + + -1 + -1 + 37 + 36 + + + + + + + + + 2 + + + + + + + + + + 2 + + + + + + -1 + -1 + 463 + 37 + + + + + + + + 2 + + + + + + + + + + + 2 + + + + + + -1 + -1 + 381 + 179 + + + + + + + + PROJECT + Project + + + + PROJECT_ID + Project ID + + INT + 整数 + false + 4 + + 10 + true + true + + true + + + + PROJECT_NAME + Project Name + + VARCHAR + 文字列 + true + 12 + + 100 + true + false + + false + + + + USER_ID + User ID + + 20 + true + false + + false + + + + PROJECT_TYPE + Project Type + + INT + 整数 + false + 4 + + 10 + true + false + 0:Public 1:Private + false + 0 + + + DESCRIPTION + Description + + TEXT + 文字列 + true + 2005 + + 10 + false + false + + false + + + + REGISTERED_DATE + Registered Date + + TIMESTAMP + 日時 + false + 93 + + 10 + true + false + + false + + + + UPDATED_DATE + Updated Date + + 10 + true + false + + false + + + + LAST_ACTIVITY_DATE + Last Activity Date + + 10 + true + false + + false + + + + + + IDX_PROJECT_1 + + UNIQUE + + + PROJECT_NAME + USER_ID + + + + + 255 + 255 + 206 + + + + PROJECT_ACCOUNT_FK_1 + + + + + + + + PROJECT_ACCOUNT + Project Account + + + + PROJECT_ID + Project ID + + 10 + true + true + + false + + + + USER_ID + User ID + + 10 + true + true + + false + + + + + + 255 + 255 + 206 + + + + + PROJECT_ACCOUNT_FK_2 + + + + + + ACCOUNT + Account + + + + USER_ID + User ID + + 20 + true + true + + true + + + + USER_NAME + User Name + + VARCHAR + 文字列 + true + 12 + + 100 + true + false + + false + + + + MAIL_ADDRESS + Mail Address + + 100 + true + false + + false + + + + PASSWORD + Password + + 20 + true + false + + false + + + + USER_TYPE + User Type + + 10 + true + false + 0:Normal 1:Administrator + false + 0 + + + URL + URL + + 200 + false + false + + false + + + + REGISTERED_DATE + Registered Date + + 10 + true + false + + false + + + + UPDATED_DATE + Updated Date + + 10 + true + false + + false + + + + LAST_LOGIN_DATE + Last Login Date + + 10 + false + false + + false + + + + + + IDX_ACCOUNT_1 + + UNIQUE + + + MAIL_ADDRESS + + + + + 255 + 255 + 206 + + + + + + + + H2 + false + + sun.jdbc.odbc.JdbcOdbc + + + + + + false + + \ No newline at end of file