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