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 (나이)