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