CREATE TABLE height_info
(
    height_id      INTEGER
            primary key,
    height_in_cm   INTEGER,
    height_in_inch TEXT
);
height_info
CREATE TABLE weight_info
(
    weight_id     INTEGER
            primary key,
    weight_in_kg  INTEGER,
    weight_in_lbs INTEGER
);
weight_info
CREATE TABLE PlayerInfo
(
    ELITEID           INTEGER
            primary key,
    PlayerName        TEXT,
    birthdate         TEXT,
    birthyear         DATE,
    birthmonth        INTEGER,
    birthday          INTEGER,
    birthplace        TEXT,
    nation            TEXT,
    height            INTEGER,
    weight            INTEGER,
    position_info     TEXT,
    shoots            TEXT,
    draftyear         INTEGER,
    draftround        INTEGER,
    overall           INTEGER,
    overallby         TEXT,
    CSS_rank          INTEGER,
    sum_7yr_GP        INTEGER,
    sum_7yr_TOI       INTEGER,
    GP_greater_than_0 TEXT,
    foreign key (height) references height_info(height_id),
    foreign key (weight) references weight_info(weight_id)
);
PlayerInfo
CREATE TABLE SeasonStatus
(
    ELITEID   INTEGER,
    SEASON    TEXT,
    TEAM      TEXT,
    LEAGUE    TEXT,
    GAMETYPE  TEXT,
    GP        INTEGER,
    G         INTEGER,
    A         INTEGER,
    P         INTEGER,
    PIM       INTEGER,
    PLUSMINUS INTEGER,
    foreign key (ELITEID) references PlayerInfo(ELITEID)
);
SeasonStatus
original_column_name,column_name,column_description,data_format,value_description
height_id,height id,the unique height id,integer,
height_in_cm,height in cm,height in cm,integer,e.g. 180 --> the height is 180 cm
height_in_inch,height in inch,height in inch,text,
height_info
original_column_name,column_name,column_description,data_format,value_description
weight_id,weight id,the unique weight id,integer,
weight_in_kg,weight in kg,weight in kg,integer,e.g. 70: -->70 kg
weight_in_lbs,weight in lbs,weight in lbs,integer,
weight_info
original_column_name,column_name,column_description,data_format,value_description
ELITEID,ELITE ID,the unique number identifying the players who attended the draft,integer,
PlayerName,Player Name,the name of the player,text,
birthdate,,the birthdate of the player,text,
birthyear,,the birth year of the player,date,
birthmonth,,the birth month of the player,integer,
birthday,,the birthday of the player,integer,
birthplace,,the player of the birthplace,text,
nation,,the nation of the player,text,"commonsense evidence: can ask questions about their corresponding continents. or group nations with their continents. You can refer to https://worldpopulationreview.com/country-rankings/list-of-countries-by-continent
e.g.: Slovakia --> Europe"
height,,the id number identifying heights,integer,
weight,,the id number identifying weights,integer,
position_info,position information,position information of the player,text,"commonsense evidence: There are six different positions in hockey: 
left wing,  
right wing,  
center,  
left defenseman, 
right defenseman 
goalie. 
Left wings, right wings, and centers are all considered forwards, while left and right defensemen are considered the defense."
shoots,,,text,"commonsense evidence: 
 L: Left-shooted 
 R: Right-shooted 
 '-': no preference"
draftyear,draft year,draft year,integer,
draftround,draft round,draft round,integer,
overall,,overall orders of draft picks,integer,
overallby,,drafted by which team,text,
CSS_rank,Central Scouting Service ranking,Central Scouting Service ranking,integer,commonsense evidence: higher rank refers to higher prospects for the draft
sum_7yr_GP,sum 7-year game plays,Total NHL games played in players first 7 years of NHL career,integer,commonsense evidence: higher --> more attendance in the first 7 years
sum_7yr_TOI,sum 7-year time on ice,Total NHL Time on Ice in players first 7 years of NHL career,integer,commonsense evidence: higher --> more playing time in the first 7 years of career
GP_greater_than_0,game play greater than 0,Played a game or not in players first 7 years of NHL career,text," yes 
 no"
PlayerInfo
original_column_name,column_name,column_description,data_format,value_description
ELITEID,ELITE ID,the id number of the players,integer,
SEASON,,season when players are playing,text,
TEAM,,which team the player belong to,text,
LEAGUE,,league,text,
GAMETYPE,GAME TYPE ,type of games,text, Regular season  playoffs (post season)
GP,Game Plays,number of games,integer,
G,,Goals in Draft Year,integer,
A,,Assists in Draft Year,integer,
P,,Points in Draft Year,integer,commonsense evidence: higher --> more valuable
PIM,Penalty Minutes,Penalty Minutes in Draft Year,integer,commonsense evidence: higher --> This player has committed more rule violations.
PLUSMINUS,Plus Minutes,Goal Differential in Draft Year,integer,Goal Differential
SeasonStatus