Winter To Do

Tables (3)

subtask (Untitled2)

  • subtask_id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(n)

todo (Untitled)

  • todo_id (Key) — int — Primary key — NOT NULL
  • subtask_id (Key3) — int — Foreign key → subtask.subtask_id — NOT NULL
  • type_id (Key2) — int — Foreign key → type.type_id — NOT NULL
  • name (Field) — varchar(n)
  • date (Field2) — date
  • start_time (Field3) — timestamp
  • end_time (Field4) — timestamp
  • description (Field5) — varchar(n)
  • type_id (Field6) — int
  • subtask_id (Field7) — int

type (Untitled3)

  • type_id (Key) — int — Primary key — NOT NULL
  • todo_id (Key2) — int — Foreign key → todo.todo_id — NOT NULL
  • name (Field) — varchar(n)