contests.md

contests

Description

コンテストテーブル

Table Definition

CREATE TABLE `contests` (
  `id` char(36) NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `link` text DEFAULT NULL,
  `since` datetime(6) DEFAULT NULL,
  `until` datetime(6) DEFAULT NULL,
  `created_at` datetime(6) DEFAULT NULL,
  `updated_at` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	char(36)		false	contest_teams		コンテストUUID
name	varchar(128)	NULL	true			コンテスト名
description	text	NULL	true			コンテスト説明
link	text	NULL	true			コンテスト情報のリンク
since	datetime(6)	NULL	true			期間始まり
until	datetime(6)	NULL	true			期間終わり
created_at	datetime(6)	NULL	true			コンテスト作成日時
updated_at	datetime(6)	NULL	true			コンテスト更新日時

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
PRIMARY	PRIMARY KEY (id) USING BTREE

Relations

erDiagram

"contest_teams" }o--|| "contests" : "FOREIGN KEY (contest_id) REFERENCES contests (id)"

"contests" {
  char_36_ id PK
  varchar_128_ 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_128_ name
  text description
  text result
  text link
  datetime_6_ created_at
  datetime_6_ updated_at
}

Loading

---

Generated by tbls