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