todo-list

Tables (5)

Category (Untitled3)

  • 카테고리ID (category_id) — NOT NULL — Primary key — NOT NULL
  • 카테고리명 (name) — NOT NULL
  • 아이콘 (icon_url) — NOT NULL

Priority (Untitled4)

  • 중요도ID (priority_id) — NOT NULL — Primary key — NOT NULL
  • 순위 (level_name) — NOT NULL

Reminder (Untitled6)

  • 알림ID (reminder_id) — NOT NULL — Primary key — NOT NULL
  • 발송여부 (is_sent) — NOTNULL
  • 할일ID (todo_id) — NOT NULL — NOT NULL

Todo (Untitled2)

  • 할일ID (todo_id) — NOT NULL — Primary key — NOT NULL
  • 내용 (content) — NOT NULL
  • 완료여부 (is_done) — NOTNULL
  • 사용자ID (user_id) — NOT NULL — Foreign key → Users.사용자 — NOT NULL
  • 카테고리ID (category_id) — NOT NULL — Foreign key → Category.카테고리ID — NOT NULL
  • 중요도ID (priority_id) — NOT NULL — Foreign key → Priority.중요도ID — NOT NULL
  • 알림ID (reminder_id) — NOT NULL — Foreign key → Reminder.알림ID — NOT NULL

Users (Untitled)

  • 사용자 (user_id) — NOT NULL — Primary key — NOT NULL
  • 이름 (username) — NOT NULL
  • 이메일 (useremail) — NOT NULL
  • 비밀번호 (password) — NOT NULL