eee

Tables (11)

Coach (코치 계정)

  • id — varchar — Primary key — NOT NULL
  • companyId — varchar — Foreign key → Company.id — NOT NULL
  • email — varchar
  • password — varchar
  • createdAt — datetime
  • updatedAt — datetime

Company (회사(구단) 정보)

  • id — varchar — Primary key — NOT NULL
  • companyName — varchar
  • createdAt — datetime
  • updatedAt — datetime
  • companyCode — varchar

CompanyLocalization (회사 다국어)

  • id — varchar — Primary key — NOT NULL
  • companyId — varchar — Foreign key → Company.id — NOT NULL
  • languageId — varchar — Foreign key → Language.id — NOT NULL
  • name — varchar
  • createdAt — datetime
  • updatedAt — datetime

Language (다국어)

  • id — varchar — Primary key — NOT NULL
  • name — varchar

Match (매치정보)

  • id — varchar — Primary key — NOT NULL
  • opggPuuid — varchar — Foreign key → Summoner.opggPuuid — NOT NULL
  • riotPuuid — varchar — Foreign key → Summoner.riotPuuid — NOT NULL
  • userPuuid — varchar — Foreign key → Summoner.userPuuid — NOT NULL
  • details — Json

Memo (선수별 메모 내용)

  • id — varchar — Primary key — NOT NULL
  • userId — varchar — Foreign key → User.id — NOT NULL
  • content — varchar
  • createdAt — datetime
  • updatedAt — datetime

Summoner (서머너 정보)

  • opggPuuid — varchar — Primary key — NOT NULL
  • riotPuuid — varchar — Primary key — NOT NULL
  • userPuuid — varchar — Foreign key → User.id — NOT NULL
  • nickname — varchar

Team (회사에 소속된 팀)

  • id — varchar — Primary key — NOT NULL
  • companyId — varchar — Foreign key → Company.id — NOT NULL
  • teamName — varchar
  • createdAt (updatedAt) — varchar

TrainigGoal (선수 훈련 목표량)

  • id — varchar — Primary key — NOT NULL
  • userId — varchar — Foreign key → User.id — NOT NULL
  • name (훈련 목표이름) — varchar
  • goal (목표량) — number
  • goalType (기본/챌린지) — varchar
  • trainingAmount (현재 훈련량) — number
  • createdAt — datetime
  • updatedAt — datetime

User (유저 계정)

  • id — varchar — Primary key — NOT NULL
  • email — varchar
  • name — varchar
  • profileImage — varchar
  • createdAt — datetime
  • updatedAt — datetime
  • password — varchar

UserMembership (유저가 들어가있는 회사와 팀)

  • id — varchar — Primary key — NOT NULL
  • userId — varchar — Foreign key → User.id — NOT NULL
  • companyId — varchar — Foreign key → Company.id — NOT NULL
  • teamId — varchar — Foreign key → Team.id — NOT NULL
  • role — varchar
  • createdAt — datetime
  • updatedAt — datetime