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