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