contest_team_user_belongings.md

contest_team_user_belongings

Description

コンテストチームとユーザー関係テーブル

Table Definition

CREATE TABLE `contest_team_user_belongings` (
  `team_id` char(36) NOT NULL,
  `user_id` char(36) NOT NULL,
  `created_at` datetime(6) DEFAULT NULL,
  `updated_at` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`team_id`,`user_id`),
  KEY `fk_contest_team_user_belongings_user` (`user_id`),
  CONSTRAINT `fk_contest_team_user_belongings_contest_team` FOREIGN KEY (`team_id`) REFERENCES `contest_teams` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_contest_team_user_belongings_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
team_id	char(36)		false		contest_teams	コンテストチームUUID
user_id	char(36)		false		users	ユーザーUUID
created_at	datetime(6)	NULL	true			関係テーブル作成日時
updated_at	datetime(6)	NULL	true			関係テーブル更新日時

Constraints

Name	Type	Definition
fk_contest_team_user_belongings_contest_team	FOREIGN KEY	FOREIGN KEY (team_id) REFERENCES contest_teams (id)
fk_contest_team_user_belongings_user	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES users (id)
PRIMARY	PRIMARY KEY	PRIMARY KEY (team_id, user_id)

Indexes

Name	Definition
fk_contest_team_user_belongings_user	KEY fk_contest_team_user_belongings_user (user_id) USING BTREE
PRIMARY	PRIMARY KEY (team_id, user_id) USING BTREE

Relations

erDiagram

"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)"

"contest_team_user_belongings" {
  char_36_ team_id PK
  char_36_ user_id PK
  datetime_6_ created_at
  datetime_6_ updated_at
}
"contest_teams" {
  char_36_ id PK
  char_36_ contest_id FK
  varchar_128_ name
  text description
  text result
  text link
  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