groups.md

groups

Description

グループテーブル

Table Definition

CREATE TABLE `groups` (
  `group_id` char(36) NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `link` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` datetime(6) DEFAULT NULL,
  `updated_at` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
group_id	char(36)		false	group_user_admins group_user_belongings		グループUUID
name	varchar(32)	NULL	true			グループ名
link	text	NULL	true			グループのリンク
description	text	NULL	true			グループの説明文
created_at	datetime(6)	NULL	true			グループ作成日時
updated_at	datetime(6)	NULL	true			グループ更新日時

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (group_id)

Indexes

Name	Definition
PRIMARY	PRIMARY KEY (group_id) USING BTREE

Relations

erDiagram

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

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

Loading

---

Generated by tbls