soccer dream

Tables (12)

broadcast (리그 중계 정보)

  • broadcast_id (Key2) — Primary key — NOT NULL
  • league_id (Key) — Long — Foreign key → league.league_id — NOT NULL
  • channel (Field) — Varcher(20) — 중계 채널

league (리그)

  • league_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — Varcher(20) — NOT NULL — 리그 이름
  • type (Field2) — Varcher(20) — NOT NULL — 리그 종류
  • logo (Field3) — Varchar(50) — NOT NULL — 로고 이미지 url
  • fba_id (Field4) — Integer — NOT NULL — football api 에서 리그 id

lineup (라인업)

  • lineup_id (Key) — Long — Primary key — NOT NULL
  • fomation (Field) — varcher(10) — 포메이션
  • created_date (Field1) — Date — NOT NULL — 생성일자(YYYY-MM-DD)
  • modified_date (Field2) — Date — NOT NULL — 수정일자(YYYY-MM-DD)
  • team_match_id (Key2) — Long — Foreign key → team_match.team_match_id — NOT NULL

lineup_player (라인업 선수 정보)

  • lineup_player_id (Key) — Long — Primary key — NOT NULL
  • lineup_id (Key2) — Long — Foreign key → lineup.lineup_id — NOT NULL
  • player_id (Key3) — long — Foreign key → player.player_id — NOT NULL

match (경기)

  • match_id (Key) — Long — Primary key — NOT NULL
  • schedule (Field) — Datetime — NOT NULL — 경기스케줄(YYYY-MM-DD hh:mm)
  • created_date (Field2) — Date — NOT NULL — 생성일자(YYYY-MM-DD)
  • modified_date (Field3) — Date — NOT NULL — 수정일자(YYYY-MM-DD)
  • fba_id (Field4) — Integer — NOT NULL — football api 에서 경기 id
  • league_id (Key2) — Long — Foreign key → league.league_id — NOT NULL

player (선수)

  • player_id (Key) — long — Primary key — NOT NULL
  • name (Field) — varcher(10) — NOT NULL — 선수 이름
  • number (Field2) — Integer — NOT NULL — 선수 등번호
  • created_date (Field3) — Date — NOT NULL — 생성일자(YYYY-MM-DD)
  • modified_date (Field4) — Date — NOT NULL — 수정일자(YYYY-MM-DD)
  • fba_id (Field5)
  • team_id (Key2) — Long — Foreign key → team.team_id — NOT NULL

subscription (선수 구독 정보)

  • subscription_id (Key) — Long — Primary key — NOT NULL
  • created_date (Field) — Date — NOT NULL — 생성일자(YYYY-MM-DD)
  • modified_date (Field2) — Date — NOT NULL — 수정일자(YYYY-MM-DD)
  • player_id (Key2) — long — Foreign key → player.player_id — NOT NULL

team (팀)

  • team_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — varcher(20) — NOT NULL — 팀 이름
  • code (Field2) — Varcher(10) — 팀 코드
  • logo (Field3) — varcher(50) — 로고 이미지 url
  • created_date (Field4) — Date — NOT NULL — 생성일자(YYYY-MM-DD)
  • modified_date (Field5) — Date — NOT NULL — 수정일자(YYYY-MM-DD)
  • fba_id (Field6) — Integer — NOT NULL — football api 에서 팀 id

team_league (팀 리그 정보)

  • team_league_id (Key) — Long — Primary key — NOT NULL
  • team_id (Key2) — Long — Foreign key → team.team_id — NOT NULL
  • league_id (Key3) — Long — Foreign key → league.league_id — NOT NULL

team_match (팀 경기 정보)

  • team_match_id (Key) — Long — Primary key — NOT NULL
  • is_home (Field) — Boolean — NOT NULL
  • created_date (Field2) — Date — NOT NULL — 생성일자(YYYY-MM-DD)
  • modified_date (Field3) — Date — NOT NULL — 수정일자(YYYY-MM-DD)
  • team_id (Key1) — Long — Foreign key → team.team_id — NOT NULL
  • match_id (Key2) — Long — Foreign key → match.match_id — NOT NULL

user (사용자)

  • user_id (Key) — Long — Primary key — NOT NULL
  • created_date (Field) — Date — NOT NULL — 생성일자(YYYY-MM-DD)
  • modified_date (Field2) — Date — NOT NULL — 수정일자(YYYY-MM-DD)

user_subscription (사용자 구독 정보)

  • user_subscription_id (Key) — Long — Primary key — NOT NULL
  • user_id (Key1) — Long — Foreign key → user.user_id — NOT NULL
  • subscribe_id (Key2) — Long — Foreign key → subscription.subscription_id — NOT NULL