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 — Primary key
- type — ENUM('monthly', 'weekly')
- title — VARCHAR(100)
- content — TEXT
- user_id — INT — Foreign key → User.user_id
PointHistory
- point_id — INT — Primary key
- change_amount — INT
- reason — VARCHAR(100)
- created — DATETIME
- user_id — INT — Foreign key → User.user_id
Schedule
- schedule_id — INT — Primary key
- title — VARCHAR(100)
- schedule_date — DATE
- user_id — INT — Foreign key → User.user_id
Todo
- todo_id — INT — Primary key
- content — TEXT — NOT NULL
- due_date — DATE
- completed — BOOLEAN
- created — DATETIME
- user_id — INT — Foreign key → User.user_id
User
- user_id — INT — Primary key
- email — VARCHAR(100) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- score — INT
- created — DATETIME
- level_id — INT — Foreign key → Level.level_id