checkit
Tables (4)
Schedule (schedule)
- id (스케줄id) — Primary key — NOT NULL
- user_id (유저id) — Foreign key → User.id — NOT NULL
- title (스케줄명)
- content (내용)
- start_time (시작시간)
- end_time (종료시간)
- is_completed (달성여부)
SubTask (subtask)
- id (하위 목표) — Primary key — NOT NULL
- id (스케줄id) — Foreign key → Schedule.id — NOT NULL
- user_id (유저id) — Foreign key → Schedule.user_id — NOT NULL
- content (내용)
- is_completed (달성여부)
TimeTable (timetable)
- created_at (생성시간) — Primary key — NOT NULL
- updated_at (업데이트시간) — Primary key — NOT NULL
User (users)
- id (유저id) — Primary key — NOT NULL
- name (이름)
- email (이메일)
- password (비밃번호)
- gender (성별)
- age (나이)