todolist
Tables (4)
list (리스트)
- list_id (id) — CHAR(16) — Primary key — NOT NULL
- user_id (fk_user_id) — CHAR(16) — Foreign key → user.user_id — NOT NULL
- list_createdAt (createdAt) — DATE
status (상태)
- status_id (id) — CHAR(16) — Primary key — NOT NULL
- task_id (fk_task_id) — CHAR(16) — Foreign key → task.task_id — NOT NULL
- status_createdAt (createdAt) — DATE
task (할일)
- task_id (id) — CHAR(16) — Primary key — NOT NULL
- category_id (fk_category_id) — CHAR(16) — Foreign key → list.list_id — NOT NULL
- task_title (title) — CHAR(16)
- task_content (content) — TEXT
- task_createdAt (createdAt) — DATE
- task_updatedAt (updatedAt) — DATE
- task_expiredAt (expiredAt) — DATE
user (유저)
- user_id (id) — CHAR(16) — Primary key — NOT NULL
- user_email (email)
- user_password (password)
- user_name (name)
- user_ country (country)
- user_createdAt (createdAt) — DATE
- user_updatedAt (updatedAt) — DATE