Todo

Tables (3)

Task (Untitled)

  • id (Key) — Int — Primary key — NOT NULL
  • typeId (Key2) — Int — Foreign key → Type.id — NOT NULL
  • name (Field2) — String
  • date (Field) — Date
  • startTime (Field3) — Date
  • endTime (Field4) — Date
  • description (Field5) — String

TaskDetail (Untitled2)

  • id (Key) — Int — Primary key — NOT NULL
  • taskId (Key2) — Int — Foreign key → Task.id — NOT NULL
  • id (Key22) — Int — Foreign key → Task.typeId — NOT NULL
  • name (Field) — String
  • isDone (Field2) — Bool

Type (Untitled3)

  • id (Key) — Int — Primary key — NOT NULL
  • name (Field) — String
  • color (Field2) — String