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