zB951RnL

1CREATE TABLE IF NOT EXISTS `game_review`.`game` (
2  `game_general_id` VARCHAR(8) AS (concat(game_code, game_id)),
3  `game_code` VARCHAR(1) NOT NULL,
4  `game_id` INT(7) NOT NULL,
5  `game_title` VARCHAR(128) NOT NULL,
6  `game_description` VARCHAR(255) NULL,
7  `developer_general_id` VARCHAR(8) NOT NULL,
8  `publisher_general_id` VARCHAR(8) NOT NULL,
9  `genre_general_id` VARCHAR(4) NOT NULL,
10  `platform_general_id` VARCHAR(4) NOT NULL,
11  `platform_general_id2` VARCHAR(4) NOT NULL,
12  `game_release` DATE NULL,
13  `game_upload` DATE NOT NULL,
14  `game_rating` INT NULL,
15  `game_price` VARCHAR(24) NULL,
16  `game_size` VARCHAR(24) NULL,
17  `game_thumbnail` VARCHAR(255) NULL,
18  `game_poster` VARCHAR(255) NULL,
19  `game_image1` VARCHAR(255) NULL,
20  `game_image2` VARCHAR(255) NULL,
21  `game_image3` VARCHAR(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NULL,
22  `game_video1` VARCHAR(255) NULL,
23  `game_video2` VARCHAR(255) NULL,
24  `user_general_id` VARCHAR(8) NOT NULL,
25  CONSTRAINT game_general_id PRIMARY KEY (`game_code`, `game_id`),
26  INDEX `developer_general_id_idx` (`developer_general_id` ASC),
27  INDEX `genre_general_id_idx` (`genre_general_id` ASC),
28  INDEX `platform_general_id_idx` (`platform_general_id` ASC),
29  INDEX `user_general_id_idx` (`user_general_id` ASC),
30  INDEX `publisher_general_id_idx` (`publisher_general_id` ASC),
31  INDEX `platform_general_id2_idx` (`platform_general_id2` ASC),
32  CONSTRAINT `developer_general_idfk`
33    FOREIGN KEY (`developer_general_id`)
34    REFERENCES game_review.developer (developer_code, developer_id)
35    ON DELETE NO ACTION
36    ON UPDATE NO ACTION,
37  CONSTRAINT `genre_general_idfk`
38    FOREIGN KEY (`genre_general_id`)
39    REFERENCES `game_review`.`genre` (`genre_general_id`)
40    ON DELETE NO ACTION
41    ON UPDATE NO ACTION,
42  CONSTRAINT `platform_general_idfk`
43    FOREIGN KEY (`platform_general_id`)
44    REFERENCES `game_review`.`platform` (`platform_general_id`)
45    ON DELETE NO ACTION
46    ON UPDATE NO ACTION,
47  CONSTRAINT `user_general_idfk`
48    FOREIGN KEY (`user_general_id`)
49    REFERENCES `game_review`.`user` (`user_general_id`)
50    ON DELETE NO ACTION
51    ON UPDATE NO ACTION,
52  CONSTRAINT `publisher_general_idfk`
53    FOREIGN KEY (`publisher_general_id`)
54    REFERENCES `game_review`.`publisher` (`publisher_general_id`)
55    ON DELETE NO ACTION
56    ON UPDATE NO ACTION,
57  CONSTRAINT `platform_general_idfk2`
58    FOREIGN KEY (`platform_general_id2`)
59    REFERENCES `game_review`.`platform` (`platform_general_id`)
60    ON DELETE NO ACTION
61    ON UPDATE NO ACTION)
62ENGINE = InnoDB;