workdiary

Tables (3)

bookmark (즐겨찾기)

  • bookmark_id (pk) — Primary key — NOT NULL
  • is_bookmarked (북마크여부)
  • user_id (pk2) — Foreign key → user.user_id — NOT NULL
  • task_id (pk3) — Foreign key → task.task_id — NOT NULL

task (단일업무)

  • task_id (pk) — Primary key — NOT NULL
  • content (내용)
  • importance (중요도)
  • category (업무 유형)
  • is_deleted (삭제여부)
  • date (날짜)
  • is_completed (완료여부)
  • user_id (pk2) — Foreign key → user.user_id — NOT NULL

user (사용자)

  • user_id (pk) — Primary key — NOT NULL
  • email (메일)
  • username (아이디)
  • password (비밀번호)