Todo App

Tables (4)

Categories (categories)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • color (Field2) — varchar(7)

Reminders (reminders)

  • id (Key) — int — Primary key — NOT NULL
  • todo_id (Key2) — int — Foreign key → Todo.id — NOT NULL
  • reminder_time (Field) — datetime
  • message (Field2) — varchar(50)
  • created_at (Field3) — timestamp

Todo (todo)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → User.id — NOT NULL
  • category_id (Key3) — int — Foreign key → Categories.id — NOT NULL
  • title (Field) — varchar(50)
  • start_date (Field2) — datetime
  • Field3 — datetime
  • memo (Field4) — varchar(100)
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • is_completed (Field8) — boolean

User (user)

  • id (Key) — int — Primary key — NOT NULL
  • email (Field) — varchar(50)
  • password (Field2) — varchar(50)
  • name (Field3) — varchar(10)
  • created_at (Field4) — timestamp
  • completed_todos (Field5) — int