Database ER Diagram

CREATE TABLE `accounts_userprofile` (
`id` bigint NOT NULL,
`role` varchar(20) NOT NULL,
`user_id` int NOT NULL,
`avatar` varchar(100) DEFAULT NULL,
`about` longtext NOT NULL,
`favorite_tags` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `all_games` (
`id` int NOT NULL,
`name` varchar(255) NOT NULL,
`image` varchar(255) NOT NULL,
`category_id` int NOT NULL,
`steam_category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`steam_sub_category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`description` text,
`steam_rate` varchar(255) DEFAULT NULL,
`developer` varchar(255) DEFAULT NULL,
`publisher` varchar(255) DEFAULT NULL,
`release_date` varchar(255) DEFAULT NULL,
`features` varchar(500) DEFAULT NULL,
`controller` varchar(500) DEFAULT NULL,
`tag_ids` text,
`steam_tags` varchar(500) DEFAULT NULL,
`prices` text,
`system_requirements` text,
`steam_reviews` text,
`steam_link` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `auth_group` (
`id` int NOT NULL,
`name` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `auth_group_permissions` (
`id` bigint NOT NULL,
`group_id` int NOT NULL,
`permission_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `auth_permission` (
`id` int NOT NULL,
`name` varchar(255) NOT NULL,
`content_type_id` int NOT NULL,
`codename` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `auth_user` (
`id` int NOT NULL,
`password` varchar(128) NOT NULL,
`last_login` datetime(6) DEFAULT NULL,
`is_superuser` tinyint(1) NOT NULL,
`username` varchar(150) NOT NULL,
`first_name` varchar(150) NOT NULL,
`last_name` varchar(150) NOT NULL,
`email` varchar(254) NOT NULL,
`is_staff` tinyint(1) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`date_joined` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `auth_user_groups` (
`id` bigint NOT NULL,
`user_id` int NOT NULL,
`group_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `auth_user_user_permissions` (
`id` bigint NOT NULL,
`user_id` int NOT NULL,
`permission_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `django_admin_log` (
`id` int NOT NULL,
`action_time` datetime(6) NOT NULL,
`object_id` longtext,
`object_repr` varchar(200) NOT NULL,
`action_flag` smallint UNSIGNED NOT NULL,
`change_message` longtext NOT NULL,
`content_type_id` int DEFAULT NULL,
`user_id` int NOT NULL
) ;
CREATE TABLE `django_content_type` (
`id` int NOT NULL,
`app_label` varchar(100) NOT NULL,
`model` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `django_migrations` (
`id` bigint NOT NULL,
`app` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`applied` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `django_session` (
`session_key` varchar(40) NOT NULL,
`session_data` longtext NOT NULL,
`expire_date` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `games_categories` (
`id` int NOT NULL,
`name` varchar(50) NOT NULL,
`description` text,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `games_tags` (
`id` int NOT NULL,
`name` varchar(50) NOT NULL,
`description` text,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `message_board` (
`id` int NOT NULL,
`user_id` int NOT NULL,
`message` text NOT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `reviews_ratings` (
`id` int NOT NULL,
`user_id` int NOT NULL,
`game_id` int NOT NULL,
`rating` decimal(2,1) DEFAULT NULL,
`review_text` text,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ;
CREATE TABLE `settings_bigdata` (
`id` int NOT NULL,
`switch` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `user_game_favorites` (
`id` int NOT NULL,
`user_id` int NOT NULL,
`game_id` int NOT NULL,
`favorited_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `user_game_tags` (
`id` int NOT NULL,
`user_id` int NOT NULL,
`game_id` int NOT NULL,
`tag_ids` text,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `user_game_views` (
`id` int NOT NULL,
`user_id` int NOT NULL,
`game_id` int NOT NULL,
`viewed_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `user_search_history` (
`id` int NOT NULL,
`user_id` int NOT NULL,
`search_keyword` varchar(255) NOT NULL,
`searched_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;