todo

Tables (5)

history (Untitled2)

  • id (PRIMARY KEY) — Primary key — NOT NULL
  • taskId (FOREIGN KEY) — Foreign key → task.id — NOT NULL
  • userId (FOREIGN KEY2) — Foreign key → user.id — NOT NULL
  • moveColumnId (FOREIGN KEY3) — Foreign key → task_column.id — NOT NULL
  • type (Field)
  • date (Field2)

task (Untitled5)

  • id (PRIMARY KEY) — Primary key — NOT NULL
  • userId (FOREIGN KEY) — Foreign key → user.id — NOT NULL
  • columnId (FOREIGN KEY2) — Foreign key → task_column.id — NOT NULL
  • titme (Field)
  • content (Field2)
  • createDate (Field3)
  • visible (Field4)
  • Field5

task_column (Untitled3)

  • id (PRIMARY KEY) — Primary key — NOT NULL
  • name (Field)
  • order (Field2)

user (Untitled)

  • id (PRIMARY KEY) — Primary key — NOT NULL
  • name (Field)
  • password (Field3)
  • image (Field2)

user_history (Untitled4)

  • id (PRIMARY KEY) — Primary key — NOT NULL
  • userId (FOREIGN KEY) — Foreign key → user.id — NOT NULL
  • historyId (FOREIGN KEY2) — Foreign key → history.id — NOT NULL
  • isDelete (Field)