SSAFY_FOOTBALL

Tables (9)

comment

  • id — BIGINT
  • match_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

fan_community_post

  • id — BIGINT
  • team_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

highlight

  • id — BIGINT
  • match_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • video_url — VARCHAR(500) — NOT NULL
  • uploaded_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP

league

  • id — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • name — VARCHAR(100) — NOT NULL
  • country — VARCHAR(50) — NOT NULL

match_info

  • match_info (id) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • match_date — DATETIME — NOT NULL
  • home_score — INT
  • away_score — INT
  • is_finished — BOOLEAN
  • league_id — BIGINT — NOT NULL
  • home_team_id — BIGINT — Foreign key → team.id — NOT NULL — AUTO_INCREMENT
  • away_team_id (away_team_id2) — BIGINT — Foreign key → team.id — NOT NULL — AUTO_INCREMENT

news

  • id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

recommend

  • id — BIGINT
  • comment_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

team

  • id — Primary key — NOT NULL — AUTO_INCREMENT
  • name — VARCHAR(100) — NOT NULL
  • league_id — BIGINT — NOT NULL
  • logo_url — VARCHAR(255)
  • id (id2) — BIGINT — Foreign key → league.id — NOT NULL

user

  • id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • level — INT — NOT NULL
  • EXP — NOT NULL
  • created_at — NOT NULL
  • favorite_team