{title}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_356":357,"_358":359},"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",139,"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/adr/0003-audit-columns-and-editability.md","latestPath","fileId","ee76ee18-7bf2-11f1-8022-1607ee4eb77e","name","0003-audit-columns-and-editability.md","fileType","content","# 0003 — Audit columns and universal editability\n\n## Status\nAccepted — **partially superseded by ADR 0004** (see amendment at end). The\n*editability* decision stands in full; the `*_by` columns and the link creation-pair\nwere removed once the events log (ADR 0004) became the source of truth for provenance.\n\n## Context\nWe want to know who created and last changed every piece of user-authored data, and\nwe want a uniform convention rather than ad-hoc timestamps per table. Today it is\ninconsistent: issues have `created_by`/`created_at`/`updated_at` but no `updated_by`;\ncomments have only `author` + `created_at` and no edit operation at all.\n\n## Decision\nTwo rules, applied across the whole schema:\n\n1. **Entities carry all four audit columns**: `created_at`, `created_by`, `updated_at`,\n `updated_by`. Entities are the things a user authors and can later change — **Issue**,\n **Comment**, **Label**. Consequently, *every entity is editable* (there is an update\n operation for each), including comments. `created_by`/`updated_by` hold Val Town\n handles.\n\n2. **Join / link rows carry only the creation pair**: `created_at` + `created_by`\n (surfaced with intent-revealing names, e.g. `assigned_at`/`assigned_by` on\n assignees, `linked_at`/`linked_by` on block edges). Links are immutable — a user\n *adds* or *removes* them, never *edits* one — so `updated_at`/`updated_by` would be\n meaningless.\n\nNaming: the Comment's `author` column is renamed **`created_by`** so the convention is\nuniform (the author *is* the creator).\n\n## Consequences\n- Comment editing becomes a real, supported operation (mirrors GitHub).\n- Every table's provenance is queryable in a uniform way; no per-table special cases.\n- `updated_at` combines with the \"touch\" rule (see CONTEXT.md): association changes\n bump the parent issue's `updated_at` too.\n- Slightly more columns and write-path bookkeeping everywhere — accepted for the\n auditability and uniformity it buys.\n\n## Amendment (superseded in part by ADR 0004)\nOnce the append-only events log (ADR 0004) was adopted, it became the source of truth\nfor *who* did *what* and *when*. That makes the `*_by` columns redundant — actor is\nderivable as the latest event for an entity. We therefore revised this decision:\n\n- **Entities keep only `created_at` + `updated_at`** as denormalized columns — they\n drive hot-path listing and \"last activity\" sorting, which would otherwise require a\n `MAX(event_timestamp)` aggregate over the log on every render.\n- **`created_by` / `updated_by` columns are dropped.** The actor is derived from the\n events log, which is already loaded on the only screen that needs it (an entity's\n detail/timeline view).\n- **Link rows carry no audit columns at all** — assignees and block edges become bare\n relationship tuples; their provenance lives entirely in events.\n\nWhat stands unchanged from the original decision: **every entity (Issue, Comment,\nLabel) is editable**, including comments, and the Comment's old `author` column is\ngone (its creator is derived from the `comment.created` event).\n","createdAt",["D",1783641873810],"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":351,"_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":352,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":353,"_82":354,"_84":355,"_86":24},"tree",[252,259,260,261,262,263,264,265,266,267,268,269,270],"files",[252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270],"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 · v139