{title}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_419":420,"_421":422},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_106":88,"_26":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":57,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",146,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","docs/issues/richer-data-model/tickets.md","latestPath","fileId","eeb0130a-7bf2-11f1-8022-1607ee4eb77e","name","tickets.md","fileType","content","# Tickets: Richer data model for val-issue-tracker\n\nTracer-bullet tickets implementing the richer data model. Source spec:\n`docs/issues/richer-data-model/PRD.md`. Governed by `CONTEXT.md` + ADRs 0001–0004.\n\nAll tickets are `ready-for-agent` — agent-grabbable by construction.\n\nWork the **frontier**: any ticket whose blockers are all done. Order here is\ndependency order (blockers first): 1 → 2 → 3 → then 4 and 5 in parallel.\n\n> Migration caveat: tickets 1–3 are correct against *fresh* databases. The ~3\n> existing deployments are only safe to run once ticket 4 (migration) lands, since\n> `initSchema` runs against live data every request. Deploy the set at the end.\n\n## 1. Core schema reshape + issue lifecycle\n\nStatus: ready-for-agent\n\n**What to build:** Fresh-install issue schema on the new model — priority removed\nentirely; `status` collapses to `open`/`closed`; a nullable `state_reason`\n(`completed`/`not_planned`/`duplicate`/`reopened`) guarded by a `CHECK` constraint\nagainst status; the issue body field renamed from `description` to `body`. The\ncreate / close / reopen operations auto-manage `state_reason` (create → null; close →\nchosen reason, default `completed`; reopen → `reopened`). The JSON API and HTML UI are\nreconciled to the new `Issue` shape, and the schema knowledge those two consumers\ncurrently duplicate (status/priority constants, label parse/serialize) is pulled into\nthe data-access layer as a prefactor so later tickets change one place. No migration of\nexisting data in this ticket. *Demoable: create an issue, close it as not_planned,\nreopen it — through both the API and the UI.*\n\n**Blocked by:** None — can start immediately.\n\n## 2. Events log foundation + issue lifecycle events\n\nStatus: ready-for-agent\n\n**What to build:** The single append-only events table (`id`, `event_type`,\n`entity_id`, `actor`, `data`, `event_timestamp`) and the emit helper, wired into the\nissue lifecycle from ticket 1. `*.created` and `*.deleted` carry full state snapshots;\n`*.updated` carries `{ update_target, from, to }`. One event per changed field, so\nclosing emits two events (`status` and `state_reason`) sharing an actor and timestamp.\n*Demoable: close an issue and observe two events with the acting handle and correct\npayloads.*\n\n**Blocked by:** 1\n\n## 3. Associations: labels + assignees + blocking\n\nStatus: ready-for-agent\n\n**What to build:** All three issue relationships, end-to-end (schema + operations + API\n+ UI + events + touch rule):\n\n- **Labels** — a curated Label entity (`name`, `color`), applied via a bare issue↔label\n join; a default set (`bug`, `enhancement`, `documentation`, `question`, `duplicate`)\n seeded exactly once at table creation and never re-seeded; apply/remove; label\n rename/recolour/delete (deleting an in-use label cascades its join rows away).\n- **Assignees** — a set of Val Town users via a bare issue↔handle join; add/remove;\n an \"assigned to me\" query.\n- **Blocking** — a directed `blocker → blocked` edge stored once; insert rejected if the\n target can already reach the source (strict DAG — self, reciprocal, and longer cycles\n all refused); remove; \"blocked\" derived (blocked while any blocker is still open) and\n never stored, and never gating close.\n\nEvery mutation emits its events — label ops as `label.*` plus `issue.updated` with\n`update_target: label` using `null ↔ value`; assignee and block changes as\n`issue.updated` with `update_target` ∈ {assignee, blocks, blocked_by}, `null ↔ value`;\na block edge writes one event on the acting issue. Every association change also touches\nthe parent issue's `updated_at`.\n\n*(Largest ticket — if it overflows a single context window at execution time, split back\ninto labels / assignees / blocking, each blocked by 1 and 2.)*\n\n**Blocked by:** 1, 2\n\n## 4. Migration for existing deployments\n\nStatus: ready-for-agent\n\n**What to build:** One idempotent migration routine (living in the schema-init path,\nsafe to run every request) that brings the ~3 existing deployments onto the final\nschema: remap any `in_progress` issue to `open`; drop priority; expose the old\n`description` as `body`; lift each existing JSON `labels` array into the Label entities\nand issue↔label join (creating labels as needed); move any existing single `assignee`\ninto the assignee join; and backfill a synthetic `*.created` event (and any required\nstate) for existing rows so no entity is left without provenance. Running it twice is a\nno-op.\n\n**Blocked by:** 1, 2, 3\n\n## 5. Rewrite JSON API convention doc + final cleanup\n\nStatus: ready-for-agent\n\n**What to build:** Rewrite `docs/issue-tracker-valtown.md` to the new schema and\nendpoint surface (no priority, two statuses, `state_reason` on close/reopen, and the\nlabel / assignee / block operations), replacing the outdated convention it documents\ntoday. Remove any remaining old-schema constants or dead code paths in the consumers.\nDone last so the doc describes the final API exactly once.\n\n**Blocked by:** 3\n","createdAt",["D",1783641874195],"branchVersion","branchId","b6817ee5-03f4-41f2-901e-1bb2efa16e9e","id","abe99189-4851-4aab-ae08-280f66283cac","val-issue-tracker",["D",1783563523910],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Per-val issue tracker — import into any val for scoped issues","imageUrl","5d1042a9-7b0b-499d-8a72-3a8ac7a4e185","pinnedFileId","d1d90306-7b3c-11f1-b527-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","5f80108f-7ca4-4327-b77b-089dbe4b5a82","tursoName","abe9918948514aabae08280f66283cac","tursoHostname","abe9918948514aabae08280f66283cac-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525245864],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":53,"_102":103,"_104":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"isOwned",369,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nbbaier","handle","displayName","avatar","https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":414,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":415,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":416,"_82":417,"_84":418,"_86":24},"tree",[252,266,267,268,269,270,271,272,273,274,275,276,277],"files",[252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277],"counts",{"_241":61,"_242":243,"_244":61,"_245":246,"_247":248},"contents",[128,129,130,131,132,133,134,135,136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":234,"_31":235,"_29":236,"_144":-5,"_39":40,"_38":237,"_146":57,"_36":238,"_13":61,"_33":239,"_34":-5,"_23":24,"_151":-5,"_26":240},{"_41":227,"_31":228,"_29":229,"_144":-5,"_39":40,"_38":230,"_146":57,"_36":231,"_13":61,"_33":20,"_34":232,"_23":24,"_151":-5,"_26":233},{"_41":219,"_31":220,"_29":221,"_144":-5,"_39":40,"_38":222,"_146":24,"_36":223,"_13":224,"_33":20,"_34":225,"_23":24,"_151":-5,"_26":226},{"_41":212,"_31":213,"_29":214,"_144":-5,"_39":40,"_38":215,"_146":24,"_36":216,"_13":61,"_33":149,"_34":217,"_23":24,"_151":-5,"_26":218},{"_41":205,"_31":206,"_29":207,"_144":-5,"_39":40,"_38":208,"_146":24,"_36":209,"_13":164,"_33":149,"_34":210,"_23":24,"_151":-5,"_26":211},{"_41":198,"_31":199,"_29":200,"_144":-5,"_39":40,"_38":201,"_146":24,"_36":202,"_13":61,"_33":20,"_34":203,"_23":24,"_151":-5,"_26":204},{"_41":190,"_31":191,"_29":192,"_144":-5,"_39":40,"_38":193,"_146":24,"_36":194,"_13":195,"_33":149,"_34":196,"_23":24,"_151":-5,"_26":197},{"_41":183,"_31":184,"_29":185,"_144":-5,"_39":40,"_38":186,"_146":24,"_36":187,"_13":173,"_33":149,"_34":188,"_23":24,"_151":-5,"_26":189},{"_41":176,"_31":177,"_29":178,"_144":-5,"_39":40,"_38":179,"_146":24,"_36":180,"_13":61,"_33":20,"_34":181,"_23":24,"_151":-5,"_26":182},{"_41":168,"_31":169,"_29":170,"_144":-5,"_39":40,"_38":171,"_146":24,"_36":172,"_13":173,"_33":149,"_34":174,"_23":24,"_151":-5,"_26":175},{"_41":160,"_31":161,"_29":55,"_144":-5,"_39":40,"_38":162,"_146":24,"_36":163,"_13":164,"_33":165,"_34":166,"_23":24,"_151":-5,"_26":167},{"_41":153,"_31":154,"_29":155,"_144":-5,"_39":40,"_38":148,"_146":24,"_36":156,"_13":157,"_33":149,"_34":158,"_23":24,"_151":-5,"_26":159},{"_41":141,"_31":142,"_29":143,"_144":-5,"_39":40,"_38":145,"_146":24,"_36":147,"_13":148,"_33":149,"_34":150,"_23":24,"_151":-5,"_26":152},"2e20d1fd-693a-4de7-9d91-071f7adc7b7a","ui.tsx","fca19e20-7b48-11f1-8cf9-1607ee4eb77e","parentId",122,"latest",["D",1783574778713],30,"script","/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC, PropsWithChildren } from \"npm:hono@4.6.14/jsx\";\nimport type { IssuePriority, IssueStatus } from \"./db.ts\";\n\n// ---------------------------------------------------------------------------\n// Design tokens\n// ---------------------------------------------------------------------------\n\nexport const FIELD =\n\t\"bg-[#1f232c] border border-[#2a2f3a] rounded-md h-10 pl-3.5 pr-10 text-sm leading-none font-medium text-[#e6e9ef] focus:outline-none focus:border-[#6ea8fe] appearance-none\";\n\n// text-sm/leading-none/appearance-none pin font metrics and native chrome\n// explicitly — \n\t);\n};\n\n// A \n\t\t{/* right-[13px] centers the 16px chevron box within FIELD's 40px right\n\t\t\tpadding: (40 - 16) / 2 = 12px from the inner edge, + 1px because the\n\t\t\toffset is measured from the outer border edge = 13px. This equalizes\n\t\t\tthe text→chevron gap with the chevron→edge gap. */}\n\t\t\n\t\t\t\n\t\t\n\t\n);\n\nexport const Banner: FC<{ kind: \"ok\" | \"err\"; msg: string }> = ({\n\tkind,\n\tmsg,\n}) => (\n\t\n\t\t{msg}\n\t\n);\n\nexport const StatusBadge: FC<{ status: IssueStatus }> = ({ status }) => (\n\t\n\t\t{STATUS_LABELS[status]}\n\t\n);\n\nexport const PriorityBadge: FC<{ priority: IssuePriority }> = ({\n\tpriority,\n}) => (\n\t\n\t\t{PRIORITY_LABELS[priority]}\n\t\n);\n\nexport const LabelTag: FC<{ label: string }> = ({ label }) => (\n\t\n\t\t{label}\n\t\n);\n","label",[142],"cd8a9ea8-1579-4629-9a43-c9a3525477d5","mod.ts","d1e3fc5c-7b3c-11f1-af1c-1607ee4eb77e",["D",1783568883064],11,"export {\n\tcreateIssueTracker,\n\tdefault,\n\ttype IssueTrackerOptions,\n} from \"./app.tsx\";\n",[154],"436eb8dd-247c-49b2-828b-efc41b7321e8","main.ts",63,["D",1783571917437],7,"http","import { createIssueTracker } from \"./mod.ts\";\n\n/**\n * This val's own issue tracker — manages THIS val's scoped SQLite database.\n *\n * To add issues to a DIFFERENT val, import the tracker into that val:\n *\n * import { createIssueTracker } from \"https://esm.town/v/nbbaier/val-issue-tracker/mod.ts\";\n * export default createIssueTracker({ owner: [\"nbbaier\"] });\n *\n * Because scoped SQLite is bound to the running val, the imported tracker\n * reads/writes the host val's database automatically — no per-val config needed.\n */\nexport default createIssueTracker({});\n",[161],"17e2256d-d27b-4705-aa51-8a95e016e3e4","layout.tsx","fd6015ee-7b48-11f1-bafe-1607ee4eb77e",107,["D",1783574315459],2,"/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC, PropsWithChildren } from \"npm:hono@4.6.14/jsx\";\n\nexport const Layout: FC<\n\tPropsWithChildren<{\n\t\ttitle: string;\n\t\tuser?: string | null;\n\t\tauth?: boolean;\n\t}>\n> = ({ title, user, auth = true, children }) => (\n\t\n\t\t\n\t\t\t\n\t\t\t\n\t\t\t{title}\n\t\t\t

Diff · v146