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)