GetBetter

Tables (11)

Daily (퀘스트)

  • daily_id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • level (Field) — int
  • completion (Field2) — Boolean
  • today (Field4) — DATE
  • study_time (Field3) — TIME(n)

DailyQuest (Untitled4)

  • quest_id (Key) — Primary key — NOT NULL
  • level (Field) — int
  • type (Field2) — int
  • type_value (Field3) — Long
  • exp (Field4) — Long
  • tool_tip (Field5)
  • dailyQuest_id (Key2) — Long — Foreign key → Daily.daily_id — NOT NULL
  • user_id (Key22) — long — Foreign key → Daily.user_id — NOT NULL

Deco (배경화면(꾸미기))

  • deco_id (Key) — Long — Primary key — NOT NULL
  • deco_name (Field) — String
  • deco_type (Field2) — ENUM
  • deco_cost (Field3) — Long
  • deco_file (Field4) — STring

Emblems (전체 엠블럼들)

  • emblem_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • icon_file (Field2) — String
  • explain (Field3) — String
  • is_mine (Field4) — Boolean

Kong (전체 콩들(의상실))

  • kong_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • cost (Field2) — Long
  • unlock (Field3) — ENUM
  • unlock_value (Field4) — Long
  • file_name (Field5) — String

LevelQuest (Untitled5)

  • level_id (Key) — int — Primary key — NOT NULL
  • lv_exp (Field) — int
  • reward_type (Field2) — ENUM
  • type_value (Field3)
  • desc (Field4) — String

MyDeco (Untitled7)

  • user_id (Key) — long — Foreign key → User.user_id — NOT NULL
  • deco_id (Key2) — Long — Foreign key → Deco.deco_id — NOT NULL
  • is_selected (Field) — Boolean
  • Field2 — Boolean

MyEmblem (Untitled6)

  • user_id (Key) — long — Foreign key → User.user_id — NOT NULL
  • is_selected (Field) — Boolean
  • emblem_id (Key2) — Long — Foreign key → Emblems.emblem_id — NOT NULL

MyKongs (Untitled3)

  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • kong_id (Key) — Long — Foreign key → Kong.kong_id — NOT NULL
  • loc_x (Field) — Float
  • loc_y (Field2) — Float
  • is_selected (Field3) — Boolean

Setting (Untitled2)

  • user_id (Key) — long — Foreign key → User.user_id — NOT NULL
  • alarm (Field) — Boolean
  • sound (Field2) — int
  • language (Field3) — ENUM(String)

User (Untitled)

  • user_id (Key) — long — Primary key — NOT NULL
  • password (Field)
  • nickname (Field2) — String
  • email (Field3) — String
  • roles (Field4)
  • purpose (Field5) — ENUM(1,2,3,4)
  • goal (Field6) — String
  • d_day (Field7) — Date
  • coin (Field8) — Long
  • level_id (Key2) — int — Foreign key → LevelQuest.level_id — NOT NULL
  • my_exp (Field9) — int