FcSeoul ERD

Tables (7)

User (사용자)

  • id (사용자아이디) — BIGINT — Primary key — NOT NULL
  • favorite_club_id (응원구단아이디) — BIGINT — Foreign key → clubs.id — NOT NULL
  • email (이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(255)
  • nickname (닉네임) — VARCHAR(30)
  • role (사용자권한) — VARCHAR(20)
  • created_at (생성일자) — DATETIME
  • updated_at (수정일자) — DATETIME

anthems (응원가)

  • id (응원가아이디) — BIGINT — Primary key — NOT NULL
  • club_id (구단아이디) — BIGINT — Foreign key → clubs.id — NOT NULL
  • player_id (선수아이디) — BIGINT — Foreign key → players.id — NOT NULL
  • title (응원가제목) — VARCHAR(100)
  • lyrics (가사) — TEXT
  • created_at (생성일자) — DATETIME
  • updated_at (수정일자) — DATETIME

clubs (구단)

  • id (구단아이디) — BIGINT — Primary key — NOT NULL
  • name (구단이름) — VARCHAR(50)
  • short_name (구단약칭) — VARCHAR(10)
  • logo_url (로고사진) — VARCHAR(2048)
  • stadium_name (스타디움이름) — VARCHAR(100)
  • created_at (생성일자) — DATETIME
  • updated_at (수정일자) — DATETIME

matches (경기)

  • id (경기아이디) — BIGINT — Primary key — NOT NULL
  • api_fixture_id (경기고유ID) — BIGINT
  • home_club_id (홈구단아이디) — BIGINT — Foreign key → clubs.id — NOT NULL
  • away_club_id (원정구단아이디) — BIGINT — Foreign key → clubs.id — NOT NULL
  • match_date (경기일자) — DATETIME
  • round (리그 라운드) — INT
  • home_score (홈팀득점수) — INT
  • away_score (원정팀득점수) — INT
  • created_at (생성일자) — DATETIME
  • updated_at (수정일자) — DATETIME

players (선수)

  • id (선수아이디) — BIGINT — Primary key — NOT NULL
  • club_id (구단아이디) — BIGINT — Foreign key → clubs.id — NOT NULL
  • api_player_id (api고유아이디) — BIGINT
  • name (선수명) — VARCHAR(50)
  • back_number (등번호) — INT
  • position (포지션) — VARCHAR(10)
  • birth_date (선수생일) — DATE
  • created_at (생성일자) — DATETIME
  • updated_at (수정일자) — DATETIME

playlist_anthems (플레이리스트-응원가 매핑)

  • id (매핑아이디) — BIGINT — Primary key — NOT NULL
  • playlist_id (플레이리스트아이디) — BIGINT — Foreign key → playlists.id — NOT NULL
  • anthem_id (응원가아이디) — BIGINT — Foreign key → anthems.id — NOT NULL
  • created_at (생성일자) — DATETIME

playlists (플레이리스트)

  • id (플레이리스트아이디) — BIGINT — Primary key — NOT NULL
  • user_id (사용자아이디) — BIGINT — Foreign key → User.id — NOT NULL
  • title (제목) — VARCHAR(100)
  • created_at (생성일자) — DATETIME
  • updated_at (수정일자) — DATETIME