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