scheduler
Tables (6)
Level
- level_id — INT — Primary key
- name — VARCHAR(30) — NOT NULL
- min_score — INT — NOT NULL
- max_score — INT
Plan
- plan_id — INT
- user_id — INT — NOT NULL
- type — ENUM('monthly', 'weekly') — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT
PointHistory
- point_id — INT
- user_id — INT — NOT NULL
- change_amount — INT — NOT NULL
- reason — VARCHAR(100)
- created_at — DATETIME
Schedule
- schedule_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(100)
- schedule_date — DATE — NOT NULL
Todo
- todo_id — INT
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- due_date — DATE
- is_completed — BOOLEAN
- created_at — DATETIME
User
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- score — INT
- level_id — INT
- created — DATETIME