CREATE TABLE hero (
    id INTEGER PRIMARY KEY,
    name VARCHAR(255)
);

CREATE TABLE matches (
    id BIGINT PRIMARY KEY,
    start_time INTEGER,
    leagueid INTEGER,
    radiant_team_id INTEGER,
    dire_team_id INTEGER,
    radiant_win BOOLEAN,
    source VARCHAR(255)
);

CREATE TABLE details_match (
    match_id BIGINT,
    hero_id INTEGER,
    team INTEGER,
    "order" INTEGER,
    players_id BIGINT,
    pos INTEGER
);

CREATE TABLE teams (
    id BIGINT PRIMARY KEY,
    name VARCHAR(255)
);

CREATE TABLE pro_players (
    id BIGINT PRIMARY KEY,
    name VARCHAR(255),
    team_id BIGINT
);