Skip to content

Latest commit

 

History

History

dbschema

README.md

portfolio

Tables

Name Columns Comment Type
accounts 8 Twitterなどのアカウントテーブル BASE TABLE
contests 8 コンテストテーブル BASE TABLE
contest_teams 8 コンテスト参加チームテーブル BASE TABLE
contest_team_user_belongings 4 コンテストチームとユーザー関係テーブル BASE TABLE
event_level_relations 4 knoQイベントと公開レベルの関係テーブル BASE TABLE
groups 6 グループテーブル BASE TABLE
group_user_admins 4 グループと管理者関係テーブル BASE TABLE
group_user_belongings 8 グループとユーザー関係テーブル BASE TABLE
migrations 1 gormigrate用のデータベースバージョンテーブル BASE TABLE
projects 10 プロジェクトテーブル BASE TABLE
project_members 9 プロジェクト所属者テーブル BASE TABLE
users 7 ユーザーテーブル BASE TABLE

Relations

erDiagram

"accounts" }o--|| "users" : "FOREIGN KEY (user_id) REFERENCES users (id)"
"contest_teams" }o--|| "contests" : "FOREIGN KEY (contest_id) REFERENCES contests (id)"
"contest_team_user_belongings" }o--|| "contest_teams" : "FOREIGN KEY (team_id) REFERENCES contest_teams (id)"
"contest_team_user_belongings" }o--|| "users" : "FOREIGN KEY (user_id) REFERENCES users (id)"
"group_user_admins" }o--|| "groups" : "FOREIGN KEY (group_id) REFERENCES groups (group_id)"
"group_user_belongings" }o--|| "groups" : "FOREIGN KEY (group_id) REFERENCES groups (group_id)"
"group_user_belongings" }o--|| "users" : "FOREIGN KEY (user_id) REFERENCES users (id)"
"project_members" }o--|| "projects" : "FOREIGN KEY (project_id) REFERENCES projects (id)"
"project_members" }o--|| "users" : "FOREIGN KEY (user_id) REFERENCES users (id)"

"accounts" {
  char_36_ id PK
  tinyint_1_ type
  varchar_256_ name
  text url
  char_36_ user_id FK
  tinyint_1_ check
  datetime_6_ created_at
  datetime_6_ updated_at
}
"contests" {
  char_36_ id PK
  varchar_32_ name
  text description
  text link
  datetime_6_ since
  datetime_6_ until
  datetime_6_ created_at
  datetime_6_ updated_at
}
"contest_teams" {
  char_36_ id PK
  char_36_ contest_id FK
  varchar_32_ name
  text description
  text result
  text link
  datetime_6_ created_at
  datetime_6_ updated_at
}
"contest_team_user_belongings" {
  char_36_ team_id PK
  char_36_ user_id PK
  datetime_6_ created_at
  datetime_6_ updated_at
}
"event_level_relations" {
  char_36_ id PK
  tinyint_3__unsigned level
  datetime_6_ created_at
  datetime_6_ updated_at
}
"groups" {
  char_36_ group_id PK
  varchar_32_ name
  text link
  text description
  datetime_6_ created_at
  datetime_6_ updated_at
}
"group_user_admins" {
  char_36_ user_id PK
  char_36_ group_id PK
  datetime_6_ created_at
  datetime_6_ updated_at
}
"group_user_belongings" {
  char_36_ user_id PK
  char_36_ group_id PK
  smallint_4_ since_year
  tinyint_1_ since_semester
  smallint_4_ until_year
  tinyint_1_ until_semester
  datetime_6_ created_at
  datetime_6_ updated_at
}
"migrations" {
  varchar_255_ id PK
}
"projects" {
  char_36_ id PK
  varchar_32_ name
  text description
  text link
  smallint_4_ since_year
  tinyint_1_ since_semester
  smallint_4_ until_year
  tinyint_1_ until_semester
  datetime_6_ created_at
  datetime_6_ updated_at
}
"project_members" {
  char_36_ id PK
  char_36_ project_id FK
  char_36_ user_id FK
  smallint_4_ since_year
  tinyint_1_ since_semester
  smallint_4_ until_year
  tinyint_1_ until_semester
  datetime_6_ created_at
  datetime_6_ updated_at
}
"users" {
  char_36_ id PK
  text description
  tinyint_1_ check
  varchar_32_ name
  tinyint_1_ state
  datetime_6_ created_at
  datetime_6_ updated_at
}
Loading

Generated by tbls