Overskill / LearningReturn to the staff-A exercise →

SEPARATE FULL TEACHING KEY

Six supplied projects.
Five in the staff view.

S-A1 is stipulated to belong to Workspace A and to be assigned P101–P105. P106 belongs to B and stays outside that five-project output.

Both workspaces are fictional teaching data. Separating this key from the staff projection does not implement real authorization.

The exact before / after relation map

The staff-A denominator is five: one eligible proposal, two holds, one unknown/hold and one already archived. Only P101.archived changes from false to true. All six project IDs, seven task IDs, five present deliverable IDs, seven revisions, six approvals and thirteen task events remain.

The diagram is a readable overview. On a narrow screen, scroll within it; the same six paths and exact records are available below.

Six project paths with tasks, deliverables and revision-specific approvals. P104 ends at missing D104; P106 is outside staff A. Complete text equivalent follows.

Download the relation diagram (SVG)

P101 · WORKSPACE A

Workshop display

Eligible · only archive flag changes

T101, T102 · Done → D101 · current R2 → AP-D101-R2 → D101-R2

Earlier D101-R1 → AP-D101-R1 stays retained.

Read this project’s exact supplied task and deliverable records
{
  "project": {
    "id": "P101",
    "workspace_id": "A",
    "title": "Workshop display",
    "phase": "Completed",
    "archived": false,
    "assigned_staff_ids": [
      "S-A1"
    ],
    "task_ids": [
      "T101",
      "T102"
    ],
    "current_deliverable_id": "D101",
    "task_inventory": "complete_for_this_authored_snapshot",
    "completion_label_recorded_at": "2026-11-03T12:00:00Z"
  },
  "tasks": [
    {
      "id": "T101",
      "project_id": "P101",
      "workspace_id": "A",
      "deliverable_id": "D101",
      "state": "Done",
      "request_text": "Draft workshop artwork",
      "assigned_staff_id": "S-A1",
      "history": [
        {
          "event_id": "E-T101-created",
          "event": "request_recorded",
          "actor_id": "C-A1",
          "at": "2026-11-01T09:00:00Z",
          "text": "Draft workshop artwork"
        },
        {
          "event_id": "E-T101-done",
          "event": "marked_done",
          "actor_id": "S-A1",
          "at": "2026-11-03T10:00:00Z",
          "text": "Fictional completion record for this task."
        }
      ]
    },
    {
      "id": "T102",
      "project_id": "P101",
      "workspace_id": "A",
      "deliverable_id": "D101",
      "state": "Done",
      "request_text": "Prepare revised display artwork",
      "assigned_staff_id": "S-A1",
      "history": [
        {
          "event_id": "E-T102-created",
          "event": "request_recorded",
          "actor_id": "C-A1",
          "at": "2026-11-01T09:00:00Z",
          "text": "Prepare revised display artwork"
        },
        {
          "event_id": "E-T102-done",
          "event": "marked_done",
          "actor_id": "S-A1",
          "at": "2026-11-03T10:00:00Z",
          "text": "Fictional completion record for this task."
        }
      ]
    }
  ],
  "deliverable": {
    "id": "D101",
    "project_id": "P101",
    "workspace_id": "A",
    "current_revision_id": "D101-R2",
    "current_approval_id": "AP-D101-R2",
    "revisions": [
      {
        "revision_id": "D101-R1",
        "number": 1,
        "created_by": "S-A1",
        "created_at": "2026-11-02T09:00:00Z",
        "artifact_text": "Initial fictional artwork for P101."
      },
      {
        "revision_id": "D101-R2",
        "number": 2,
        "created_by": "S-A1",
        "created_at": "2026-11-03T09:00:00Z",
        "artifact_text": "Revised fictional artwork for P101."
      }
    ],
    "approvals": [
      {
        "approval_id": "AP-D101-R1",
        "revision_id": "D101-R1",
        "decision": "Approved",
        "actor_id": "C-A1",
        "at": "2026-11-02T11:00:00Z",
        "note": "Authored sample decision for this exact revision."
      },
      {
        "approval_id": "AP-D101-R2",
        "revision_id": "D101-R2",
        "decision": "Approved",
        "actor_id": "C-A1",
        "at": "2026-11-03T11:00:00Z",
        "note": "Authored sample decision for this exact revision."
      }
    ]
  }
}

P102 · WORKSPACE A

Festival poster

Hold · linked work is Open

T103 · Open → D102 · current R1 → AP-D102-R1 → D102-R1

Completed does not override an Open task.

Read this project’s exact supplied task and deliverable records
{
  "project": {
    "id": "P102",
    "workspace_id": "A",
    "title": "Festival poster",
    "phase": "Completed",
    "archived": false,
    "assigned_staff_ids": [
      "S-A1"
    ],
    "task_ids": [
      "T103"
    ],
    "current_deliverable_id": "D102",
    "task_inventory": "complete_for_this_authored_snapshot",
    "completion_label_recorded_at": "2026-11-03T12:00:00Z"
  },
  "tasks": [
    {
      "id": "T103",
      "project_id": "P102",
      "workspace_id": "A",
      "deliverable_id": "D102",
      "state": "Open",
      "request_text": "Resolve poster text request",
      "assigned_staff_id": "S-A1",
      "history": [
        {
          "event_id": "E-T103-created",
          "event": "request_recorded",
          "actor_id": "C-A1",
          "at": "2026-11-01T09:00:00Z",
          "text": "Resolve poster text request"
        }
      ]
    }
  ],
  "deliverable": {
    "id": "D102",
    "project_id": "P102",
    "workspace_id": "A",
    "current_revision_id": "D102-R1",
    "current_approval_id": "AP-D102-R1",
    "revisions": [
      {
        "revision_id": "D102-R1",
        "number": 1,
        "created_by": "S-A1",
        "created_at": "2026-11-02T09:00:00Z",
        "artifact_text": "Initial fictional artwork for P102."
      }
    ],
    "approvals": [
      {
        "approval_id": "AP-D102-R1",
        "revision_id": "D102-R1",
        "decision": "Approved",
        "actor_id": "C-A1",
        "at": "2026-11-02T11:00:00Z",
        "note": "Authored sample decision for this exact revision."
      }
    ]
  }
}

P103 · WORKSPACE A

Bookshop cards

Hold · approval covers older R1

T104 · Done → D103 · current R2 → AP-D103-R1 → D103-R1

R2 has no supplied current-revision approval.

Read this project’s exact supplied task and deliverable records
{
  "project": {
    "id": "P103",
    "workspace_id": "A",
    "title": "Bookshop cards",
    "phase": "Completed",
    "archived": false,
    "assigned_staff_ids": [
      "S-A1"
    ],
    "task_ids": [
      "T104"
    ],
    "current_deliverable_id": "D103",
    "task_inventory": "complete_for_this_authored_snapshot",
    "completion_label_recorded_at": "2026-11-03T12:00:00Z"
  },
  "tasks": [
    {
      "id": "T104",
      "project_id": "P103",
      "workspace_id": "A",
      "deliverable_id": "D103",
      "state": "Done",
      "request_text": "Prepare revised bookshop cards",
      "assigned_staff_id": "S-A1",
      "history": [
        {
          "event_id": "E-T104-created",
          "event": "request_recorded",
          "actor_id": "C-A1",
          "at": "2026-11-01T09:00:00Z",
          "text": "Prepare revised bookshop cards"
        },
        {
          "event_id": "E-T104-done",
          "event": "marked_done",
          "actor_id": "S-A1",
          "at": "2026-11-03T10:00:00Z",
          "text": "Fictional completion record for this task."
        }
      ]
    }
  ],
  "deliverable": {
    "id": "D103",
    "project_id": "P103",
    "workspace_id": "A",
    "current_revision_id": "D103-R2",
    "current_approval_id": "AP-D103-R1",
    "revisions": [
      {
        "revision_id": "D103-R1",
        "number": 1,
        "created_by": "S-A1",
        "created_at": "2026-11-02T09:00:00Z",
        "artifact_text": "Initial fictional artwork for P103."
      },
      {
        "revision_id": "D103-R2",
        "number": 2,
        "created_by": "S-A1",
        "created_at": "2026-11-03T09:00:00Z",
        "artifact_text": "Revised fictional artwork for P103."
      }
    ],
    "approvals": [
      {
        "approval_id": "AP-D103-R1",
        "revision_id": "D103-R1",
        "decision": "Approved",
        "actor_id": "C-A1",
        "at": "2026-11-02T11:00:00Z",
        "note": "Authored sample decision for this exact revision."
      }
    ]
  }
}

P104 · WORKSPACE A

Studio window

Unknown / hold · preserve the gap

T105 · Done → D104 · MISSING → Revision / approval unknown

The D104 reference remains; no child is fabricated.

Read this project’s exact supplied task and deliverable records
{
  "project": {
    "id": "P104",
    "workspace_id": "A",
    "title": "Studio window",
    "phase": "Completed",
    "archived": false,
    "assigned_staff_ids": [
      "S-A1"
    ],
    "task_ids": [
      "T105"
    ],
    "current_deliverable_id": "D104",
    "task_inventory": "complete_for_this_authored_snapshot",
    "completion_label_recorded_at": "2026-11-03T12:00:00Z"
  },
  "tasks": [
    {
      "id": "T105",
      "project_id": "P104",
      "workspace_id": "A",
      "deliverable_id": "D104",
      "state": "Done",
      "request_text": "Prepare window artwork",
      "assigned_staff_id": "S-A1",
      "history": [
        {
          "event_id": "E-T105-created",
          "event": "request_recorded",
          "actor_id": "C-A1",
          "at": "2026-11-01T09:00:00Z",
          "text": "Prepare window artwork"
        },
        {
          "event_id": "E-T105-done",
          "event": "marked_done",
          "actor_id": "S-A1",
          "at": "2026-11-03T10:00:00Z",
          "text": "Fictional completion record for this task."
        }
      ]
    }
  ],
  "deliverable": {
    "referenced_id": "D104",
    "record": "Missing; not fabricated"
  }
}

P105 · WORKSPACE A

Sample booklet

Already archived · unchanged

T106 · Done → D105 · current R1 → AP-D105-R1 → D105-R1

No second transition; reopened-work policy stays separate.

Read this project’s exact supplied task and deliverable records
{
  "project": {
    "id": "P105",
    "workspace_id": "A",
    "title": "Sample booklet",
    "phase": "Completed",
    "archived": true,
    "assigned_staff_ids": [
      "S-A1"
    ],
    "task_ids": [
      "T106"
    ],
    "current_deliverable_id": "D105",
    "task_inventory": "complete_for_this_authored_snapshot",
    "completion_label_recorded_at": "2026-11-03T12:00:00Z"
  },
  "tasks": [
    {
      "id": "T106",
      "project_id": "P105",
      "workspace_id": "A",
      "deliverable_id": "D105",
      "state": "Done",
      "request_text": "Assemble sample booklet",
      "assigned_staff_id": "S-A1",
      "history": [
        {
          "event_id": "E-T106-created",
          "event": "request_recorded",
          "actor_id": "C-A1",
          "at": "2026-11-01T09:00:00Z",
          "text": "Assemble sample booklet"
        },
        {
          "event_id": "E-T106-done",
          "event": "marked_done",
          "actor_id": "S-A1",
          "at": "2026-11-03T10:00:00Z",
          "text": "Fictional completion record for this task."
        }
      ]
    }
  ],
  "deliverable": {
    "id": "D105",
    "project_id": "P105",
    "workspace_id": "A",
    "current_revision_id": "D105-R1",
    "current_approval_id": "AP-D105-R1",
    "revisions": [
      {
        "revision_id": "D105-R1",
        "number": 1,
        "created_by": "S-A1",
        "created_at": "2026-11-02T09:00:00Z",
        "artifact_text": "Initial fictional artwork for P105."
      }
    ],
    "approvals": [
      {
        "approval_id": "AP-D105-R1",
        "revision_id": "D105-R1",
        "decision": "Approved",
        "actor_id": "C-A1",
        "at": "2026-11-02T11:00:00Z",
        "note": "Authored sample decision for this exact revision."
      }
    ]
  }
}

P106 · WORKSPACE B

Other-workspace banner

Full key only · outside staff A

T107 · Done → D106 · current R1 → AP-D106-R1 → D106-R1

Retained here; excluded before forming the staff-A projection.

Read this project’s exact supplied task and deliverable records
{
  "project": {
    "id": "P106",
    "workspace_id": "B",
    "title": "Other-workspace banner",
    "phase": "Completed",
    "archived": false,
    "assigned_staff_ids": [
      "S-B1"
    ],
    "task_ids": [
      "T107"
    ],
    "current_deliverable_id": "D106",
    "task_inventory": "complete_for_this_authored_snapshot",
    "completion_label_recorded_at": "2026-11-03T12:00:00Z"
  },
  "tasks": [
    {
      "id": "T107",
      "project_id": "P106",
      "workspace_id": "B",
      "deliverable_id": "D106",
      "state": "Done",
      "request_text": "Prepare banner artwork",
      "assigned_staff_id": "S-B1",
      "history": [
        {
          "event_id": "E-T107-created",
          "event": "request_recorded",
          "actor_id": "C-B1",
          "at": "2026-11-01T09:00:00Z",
          "text": "Prepare banner artwork"
        },
        {
          "event_id": "E-T107-done",
          "event": "marked_done",
          "actor_id": "S-B1",
          "at": "2026-11-03T10:00:00Z",
          "text": "Fictional completion record for this task."
        }
      ]
    }
  ],
  "deliverable": {
    "id": "D106",
    "project_id": "P106",
    "workspace_id": "B",
    "current_revision_id": "D106-R1",
    "current_approval_id": "AP-D106-R1",
    "revisions": [
      {
        "revision_id": "D106-R1",
        "number": 1,
        "created_by": "S-B1",
        "created_at": "2026-11-02T09:00:00Z",
        "artifact_text": "Initial fictional artwork for P106."
      }
    ],
    "approvals": [
      {
        "approval_id": "AP-D106-R1",
        "revision_id": "D106-R1",
        "decision": "Approved",
        "actor_id": "C-B1",
        "at": "2026-11-02T11:00:00Z",
        "note": "Authored sample decision for this exact revision."
      }
    ]
  }
}

Inspect the immutable expected records.

Task request context and the supplied revision/approval histories are preserved. The P101 path is archive → P101 → T102 → D101 → current D101-R2 / AP-D101-R2, then historical D101-R1 / AP-D101-R1. The local exercise demonstrates these lookups in supplied records; actual app history retrieval is untested.

Archive changes list membership. No delete, restore, legal-retention, backup, storage-saving or platform-feature claim is made. Missing D104 stays missing. A task reopened before archive fails the rule; work opened after archive leaves an unresolved policy question.