DB

Tables

Generated By QuicktDBTeigi.

sample_bbs

Database Information

CATALOG_NAME	def
SCHEMA_NAME	sample_bbs
DEFAULT_CHARACTER_SET_NAME	utf8mb4
DEFAULT_COLLATION_NAME	utf8mb4_0900_as_ci
SQL_PATH
DEFAULT_ENCRYPTION	NO
Number of tables	4

sample_bbs > boards

Table Structure

Field	Type	Collation	Null	Key	Default	Extra	Comment
id	int unsigned		NO	PRI		auto_increment
name	varchar(255)	utf8mb4_0900_as_ci	NO
description	text	utf8mb4_0900_as_ci	NO
is_deleted	tinyint unsigned		NO	MUL	0
created_at	datetime		NO
updated_at	datetime		YES

Indexes

Non_unique	Key_name	Seq_in_index	Column_name	Collation	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Visible	Expression
0	PRIMARY	1	id	A				BTREE			YES
1	is_deleted	1	is_deleted	A				BTREE			YES

References

Column_name	Referenced_table_name	Referenced_column_name

Table Information

Name	boards
Engine	InnoDB
Version	10
Row_format	Dynamic
Collation	utf8mb4_0900_as_ci
Create_options
Comment

sample_bbs > comments

Table Structure

Field	Type	Collation	Null	Key	Default	Extra	Comment
id	int unsigned		NO	PRI		auto_increment
thread_id	int unsigned		NO	MUL
user_id	int unsigned		NO	MUL			poster
content	text	utf8mb4_0900_as_ci	NO
is_deleted	tinyint unsigned		NO	MUL	0
created_at	datetime		NO
updated_at	datetime		YES

Indexes

Non_unique	Key_name	Seq_in_index	Column_name	Collation	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Visible	Expression
0	PRIMARY	1	id	A				BTREE			YES
1	thread_id	1	thread_id	A				BTREE			YES
1	user_id	1	user_id	A				BTREE			YES
1	is_deleted	1	is_deleted	A				BTREE			YES

References

Column_name	Referenced_table_name	Referenced_column_name
thread_id	threads	id
user_id	users	id

Table Information

Name	comments
Engine	InnoDB
Version	10
Row_format	Dynamic
Collation	utf8mb4_0900_as_ci
Create_options
Comment

sample_bbs > threads

Table Structure

Field	Type	Collation	Null	Key	Default	Extra	Comment
id	int unsigned		NO	PRI		auto_increment
board_id	int unsigned		NO	MUL
user_id	int unsigned		NO	MUL			poster
title	varchar(255)	utf8mb4_0900_as_ci	NO
content	text	utf8mb4_0900_as_ci	NO
is_deleted	tinyint unsigned		NO	MUL	0
created_at	datetime		NO
updated_at	datetime		YES

Indexes

Non_unique	Key_name	Seq_in_index	Column_name	Collation	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Visible	Expression
0	PRIMARY	1	id	A				BTREE			YES
1	board_id	1	board_id	A				BTREE			YES
1	user_id	1	user_id	A				BTREE			YES
1	is_deleted	1	is_deleted	A				BTREE			YES

References

Column_name	Referenced_table_name	Referenced_column_name
board_id	boards	id
user_id	users	id

Table Information

Name	threads
Engine	InnoDB
Version	10
Row_format	Dynamic
Collation	utf8mb4_0900_as_ci
Create_options
Comment

sample_bbs > users

Table Structure

Field	Type	Collation	Null	Key	Default	Extra	Comment
id	int unsigned		NO	PRI		auto_increment
name	varchar(255)	utf8mb4_0900_as_ci	NO
email	varchar(255)	utf8mb4_0900_as_ci	NO	MUL
password	varchar(255)	utf8mb4_0900_as_ci	NO
is_deleted	tinyint unsigned		NO	MUL	0
created_at	datetime		NO
updated_at	datetime		YES

Indexes

Non_unique	Key_name	Seq_in_index	Column_name	Collation	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Visible	Expression
0	PRIMARY	1	id	A				BTREE			YES
1	email	1	email	A				BTREE			YES
1	is_deleted	1	is_deleted	A				BTREE			YES

References

Column_name	Referenced_table_name	Referenced_column_name

Table Information

Name	users
Engine	InnoDB
Version	10
Row_format	Dynamic
Collation	utf8mb4_0900_as_ci
Create_options
Comment