tr

Tables (6)

Competition

  • id — INT — Primary key — NOT NULL
  • host_id — INT — Foreign key → User.id — NOT NULL
  • competition_title — VARCHAR(50)
  • competition_content — TEXT
  • event — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • qualification — TEXT
  • prize — TEXT
  • poster_path — TEXT
  • pdf_path — TEXT
  • recruit_period — VARCHAR(255)
  • competition_period — VARCHAR(255)
  • format — VARCHAR(255)
  • scale — VARCHAR(255)

Player

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.id — NOT NULL
  • team_id — INT — Foreign key → Team.id — NOT NULL
  • nickname — VARCHAR(255)
  • created_at — TIMESTAMP
  • updaed_at — TIMESTAMP
  • name — VARCHAR(255)

Team

  • id — INT — Primary key — NOT NULL
  • team_name — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • competition_id — INT

Team_Competition_History

  • id — INT — Primary key — NOT NULL
  • id2 — INT — Foreign key → Competition.host_id — NOT NULL
  • competition_id — INT — Foreign key → Competition.id — NOT NULL
  • team_id — INT — Foreign key → Team.id — NOT NULL
  • grade — INT
  • point — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Tournament_Node

  • id — INT — Primary key — NOT NULL
  • competition_id — INT — Foreign key → Competition.id — NOT NULL
  • round — INT
  • match_number — INT
  • team1_id — INT
  • team2_id — INT
  • winner_id — INT
  • is_finished — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

User

  • id — INT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • emailVerified — BOOLEAN
  • password — VARCHAR(255)
  • name — VARCHAR(255)
  • nickname — VARCHAR(255)
  • birth — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • discord_auth — VARCHAR(255)
  • riot_auth — VARCHAR(255)
  • school_auth — VARCHAR(255)
  • played_competition — INT
  • played_match — INT
  • win — INT
  • lose — INT