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