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