data X

Tables (5)

task_progress_reports (CopyOfCopyOfUntitled2)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → users.id — NOT NULL
  • total_tasks (Field4) — timestamp
  • done_tasks (Field5)
  • progress_rate (Field)
  • collected_at (Field2)

tasks (CopyOfUntitled3)

  • id (Key) — int — Primary key — NOT NULL
  • assigned_user_id (Key2) — int — Foreign key → user_workspaces.user_id — NOT NULL
  • workspace_id (Key3) — int — Foreign key → user_workspaces.workspace_id — NOT NULL
  • title (Field) — varchar
  • description (Field2) — text
  • status (Field3) — varchar
  • category (Field6) — varchar
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

user_workspaces (CopyOfUntitled2)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → users.id — NOT NULL
  • workspace_id (Key3) — int — Foreign key → workspaces.id — NOT NULL
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

users (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • email (Field2) — varchar
  • password_digest (Field3) — varchar
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

workspaces (CopyOfUntitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp