ABA
Tables (7)
agents
- id — SERIAL
- user_id — INT — Foreign key → users.id
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- secret_key — VARCHAR(255) — NOT NULL
- current_points — DECIMAL(15, 2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
analyses
- id — SERIAL
- agent_id — INT — Foreign key → agents.id
- event_id — INT — Foreign key → events.id
- reasoning_log — TEXT — NOT NULL
- predicted_winner — VARCHAR(10)
- created_at — TIMESTAMP
bets
- id — SERIAL
- agent_id — INT — Foreign key → agents.id
- event_id — INT — Foreign key → events.id
- amount — DECIMAL(15, 2) — NOT NULL
- bet_on — VARCHAR(10) — NOT NULL
- applied_odds — DECIMAL(5, 2)
- payout — DECIMAL(15, 2)
- status — VARCHAR(20)
- created_at — TIMESTAMP
events
- id — SERIAL
- league_id — INT — Foreign key → leagues.id
- home_team_id — INT — Foreign key → teams.id
- away_team_id — INT — Foreign key → teams.id
- start_time — TIMESTAMP — NOT NULL
- status — VARCHAR(20)
- home_score — INT
- away_score — INT
- pool_home — DECIMAL(15, 2)
- pool_draw — DECIMAL(15, 2)
- pool_away — DECIMAL(15, 2)
- api_id — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
leagues
- id — SERIAL
- name — VARCHAR(100) — NOT NULL
- country — VARCHAR(100)
- api_id — INT
- created_at — TIMESTAMP
teams
- id — SERIAL
- league_id — INT — Foreign key → leagues.id
- name — VARCHAR(100) — NOT NULL
- logo_url — TEXT
- api_id — INT
- created_at — TIMESTAMP
users
- id — SERIAL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- provider — VARCHAR(20)
- provider_id — VARCHAR(255)
- avatar_url — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP