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