テーブル定義 - nnnaoki1998/spocon GitHub Wiki

team

column	datatype	default	PK	NN	UQ	FK	AI	UN
id	int		o	o			o	o
uuid	char(36)			o	o
name	varchar(255)			o
sport_id	int			o		sport.id		o
grade_id	int			o		grade.id		o
reception_status	enum(on,off)	on		o
icon_path	varchar(255)			o
description	varchar(1023)			o
address_state	varchar(255)			o
address_city	varchar(255)			o
updated_at	timestamp	current_timestamp		o
created_at	timestamp	current_timestamp		o

user

column	datatype	default	PK	NN	UQ	FK	AI	UN
id	int		o	o			o	o
name	varchar(255)			o
email	varchar(255)			o	o
team_id	int					team.id
updated_at	timestamp	current_timestamp		o
created_at	timestamp	current_timestamp		o

sport

column	datatype	default	PK	NN	UQ	FK	AI	UN
id	int		o	o			o	o
name	varchar(255)			o	o
updated_at	timestamp	current_timestamp		o
created_at	timestamp	current_timestamp		o

grade

column	datatype	default	PK	NN	UQ	FK	AI	UN
id	int		o	o			o	o
name	varchar(255)			o	o
updated_at	timestamp	current_timestamp		o
created_at	timestamp	current_timestamp		o

message

column	datatype	default	PK	NN	UQ	FK	AI	UN
id	int		o	o			o	o
send_team_id	char(36)			o		team.id
receive_team_id	char(36)			o		team.id
content	varchar(1023)			o
updated_at	timestamp	current_timestamp		o
created_at	timestamp	current_timestamp		o