Closed Yoshino-Yukitaro closed 4 months ago
4種類のアイテムに関するモデルを生成しました
docker compose build & docker compose up の後にmysqlをCLIから参照しました
docker compose build & docker compose up
mysql> show create table shoes; +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | shoes | CREATE TABLE `shoes` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `image_url` varchar(80) NOT NULL, `is_mine` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec)
mysql> show create table hairs; +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | hairs | CREATE TABLE `hairs` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `image_url` varchar(80) NOT NULL, `is_mine` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
mysql> show create table tops; +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | tops | CREATE TABLE `tops` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `image_url` varchar(80) NOT NULL, `is_mine` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec)
mysql> show create table bottoms; +---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | bottoms | CREATE TABLE `bottoms` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `image_url` varchar(80) NOT NULL, `is_mine` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | +---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec)
レビューありがとうございます!マージしちゃいます!
概要
4種類のアイテムに関するモデルを生成しました
検証
docker compose build & docker compose up
の後にmysqlをCLIから参照しましたshoes
hairs
tops
bottoms