CREATE TABLE genre
(
    id         INTEGER not null
            primary key,
    genre_name TEXT default NULL
);
genre
CREATE TABLE game
(
    id        INTEGER not null
            primary key,
    genre_id  INTEGER          default NULL,
    game_name TEXT default NULL,
    foreign key (genre_id) references genre(id)
);
game
CREATE TABLE platform
(
    id            INTEGER not null
            primary key,
    platform_name TEXT default NULL
);
platform
CREATE TABLE publisher
(
    id             INTEGER not null
            primary key,
    publisher_name TEXT default NULL
);
publisher
CREATE TABLE game_publisher
(
    id           INTEGER not null
            primary key,
    game_id      INTEGER default NULL,
    publisher_id INTEGER default NULL,
    foreign key (game_id) references game(id),
    foreign key (publisher_id) references publisher(id)
);
game_publisher
CREATE TABLE game_platform
(
    id                INTEGER not null
            primary key,
    game_publisher_id INTEGER default NULL,
    platform_id       INTEGER default NULL,
    release_year      INTEGER default NULL,
    foreign key (game_publisher_id) references game_publisher(id),
    foreign key (platform_id) references platform(id)
);
game_platform
CREATE TABLE region
(
    id          INTEGER not null
            primary key,
    region_name TEXT default NULL
);
region
CREATE TABLE region_sales
(
    region_id        INTEGER           default NULL,
    game_platform_id INTEGER           default NULL,
    num_sales        REAL default NULL,
    foreign key (game_platform_id) references game_platform(id),
    foreign key (region_id) references region(id)
);
region_sales
original_column_name,column_name,column_description,data_format,value_description
id,,the unique identifier of the game genre,integer,
genre_name,,the game genre,text,"commonsense evidence:
The game genre can have a significant effect on the game. The genre refers to the category or type of game, such as action, adventure, strategy, or role-playing. The genre can determine the general style and gameplay of the game, as well as the expectations of the players. The genre can also affect the audience for the game, as different genres may appeal to different groups of players."
genre
original_column_name,column_name,column_description,data_format,value_description
id,,the unique identifier of the record,integer,
game_publisher_id,game publisher id,the id of the game publisher,integer,
platform_id,platform id,the id of the platform,integer,
release_year,release year,the release year of the game,integer,
game_platform
original_column_name,column_name,column_description,data_format,value_description
id,,the unique identifier of the game publisher,integer,
publisher_name,,the name of the publisher,text,"commonsense evidence:
The publisher is the company or organization that finances, produces, and distributes the game. The publisher can influence the development of the game by providing resources, guidance, and support to the game's development team. The publisher can also affect the marketing and distribution of the game, as they are responsible for promoting the game and making it available to players. "
publisher
original_column_name,column_name,column_description,data_format,value_description
id,,the unique identifier of the game platform,integer,
platform_name,,the name of the platform,text,"commonsense evidence:
The game platform, or the platform on which a game is played, can have a significant effect on the game. The platform can determine what hardware and software the game can run on, as well as the technical capabilities of the game. The platform can also affect the audience for the game, as different platforms may attract different groups of players."
platform
original_column_name,column_name,column_description,data_format,value_description
id,,the unique identifier of the game,integer,
genre_id,genre id,the id of the game genre,integer,"commonsense evidence:
If game A and game B have the same genre, the user who likes game A may also like game B. "
game_name,game name,the name of the game,text,
game
original_column_name,column_name,column_description,data_format,value_description
region_id,,the id of the region,integer,
game_platform_id,game platform id,the id of the game platform,integer,
num_sales,number sales,the number of sales in this region,real,"commonsense evidence:
The number of games sold in the region = num_sales * 100000.
The game platform with higher num_sales is more popular in the region. "
region_sales
original_column_name,column_name,column_description,data_format,value_description
id,,the unique identifier of the game publisher,integer,
game_id,game id,the id of the game,integer,
publisher_id,publisher id,the id of the publisher,integer,"commonsense evidence:
If game A and game B were published by the same publisher, the user who likes game A may also like game B if the user is a fan of the publisher company."
game_publisher
original_column_name,column_name,column_description,data_format,value_description
id,,the unique identifier of the region,integer,
region_name,,the region name,text,
region