todo erd
Tables (4)
category
- category_id (id) — INT — Primary key
- name — VARCHAR — 유니크
- created_at (createdAt) — DATETIME
- updated_at (updatedAt) — DATETIME
todo
- todo_id (id) — INT — Primary key — TODO id
- todo_user_id (id2) — INT — Foreign key → todo_user.todo_user_id — NOT NULL
- todo — VARCHAR — NOT NULL — todo 내용
- is_done (isDone) — BOOLEAN
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
- price — INT
- owner — User
todo categories
- todo_categories_id (id) — Primary key
- todo_id (id2) — INT — Foreign key → todo.todo_id — NOT NULL — TODO id
- category_id (id3) — INT — Foreign key → category.category_id
- todo_user_id (id22) — INT — Foreign key → todo.todo_user_id — NOT NULL
- created_at (createdAt) — DATETIME
- updated_at (updatedAt) — DATETIME
todo_user (user)
- todo_user_id (id) — INT — Primary key — NOT NULL
- user_id (userid) — VARCHAR
- password — VARCHAR
- money (balance) — INT
- todo_list (todoList) — Todo