NBA Playoff prediction

Tables (8)

admin_logs

  • id — BIGINT
  • admin_user_id — BIGINT
  • action_type — VARCHAR(100)
  • target_table — VARCHAR(100)
  • target_id — BIGINT
  • description — TEXT
  • created_at — TIMESTAMP

comment_likes

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id
  • comment_id — BIGINT — Foreign key → comments.id

comments

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id
  • game_id — BIGINT — Foreign key → games.id
  • parent_comment_id — BIGINT — Foreign key → comments.id
  • content — TEXT

games

  • id — BIGINT
  • home_team_id — BIGINT — Foreign key → teams.id
  • away_team_id — BIGINT — Foreign key → teams.id
  • game_date — DATETIME
  • status — VARCHAR(50)
  • round_name — VARCHAR(100)
  • series_score — VARCHAR(100)
  • home_score — INT
  • away_score — INT
  • winner_team_id — BIGINT — Foreign key → teams.id

predictions

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id
  • game_id — BIGINT — Foreign key → games.id
  • predicted_team_id — BIGINT — Foreign key → teams.id
  • predicted_home_score — INT
  • predicted_away_score — INT
  • is_correct — BOOLEAN

rankings

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id
  • total_predictions — INT
  • correct_predictions — INT
  • accuracy_rate — DECIMAL(5,2)
  • total_points — INT

teams

  • id — BIGINT
  • team_name — VARCHAR(255)
  • short_name — VARCHAR(50)
  • conference — VARCHAR(50)
  • logo_url — VARCHAR(255)

users

  • id — BIGINT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • nickname — VARCHAR(255)
  • role — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP