W7_hw
Tables (5)
Fixed_schedule (고정일정)
- schedule_id (일정번호) — int — Primary key — NOT NULL
- title (일정제목) — varchar(100)
- start_time (시작시간) — datetime
- end_time (종료시간) — datetime
- user_id (유저번호) — int — Foreign key → User.user_id — NOT NULL
Scheduled_task (배치된업무)
- scheduled_id (배치번호) — int — Primary key — NOT NULL
- start_time (할당된_시작시간) — datetime
- end_time (할당된_종료시간) — datetime
- is_locked (수동_고정_여부) — boolean
- task_id (업무번호) — int — Foreign key → Task.task_id — NOT NULL
Task (할일)
- task_id (업무번호) — int — Primary key — NOT NULL
- title (업무제목) — varchar(100)
- category (업무_카테고리) — varchar(20)
- priority (중요도) — int
- deadline (마감기한) — datetime
- estimated_duration (예상소요시간) — int
- status (상태) — enum
- user_id (유저번호) — int — Foreign key → User.user_id — NOT NULL
User (사용자)
- user_id (유저번호) — int — Primary key — NOT NULL
- password (비밀번호) — varchar(20)
- name (이름) — varchar(20)
- work_start_time (업무_시작_가능_시간) — time
- work_end_time (업무_종료_시간) — time
task_history (실제수행기록)
- history_id (기록번호) — int — Primary key — NOT NULL
- planned_duration (계획된_소요시간) — int
- actual_duration (실제_소요시간) — int
- completed_at (완료일시) — datetime
- user_id (유저번호) — int — Foreign key → User.user_id — NOT NULL
- task_id (업무번호) — int — Foreign key → Task.task_id — NOT NULL