CREATE TABLE Batting_Style
(
    Batting_Id   INTEGER
            primary key,
    Batting_hand TEXT
);
Batting_Style
CREATE TABLE Bowling_Style
(
    Bowling_Id    INTEGER
            primary key,
    Bowling_skill TEXT
);
Bowling_Style
CREATE TABLE City
(
    City_Id    INTEGER
            primary key,
    City_Name  TEXT,
    Country_id INTEGER
);
City
CREATE TABLE Country
(
    Country_Id   INTEGER
            primary key,
    Country_Name TEXT,
    foreign key (Country_Id) references Country(Country_Id)
);
Country
CREATE TABLE Extra_Type
(
    Extra_Id   INTEGER
            primary key,
    Extra_Name TEXT
);
Extra_Type
CREATE TABLE Extra_Runs
(
    Match_Id      INTEGER,
    Over_Id       INTEGER,
    Ball_Id       INTEGER,
    Extra_Type_Id INTEGER,
    Extra_Runs    INTEGER,
    Innings_No    INTEGER,
    primary key (Match_Id, Over_Id, Ball_Id, Innings_No),
    foreign key (Extra_Type_Id) references Extra_Type(Extra_Id)
);
Extra_Runs
CREATE TABLE Out_Type
(
    Out_Id   INTEGER
            primary key,
    Out_Name TEXT
);
Out_Type
CREATE TABLE Outcome
(
    Outcome_Id   INTEGER
            primary key,
    Outcome_Type TEXT
);
Outcome
CREATE TABLE Player
(
    Player_Id     INTEGER
            primary key,
    Player_Name   TEXT,
    DOB           DATE,
    Batting_hand  INTEGER,
    Bowling_skill INTEGER,
    Country_Name  INTEGER,
    foreign key (Batting_hand) references Batting_Style(Batting_Id),
    foreign key (Bowling_skill) references Bowling_Style(Bowling_Id),
    foreign key (Country_Name) references Country(Country_Id)
);
Player
CREATE TABLE Rolee
(
    Role_Id   INTEGER
            primary key,
    Role_Desc TEXT
);
Rolee
CREATE TABLE Season
(
    Season_Id         INTEGER
            primary key,
    Man_of_the_Series INTEGER,
    Orange_Cap        INTEGER,
    Purple_Cap        INTEGER,
    Season_Year       INTEGER
);
Season
CREATE TABLE Team
(
    Team_Id   INTEGER
            primary key,
    Team_Name TEXT
);
Team
CREATE TABLE Toss_Decision
(
    Toss_Id   INTEGER
            primary key,
    Toss_Name TEXT
);
Toss_Decision
CREATE TABLE Umpire
(
    Umpire_Id      INTEGER
            primary key,
    Umpire_Name    TEXT,
    Umpire_Country INTEGER,
    foreign key (Umpire_Country) references Country(Country_Id)
);
Umpire
CREATE TABLE Venue
(
    Venue_Id   INTEGER
            primary key,
    Venue_Name TEXT,
    City_Id    INTEGER,
    foreign key (City_Id) references City(City_Id)
);
Venue
CREATE TABLE Win_By
(
    Win_Id   INTEGER
            primary key,
    Win_Type TEXT
);
Win_By
CREATE TABLE Match
(
    Match_Id         INTEGER
            primary key,
    Team_1           INTEGER,
    Team_2           INTEGER,
    Match_Date       DATE,
    Season_Id        INTEGER,
    Venue_Id         INTEGER,
    Toss_Winner      INTEGER,
    Toss_Decide      INTEGER,
    Win_Type         INTEGER,
    Win_Margin       INTEGER,
    Outcome_type     INTEGER,
    Match_Winner     INTEGER,
    Man_of_the_Match INTEGER,
    foreign key (Team_1) references Team(Team_Id),
    foreign key (Team_2) references Team(Team_Id),
    foreign key (Season_Id) references Season(Season_Id),
    foreign key (Venue_Id) references Venue(Venue_Id),
    foreign key (Toss_Winner) references Team(Team_Id),
    foreign key (Toss_Decide) references Toss_Decision(Toss_Id),
    foreign key (Win_Type) references Win_By(Win_Id),
    foreign key (Outcome_type) references Out_Type(Out_Id),
    foreign key (Match_Winner) references Team(Team_Id),
    foreign key (Man_of_the_Match) references Player(Player_Id)
);
Match
CREATE TABLE Ball_by_Ball
(
    Match_Id                 INTEGER,
    Over_Id                  INTEGER,
    Ball_Id                  INTEGER,
    Innings_No               INTEGER,
    Team_Batting             INTEGER,
    Team_Bowling             INTEGER,
    Striker_Batting_Position INTEGER,
    Striker                  INTEGER,
    Non_Striker              INTEGER,
    Bowler                   INTEGER,
    primary key (Match_Id, Over_Id, Ball_Id, Innings_No),
    foreign key (Match_Id) references Match(Match_Id)
);
Ball_by_Ball
CREATE TABLE Batsman_Scored
(
    Match_Id    INTEGER,
    Over_Id     INTEGER,
    Ball_Id     INTEGER,
    Runs_Scored INTEGER,
    Innings_No  INTEGER,
    primary key (Match_Id, Over_Id, Ball_Id, Innings_No),
    foreign key (Match_Id) references Match(Match_Id)
);
Batsman_Scored
CREATE TABLE Player_Match
(
    Match_Id  INTEGER,
    Player_Id INTEGER,
    Role_Id   INTEGER,
    Team_Id   INTEGER,
    primary key (Match_Id, Player_Id, Role_Id),
    foreign key (Match_Id) references Match(Match_Id),
    foreign key (Player_Id) references Player(Player_Id),
    foreign key (Team_Id) references Team(Team_Id),
    foreign key (Role_Id) references Rolee(Role_Id)
);
Player_Match
CREATE TABLE Wicket_Taken
(
    Match_Id   INTEGER,
    Over_Id    INTEGER,
    Ball_Id    INTEGER,
    Player_Out INTEGER,
    Kind_Out   INTEGER,
    Fielders   INTEGER,
    Innings_No INTEGER,
    primary key (Match_Id, Over_Id, Ball_Id, Innings_No),
    foreign key (Match_Id) references Match(Match_Id),
    foreign key (Player_Out) references Player(Player_Id),
    foreign key (Kind_Out) references Out_Type(Out_Id),
    foreign key (Fielders) references Player(Player_Id)
);
Wicket_Taken
original_column_name,column_name,column_description,data_format,value_description
Match_Id,,unique id for match,integer,
Team_1,team 1,the team id of the first team,integer,
Team_2,team 2,the team id for the second team,integer,
Match_Date,match date,the date of the match,date,yyyy-mm-dd
Season_Id,season id,the id of the season,integer,
Venue_Id,venue id,the id of the venue where the match held,integer,
Toss_Winner,toss winner,the id of the toss winner,integer,"commonsense evidence:
The toss winner is a term used in cricket and is the team that wins the heads or tails toss of coin at the beginning of a match which then enables the team captain to decide whether to bat or bowl first on the pitch."
Toss_Decide,toss decide,the decision (batting or bowling) made after winning the toss,integer,"â¢ field 
â¢ bat"
Win_Type,winning type,the id of the winning type ,integer,
Win_Margin,winning margin,the points of the winning margin,integer,"commonsense evidence:
A winning margin bet is a wager on the final result of a game, within a certain range of points."
Outcome_type,outcome type,the id of the outcome type,integer,
Match_Winner,match winner,the team id of the match winner,integer,
Man_of_the_Match,man of the match,the id of the man of the match,integer,"commonsense evidence:
In team sport, a player of the match or man (or woman) of the match award is often given to the outstanding player in a particular match."
Match
original_column_name,column_name,column_description,data_format,value_description
Match_Id,match id,unique id for match,integer,
Player_Id,player id,the id of the player,integer,
Role_Id,role id,the id of the play's role in the match,integer,"commonsense evidence:
if a player has multiple roles in a match, it means this player is versatile"
Team_Id,team id,the id of player's team,integer,
Player_Match
original_column_name,column_name,column_description,data_format,value_description
Toss_Id,toss id,the unique id for the toss,integer,
Toss_Name,toss name,the toss decision name,text,
Toss_Decision
original_column_name,column_name,column_description,data_format,value_description
Match_Id,match id,Unique Number Which Identifies a match,integer,
Over_Id,over id,Unique Number which Identifies an over in an Innings,integer,
Ball_Id,ball id,Unique Number which Identifies a ball in an over,integer,
Runs_Scored,runs scored,Number of Runs scored by the batsman,integer,
Innings_No,innings number,Unique Number which Identifies an innings in a match,integer,
Batsman_Scored
original_column_name,column_name,column_description,data_format,value_description
Umpire_Id,umpire id,the unique id of the umpire,integer,
Umpire_Name,umpire name,umpire's name,text,
Umpire_Country,umpire country,the id of the country where the umpire are from,integer,
Umpire
original_column_name,column_name,column_description,data_format,value_description
Country_Id,country id,unique id for country,integer,
Country_Name,country name,country name,text,
Country
original_column_name,column_name,column_description,data_format,value_description
Season_Id,season id,the unique id for season,integer,
Man_of_the_Series,man of the series,the player id of man of the series,integer,"commonsense evidence:
In team sport, a player of the series or man (or woman) of the series award is often given to the outstanding player in a particular series."
Orange_Cap,orange cap,the player id who wins the orange cap,integer,"commonsense evidence:
The Orange Cap is a coveted award for a batter who is participating in the Indian Premier League (IPL)"
Purple_Cap,purple cap,the player id who wins the purple cap,integer,"commonsense evidence:
The Purple Cap is awarded to the bowler who has emerged as the leading wicket-taker in a particular edition of the high-profile Indian Premier League (IPL)"
Season_Year,season year,the year of the season,integer,
Season
original_column_name,column_name,column_description,data_format,value_description
Venue_Id,venue id,the unique id of the venue,integer,
Venue_Name,venue name,the name of the venue,text,
City_Id,city id,the city id where the venue is located in ,integer,
Venue
original_column_name,column_name,column_description,data_format,value_description
Bowling_Id,bowling id,unique id for bowling style,integer,
Bowling_skill,bowling skill,the bowling skill,text,
Bowling_Style
original_column_name,column_name,column_description,data_format,value_description
City_Id,city id,unique id for city,integer,
City_Name,city name,city name,text,
Country_id,country id,id of country,integer,
City
original_column_name,column_name,column_description,data_format,value_description
Out_Id,out id,unique id for out type,integer,
Out_Name,out name,out type name,text,
Out_Type
original_column_name,column_name,column_description,data_format,value_description
Match_Id,match id,the id of the match,integer,
Over_Id,over id,the id of the over in an inning,integer,
Ball_Id,ball id,the id of the ball in an over,integer,
Player_Out,player out,the player id who got an out,integer,
Kind_Out,kind out,the id that represents the out type,integer,
Fielders ,,the id of fielders,integer,
Innings_No,innings number ,number which identifies an innings in a match,integer,
Wicket_Taken
original_column_name,column_name,column_description,data_format,value_description
Team_Id,team id,the unique id for the team,integer,
Team_Name,team name,the team name ,text,
Team
original_column_name,column_name,column_description,data_format,value_description
Outcome_Id,outcome id,unique id for outcome,integer,
Outcome_Type,outcome type,type of the outcome,text,
Outcome
original_column_name,column_name,column_description,data_format,value_description
Win_Id,winning id,the unique id for the winning,integer,
Win_Type,winning type,the winning type,text,
Win_By
original_column_name,column_name,column_description,data_format,value_description
Batting_Id,batting id,unique id for batting hand,integer,
Batting_hand,batting hand,the batting hand: left or right,text,
Batting_Style
original_column_name,column_name,column_description,data_format,value_description
Extra_Id,extra id,unique id for extra type,integer,
Extra_Name,extra name,extra type name,text,
Extra_Type
original_column_name,column_name,column_description,data_format,value_description
Player_Id,player id,the id of the player,integer,
Player_Name,player name,the name of the player,text,
DOB,date of birth,player's birthday,date,yyyy-mm-dd
Batting_hand,batting hand,the id of the batting hand,integer,
Bowling_skill,bowling skill,the id of the bowling skill,integer,
Country_Name,country name,the name of the country where the player is from,integer,
Player
original_column_name,column_name,column_description,data_format,value_description
Match_Id,match id,Unique Number Which Identifies a match,integer,
Over_Id,over id,Unique Number which Identifies an over in an Innings,integer,
Ball_Id,ball id,Unique Number which Identifies a ball in an over,integer,
Extra_Type_Id,extra type id,Unique Number which Identifies extra type,integer,
Extra_Runs,extra runs,Number of extra runs,integer,
Innings_No,innings number,Unique Number which Identifies an innings in a match,integer,
Extra_Runs
original_column_name,column_name,column_description,data_format,value_description
Role_Id,role id,the unique id for the role,integer,
Role_Desc,role description,the role description ,text,
Rolee
original_column_name,column_name,column_description,data_format,value_description
Match_Id,match id,Unique Number Which Identifies a match,integer,
Over_Id,over id,Unique Number which Identifies an over in an Innings,integer,"commonsense evidence:
The match is made up of two innings and each team takes a turn at batting and bowling. An innings is made up of 50 overs. An over involves six deliveries from the bowler."
Ball_Id,ball id,Unique Number which Identifies a ball in an over,integer,
Innings_No,innings number,Unique Number which Identifies an innings in a match,integer,
Team_Batting,team batting,Unique Number which Identifies Batting team in a match,integer,
Team_Bowling,team bowling,Unique Number which Identifies Bowling team in a match,integer,
Striker_Batting_Position,striker batting position,Unique Number which Identifies the position in which player came into bat,integer,
Striker,,Unique Number which Identifies the player who is on strike for that particular ball,integer,
Non_Striker,non striker,Unique Number which Identifies the player who is Non-striker for that particular ball,integer,
Bowler,,Unique Number which Identifies the player who is Bowling that particular ball,integer,
Ball_by_Ball