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 (비밀번호)