mamonov.ep
8a134239d7
Включает модели ML для предсказаний, API маршруты, скрипты обучения и данные. Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
34 lines
603 B
Plaintext
34 lines
603 B
Plaintext
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
|
|
); |