my-todo-list

Tables (4)

Category (Untitled3)

  • c_idx (Key) — int — Primary key — NOT NULL
  • u_idx (Key2) — int — Foreign key → User.u_idx — NOT NULL
  • c_name (Field) — varchar
  • c_color (Field2) — varchar

Task (Untitled2)

  • t_idx (Key) — int — Primary key — NOT NULL
  • u_idx (Key2) — int — Foreign key → User.u_idx — NOT NULL
  • title (Field2) — varchar
  • description (Field3) — varchar
  • due_date (Field4) — datetime
  • status (Field5) — varchar
  • created_at (Field6) — datetime
  • updated_at (Field7) — datetime

TaskCategory (Untitled4)

  • tc_idx (Key) — int — Primary key — NOT NULL

User (Untitled)

  • u_idx (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • email (Field2) — varchar
  • password (Field3) — varchar
  • created_at (Field4) — datetime
  • Field5