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