worldcup

Tables (8)

admin_logs

  • id — INTEGER — Primary key — NOT NULL
  • admin_user_id — INTEGER — Foreign key → users.id — NOT NULL
  • action_type — VARCHAR(100) — NOT NULL
  • target_table — VARCHAR(100)
  • target_id — INTEGER
  • description — TEXT
  • created_at — DATETIME

comment_likes

  • id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • comment_id — INTEGER — Foreign key → comments.id — NOT NULL

comments

  • id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • game_id — INTEGER — Foreign key → games.id — NOT NULL
  • parent_id — INTEGER — Foreign key → comments.id
  • content — TEXT — NOT NULL
  • created_at — DATETIME

games

  • id — INTEGER — Primary key — NOT NULL
  • home_team_id — INTEGER — Foreign key → teams.id — NOT NULL
  • away_team_id — INTEGER — Foreign key → teams.id — NOT NULL
  • game_date — DATETIME — NOT NULL
  • status — VARCHAR(20)
  • round_name — VARCHAR(100)
  • series_score — VARCHAR(50)
  • home_score — INTEGER
  • away_score — INTEGER
  • winner_team_id — INTEGER — Foreign key → teams.id
  • outcome — VARCHAR(50)

predictions

  • id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • game_id — INTEGER — Foreign key → games.id — NOT NULL
  • predicted_winner_id — INTEGER — Foreign key → teams.id — NOT NULL
  • predicted_home_score — INTEGER
  • predicted_away_score — INTEGER
  • is_correct — BOOLEAN

rankings

  • id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • total_predictions — INTEGER
  • correct_predictions — INTEGER
  • accuracy_rate — DECIMAL(5,2)
  • total_points — INTEGER

teams

  • id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • short_name — VARCHAR(20) — NOT NULL
  • conference — VARCHAR(50) — NOT NULL
  • logo_url — VARCHAR(255)

users

  • id — INTEGER — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20)
  • favorite_team_id — INTEGER — Foreign key → teams.id
  • created_at — DATETIME
  • updated_at — DATETIME