nanal - habittracker

Tables (6)

CHALLENGES (Untitled5)

  • ID (Key) — INT — Primary key — NOT NULL
  • USER_ID (Key2) — INT — Foreign key → USERS.ID — NOT NULL
  • TITLE (Field) — VARCHAR
  • CATEGORY (Field2) — VARCHAR
  • CURRENT_STREAK (Field3) — INT
  • BEST_STREAK (Field4) — INT
  • REPEAT_TYPE (Field5) — VARCHAR
  • REPEAT_DAYS (Field6) — VARCHAR
  • HABIT_TIME (Field7) — TIME
  • ALARM_LEAD_MIN (Field8) — VARCHAR
  • DISPLAY_ORDER (Field9) — INT
  • IS_ACTIVE (Field10) — TINYINT
  • STARTED_AT (Field11) — DATE

CHARACTERS (Untitled2)

  • ID (Key) — INT — Primary key — NOT NULL
  • NAME (Field) — VARCHAR
  • DESCRIPTION (Field2) — VARCHAR
  • UNLOCK_CONDITION (Field3) — VARCHAR
  • PRICE (Field4) — INT
  • IS_LIMITED (Field5) — TINYINT
  • CREATED_AT (Field6) — DATETIME

CHARACTER_LEVEL_HISTORY (Untitled4)

  • ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — INT — Foreign key → USERS.ID — NOT NULL
  • CHARACTER_ID (Key3) — INT — Foreign key → CHARACTERS.ID — NOT NULL
  • LEVEL (Field) — INT
  • LEVELED_UP_AT (Field2) — DATE

LOGS (Untitled6)

  • ID (Key) — INT — Primary key — NOT NULL
  • CHALLENGE_ID (Key2) — INT — Foreign key → CHALLENGES.ID — NOT NULL
  • LOG_DATE (Field) — DATE
  • IS_DONE (Field2) — TINYINT
  • DONE_AT (Field3) — DATETIME
  • IS_DOUBLED (Field4) — TINYINT
  • XP_GRANTED (Field5) — TINYINT
  • XP_AMOUNT (Field6) — SMALLINT
  • MEMO (Field7) — VARCHAR
  • DELETED_AT (Field8) — DATETIME

USERS (Untitled)

  • ID (Key) — INT — Primary key — NOT NULL
  • EMAIL (Field) — VARCHAR
  • PASSWORD_HASH (Field2) — VARCHAR
  • NICKNAME (Field3) — VARCHAR
  • COINS (Field4) — INT
  • TOTAL_DAYS (Field5) — INT
  • FCM_TOKEN (Field6) — VARCHAR
  • LAST_CHECKIN_DATE (Field7) — DATE
  • CALENDAR_MODE (Field8) — ENUM
  • DELETED_AT (Field9) — DATETIME

USER_CHARACTERS (Untitled3)

  • ID (Key) — INT — Primary key — NOT NULL
  • USER_ID (Key3) — INT — Foreign key → USERS.ID — NOT NULL
  • CHARACTER_ID (Key2) — INT — Foreign key → CHARACTERS.ID — NOT NULL
  • LEVEL (Field) — TINYINT
  • EXP (Field2) — INT
  • IS_ACTIVE (Field3) — TINYINT
  • IS_PURCHASED (Field4) — TINYINT
  • UNLOCKED_AT (Field5) — DATETIME
  • ACTIVATED_AT (Field6) — DATE