todo
Tables (3)
Category
- category_id — NOT NULL — Primary key — NOT NULL
- category — NOT NULL
- user_id — NOT NULL — Foreign key → User.user_id — NOT NULL
Todo
- todo_id — Primary key — NOT NULL
- content — NOT NULL
- memo — NULL
- date_created — NOT NULL
- last_update — NOT NULL
- date_target — NULL
- status — NOT NULL
- deleted — NOT NULL
- user_id — NOT NULL — Foreign key → User.user_id — NOT NULL
- category_id — NOT NULL — Foreign key → Category.category_id — NOT NULL
User
- user_id — NOT NULL — Primary key — NOT NULL
- email — NOT NULL
- password — NOT NULL
- nickname — NOT NULL
- date_created — NOT NULL
- withdraw — NOT NULL