ethereal_trail
Tables (6)
AchievementList (업적리스트)
- id (업적목록아이디) — int — Primary key — NOT NULL
- name (업적이름) — varchar
- description (업적내용) — varchar
- createdAt (업적생성일) — datetime
- updatedAt (업적수정일) — datetune
Achievements (달성업적)
- id (업적아이디) — int — Primary key — NOT NULL
- id (유저아이디) — int — Foreign key → User.id — NOT NULL
- id (업적목록아이디) — int — Foreign key → AchievementList.id — NOT NULL
- isAchieved (달성여부) — boolean
- progress (진행상황) — int
- achievedAt (달성시간) — datetime
Ranking (랭킹)
- id (랭킹아이디) — int — Primary key — NOT NULL
- id (유저아이디) — int — Foreign key → User.id — NOT NULL
- ranking (랭킹) — bigint
- rankingUpdatedAt (수정일) — datetime
User (유저)
- id (유저아이디) — int — Primary key — NOT NULL
- steamId (스팀아이디) — varchar
- nickname (닉네임) — varchar
- aether (에테르) — int
- items (아이템목록) — varchar
- steamPlaytime (스팀플레이타임) — datetime
- icon (아이콘) — varchar
- createdAt (설치일) — datetime
- updatedAt (수정일) — datetime
hallOfFame (명예의 전당)
- id (명예의전당아이디) — int — Primary key — NOT NULL
- id (유저아이디) — int — Foreign key → User.id — NOT NULL
- fameRank (명전랭킹) — int
- createdAt (전당등록일) — datetime
- updatedAt (재등록) — datetime
saveData (세이브데이터)
- id (캐릭터스탯아이디) — int — Primary key — NOT NULL
- id (유저아이디) — int — Foreign key → User.id — NOT NULL
- stage (현재스테이지) — int
- health (체력) — int
- mana (마력) — int
- playtime (인게임플레이타임) — Float
- changerPaid (유료교체권) — int
- changerFree (무료교체권) — int
- talent (재능인덱스) — int
- specificity (특성인덱스) — varchar
- retry (재도전횟수) — int
- revival (부활횟수) — int
- trialOrb (시련스택) — int
- pet (펫데이터) — int
- isClear (클리어여부) — boolean
- createdAt (세이브생성일) — datetime
- updatedAt (세이브수정일) — datetime