▣
Operations

Project tasks

Projects, assignees, and tasks with stable foreign keys — ideal for multi-table fixtures.

9Fields
3Formats
∞Variations
02

Preview

Showing 7 of 25 generated rows

task_idproject_idproject_nameassignee_idassignee_nametitlestatusprioritydue_at
02d6fb83-14e1-47b9-bcd4-c8c3c96aa3f3863c320e-351f-4c24-8d0c-736db363c471Harbor Compliancece5d2fa1-8bc5-49d1-8edf-0eb2a23086a6Johanna BrownUpdate docsin_progresshigh2025-04-04T23:21:32.834Z
c895ab8f-86b8-41fb-90a8-43361270bc15863c320e-351f-4c24-8d0c-736db363c471Harbor Complianced6dd1a2f-74cc-4685-91d9-ebf8d7b97dc2Idris SorensenQA passin_progresslow2025-04-08T12:49:14.771Z
76166f75-6bf7-4c3b-bcd4-454f76c2b1f3863c320e-351f-4c24-8d0c-736db363c471Harbor Complianceffd51aba-7b83-4a70-aa6f-101fba0e78eePaloma PetrovSync stakeholdersblockedmedium2025-04-15T01:29:14.183Z
36bac84e-9612-4045-a1cf-bb94bfafce8097623271-950b-49fc-baa4-7c9798e2012dPulse Redesign188b2126-9bbe-4081-bc34-d5412e013bb6Ivan CruzReview PRdonemedium2025-05-22T16:57:00.260Z
b8ae19cd-7a96-430e-b8f2-538dbd181a5f863c320e-351f-4c24-8d0c-736db363c471Harbor Complianceffd51aba-7b83-4a70-aa6f-101fba0e78eePaloma PetrovUpdate docstodohigh2025-06-14T09:06:37.313Z
2c3ee907-988a-478f-b291-52938061ed28863c320e-351f-4c24-8d0c-736db363c471Harbor Compliance188b2126-9bbe-4081-bc34-d5412e013bb6Ivan CruzShip milestonetodolow2025-09-11T04:12:50.923Z
66fda856-641a-4987-829a-728ba84bde11863c320e-351f-4c24-8d0c-736db363c471Harbor Compliancece5d2fa1-8bc5-49d1-8edf-0eb2a23086a6Johanna BrownFix regressiontodomedium2025-10-05T19:41:12.376Z
project-tasks.json
[
  {
    "task_id": "02d6fb83-14e1-47b9-bcd4-c8c3c96aa3f3",
    "project_id": "863c320e-351f-4c24-8d0c-736db363c471",
    "project_name": "Harbor Compliance",
    "assignee_id": "ce5d2fa1-8bc5-49d1-8edf-0eb2a23086a6",
    "assignee_name": "Johanna Brown",
    "title": "Update docs",
    "status": "in_progress",
    "priority": "high",
    "due_at": "2025-04-04T23:21:32.834Z"
  },
  {
    "task_id": "c895ab8f-86b8-41fb-90a8-43361270bc15",
    "project_id": "863c320e-351f-4c24-8d0c-736db363c471",
    "project_name": "Harbor Compliance",
    "assignee_id": "d6dd1a2f-74cc-4685-91d9-ebf8d7b97dc2",
    "assignee_name": "Idris Sorensen",
    "title": "QA pass",
    "status": "in_progress",
    "priority": "low",
    "due_at": "2025-04-08T12:49:14.771Z"
  },
  {
    "task_id": "76166f75-6bf7-4c3b-bcd4-454f76c2b1f3",
    "project_id": "863c320e-351f-4c24-8d0c-736db363c471",
    "project_name": "Harbor Compliance",
    "assignee_id": "ffd51aba-7b83-4a70-aa6f-101fba0e78ee",
    "assignee_name": "Paloma Petrov",
    "title": "Sync stakeholders",
    "status": "blocked",
    "priority": "medium",
    "due_at": "2025-04-15T01:29:14.183Z"
  },
  {
    "task_id": "36bac84e-9612-4045-a1cf-bb94bfafce80",
    "project_id": "97623271-950b-49fc-baa4-7c9798e2012d",
    "project_name": "Pulse Redesign",
    "assignee_id": "188b2126-9bbe-4081-bc34-d5412e013bb6",
    "assignee_name": "Ivan Cruz",
    "title": "Review PR",
    "status": "done",
    "priority": "medium",
    "due_at": "2025-05-22T16:57:00.260Z"
  },
  {
    "task_id": "b8ae19cd-7a96-430e-b8f2-538dbd181a5f",
    "project_id": "863c320e-351f-4c24-8d0c-736db363c471",
    "project_name": "Harbor Compliance",
    "assignee_id": "ffd51aba-7b83-4a70-aa6f-101fba0e78ee",
    "assignee_name": "Paloma Petrov",
    "title": "Update docs",
 
…
Schema

What’s inside.

Denormalized rows for CSV/SQL, plus linked tables when you request a JSON bundle.

task_iduuid

Unique task identifier

project_iduuid

Parent project foreign key

project_namestring

Project display name

assignee_iduuid

Assignee foreign key

assignee_namestring

Assignee full name

titlestring

Task title

statusstring

Task status

prioritystring

Task priority

due_atdate

Due date

Bundle tables

projects

project_iduuid

Unique project identifier

namestring

Project name

statusstring

Project status

assignees

assignee_iduuid

Unique assignee identifier

namestring

Assignee full name

emailemail

Assignee email

rolestring

Team role

tasks

task_iduuid

Unique task identifier

project_iduuid

Project foreign key

assignee_iduuid

Assignee foreign key

titlestring

Task title

statusstring

Task status

prioritystring

Task priority

due_atdate

Due date