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