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