scheduler
Tables (6)
level
- level_id — INT
- name — VARCHAR(30)
- min_score — INT
- max_score — INT
plan
- plan_id — INT
- type — ENUM('monthly', 'weekly')
- title — VARCHAR(100)
- content — TEXT
- user_id — INT
pointhistory
- point_id — INT
- change_amount — INT
- reason — VARCHAR(100)
- created_at — DATETIME
- user_id — INT
schedule
- schedule_id — INT
- title — VARCHAR(100)
- schedule_date — DATE
- user_id — INT
todo
- todo_id — INT
- content — TEXT
- due_date — DATE
- is_completed — BOOLEAN
- created_at — DATETIME
- user_id — INT
user
- user_id — INT
- email — VARCHAR(100)
- username — VARCHAR(50)
- password — VARCHAR(255)
- score — INT
- created — DATETIME
- level_id — INT