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