새싹

테이블 (6)

Achievement (Untitled3)

  • id — number — 기본 키 — NOT NULL
  • title — string
  • description — string

ChatHistory (Untitled6)

  • id — number — 기본 키 — NOT NULL
  • userId (user id) — number — 외래 키 → User.id — NOT NULL
  • createdAt (created at) — date
  • content

Progress (Untitled5)

  • id — number — 외래 키 → User.id — NOT NULL
  • type — string
  • createdAt (created at) — date
  • score — number

TestResult (Untitled2)

  • userId (user id) — number — 외래 키 → User.id — NOT NULL
  • score — number
  • creatdeAt (created at) — date

User (Untitled)

  • id — number — 기본 키 — NOT NULL
  • loginId (login id) — string
  • nickname — string
  • birthDate (birth date) — date
  • password — string
  • createdAt (created at) — date

UserAchievement (Untitled4)

  • userId (user id) — number — 외래 키 → User.id — NOT NULL
  • achievementId (achievement id) — number — 외래 키 → Achievement.id — NOT NULL
  • createdAt (created at) — date