Soccer
Tables (14)
ADMIN (관리자)
- int (id) — PK — Primary key — NOT NULL
- varchar (username)
- varchar (password)
- varchar (role)
- datetime (created_at)
COACHES (코치)
- int (id) — PK — Primary key — NOT NULL
- int (id2) — PK — Foreign key → PERSONS.int — NOT NULL
- varchar (license_level)
- int (team_id) — FK
MATCHES (경기 매치)
- int (id) — PK — Primary key — NOT NULL
- datetime (kickoff_time) — Primary key — NOT NULL
- varchar (round) — Primary key — NOT NULL
- varchar (venue)
- int (home_team_id) — FK
- int (away_team_id) — Fk
- int (home_score)
- int (away_score) — NOT NULL
- int (referee_id) — FK
- int (id2) — PK — Foreign key → TEAMS.int — NOT NULL
- varchar (code) — Foreign key → TEAMS.varchar — NOT NULL
- int (id3) — PK — Foreign key → REFEREE.int — NOT NULL
- int (id32) — PK — Foreign key → REFEREE.int — NOT NULL
NOTIFICATION (알림)
- int (id) — PK — Primary key — NOT NULL
- int (user_id) — FK
- varchar (type)
- varchar (title)
- varchar (content)
- varchar (status)
- datetime (sent_at)
- datetime (created_at)
- int (id2) — PK — Foreign key → USER.int — NOT NULL
PERSONS (사람)
- int (id) — PK — Primary key — NOT NULL
- varchar (name)
- date (birth_date)
- varchar (nationality)
- varchar (person_type)
PLAYS (플레이어)
- int (id) — PK — Primary key — NOT NULL
- int (id3) — PK — Foreign key → PERSONS.int — NOT NULL
- varchar (position)
- int (jersey_number)
- int (team_id) — FK
POINT_LOGS (포인트증정)
- int (id) — PK — Primary key — NOT NULL
- int (user_id) — FK
- int (admin_id) — FK
- int (amount)
- varchar (reason)
- datetime (created_at)
- int (id2) — FK — Foreign key → USER.int — NOT NULL
- int (id3) — FK — Foreign key → ADMIN.int — NOT NULL
PREDICTIONS (예언)
- int (id) — PK — Primary key — NOT NULL
- int (match_id) — FK
- varchar (predicted_result)
- int (bet_point)
- bool (is_rewarded)
- datetime (created_at)
- int (id2) — PK — Foreign key → PLAYS.int — NOT NULL
- int (id3) — PK — Foreign key → PLAYS.int — NOT NULL
- int (id4) — PK — Foreign key → USER.int — NOT NULL
- int (id5) — PK — Foreign key → MATCHES.int — NOT NULL
- datetime (kickoff_time) — Foreign key → MATCHES.datetime — NOT NULL
- varchar (round) — Foreign key → MATCHES.varchar — NOT NULL
PRODUCT (상품)
- int (id) — PK — Primary key — NOT NULL
- int (admin_id) — FK — Foreign key → ADMIN.int — NOT NULL
- varchar (name)
- varchar (description)
- int (required_point)
- int (stock)
- datetime (created_at)
PRODUCT ORDER (상품증정)
- int (id) — PK — Primary key — NOT NULL
- int (user_id) — FK
- int (produt_id) — FK
- int (used_point)
- varchar (status)
- datetime (created_at)
- int (product_id) — FK — Foreign key → USER.int — NOT NULL
- int (id4) — PK — Foreign key → PRODUCT.int — NOT NULL
- int (id2) — PK — Foreign key → NOTIFICATION.int — NOT NULL
REFEREE (심판)
- int (id) — PK — Primary key — NOT NULL
- int (id3) — PK — Foreign key → PERSONS.int — NOT NULL
- int (badge_year)
- int (id2) — PK — Foreign key → TEAMS.int — NOT NULL
- varchar (code) — Foreign key → TEAMS.varchar — NOT NULL
- int (id32) — PK — Foreign key → TEAMS.int — NOT NULL
TEAMS (나라 팀명)
- int (id) — PK — Primary key — NOT NULL
- varchar (code) — Primary key — NOT NULL
- varchar (name)
- int (group_id) — FK
- Field
- int (id2) — FK — Foreign key → TOURMENT_GROUPS.int — NOT NULL
- int (id3) — PK — Foreign key → PLAYS.int — NOT NULL
- int (id32) — PK — Foreign key → PLAYS.int — NOT NULL
TOURMENT_GROUPS (월드컵 조)
- int (id) — PK — Primary key — NOT NULL
- varchar (tournament_name) — NOT NULL
- varchar (stage)
- varchar (name) — NOT NULL
USER (사용자)
- int (id) — PK — Primary key — NOT NULL
- varchar (email)
- varchar (password)
- varchar (nickname)
- int (current_point)
- datetime (created_at)