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