{title}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_500":501,"_502":503},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",166,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":20,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":20,"_35":36},"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","# 0003 — Audit columns and universal editability\n\n## Status\n\nAccepted — **partially superseded by ADR 0004** (see amendment at end). The\n_editability_ decision stands in full; the `*_by` columns and the link\ncreation-pair were removed once the events log (ADR 0004) became the source of\ntruth for provenance.\n\n## Context\n\nWe want to know who created and last changed every piece of user-authored data,\nand we want a uniform convention rather than ad-hoc timestamps per table. Today\nit is inconsistent: issues have `created_by`/`created_at`/`updated_at` but no\n`updated_by`; comments have only `author` + `created_at` and no edit operation\nat all.\n\n## Decision\n\nTwo rules, applied across the whole schema:\n\n1. **Entities carry all four audit columns**: `created_at`, `created_by`,\n `updated_at`, `updated_by`. Entities are the things a user authors and can\n later change — **Issue**, **Comment**, **Label**. Consequently, _every entity\n is editable_ (there is an update operation for each), including comments.\n `created_by`/`updated_by` hold Val Town handles.\n\n2. **Join / link rows carry only the creation pair**: `created_at` +\n `created_by` (surfaced with intent-revealing names, e.g.\n `assigned_at`/`assigned_by` on assignees, `linked_at`/`linked_by` on block\n edges). Links are immutable — a user _adds_ or _removes_ them, never _edits_\n one — so `updated_at`/`updated_by` would be meaningless.\n\nNaming: the Comment's `author` column is renamed **`created_by`** so the\nconvention is uniform (the author _is_ the creator).\n\n## Consequences\n\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\n cases.\n- `updated_at` combines with the \"touch\" rule (see CONTEXT.md): association\n changes 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)\n\nOnce the append-only events log (ADR 0004) was adopted, it became the source of\ntruth for _who_ did _what_ and _when_. That makes the `*_by` columns redundant —\nactor is derivable as the latest event for an entity. We therefore revised this\ndecision:\n\n- **Entities keep only `created_at` + `updated_at`** as denormalized columns —\n they drive hot-path listing and \"last activity\" sorting, which would otherwise\n require a `MAX(event_timestamp)` aggregate over the log on every render.\n- **`created_by` / `updated_by` columns are dropped.** The actor is derived from\n the events log, which is already loaded on the only screen that needs it (an\n entity's detail/timeline view).\n- **Link rows carry no audit columns at all** — assignees and block edges become\n bare relationship tuples; their provenance lives entirely in events.\n\nWhat stands unchanged from the original decision: **every entity (Issue,\nComment, Label) is editable**, including comments, and the Comment's old\n`author` column is gone (its creator is derived from the `comment.created`\nevent).\n","createdAt",["D",1783653141647],"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",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"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",{"_43":44,"_32":45,"_38":495,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":496,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":497,"_84":498,"_86":499,"_88":25},"tree",[295,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327],"files",[295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327],"counts",{"_285":63,"_286":188,"_287":63,"_288":289,"_290":291},"contents",[130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":278,"_32":279,"_30":280,"_151":-5,"_41":42,"_40":281,"_153":59,"_38":282,"_13":63,"_34":283,"_35":-5,"_24":25,"_158":-5,"_27":284},{"_43":271,"_32":272,"_30":273,"_151":-5,"_41":42,"_40":274,"_153":59,"_38":275,"_13":63,"_34":20,"_35":276,"_24":25,"_158":-5,"_27":277},{"_43":265,"_32":266,"_30":267,"_151":-5,"_41":42,"_40":268,"_153":25,"_38":269,"_13":63,"_34":20,"_35":263,"_24":25,"_158":-5,"_27":270},{"_43":258,"_32":259,"_30":260,"_151":-5,"_41":42,"_40":261,"_153":25,"_38":262,"_13":63,"_34":20,"_35":263,"_24":25,"_158":-5,"_27":264},{"_43":251,"_32":252,"_30":253,"_151":-5,"_41":42,"_40":254,"_153":25,"_38":255,"_13":188,"_34":20,"_35":256,"_24":25,"_158":-5,"_27":257},{"_43":243,"_32":244,"_30":245,"_151":-5,"_41":42,"_40":246,"_153":25,"_38":247,"_13":248,"_34":20,"_35":249,"_24":25,"_158":-5,"_27":250},{"_43":236,"_32":237,"_30":238,"_151":-5,"_41":42,"_40":239,"_153":25,"_38":240,"_13":188,"_34":156,"_35":241,"_24":25,"_158":-5,"_27":242},{"_43":228,"_32":229,"_30":230,"_151":-5,"_41":42,"_40":231,"_153":25,"_38":232,"_13":233,"_34":156,"_35":234,"_24":25,"_158":-5,"_27":235},{"_43":221,"_32":222,"_30":223,"_151":-5,"_41":42,"_40":224,"_153":25,"_38":225,"_13":63,"_34":156,"_35":226,"_24":25,"_158":-5,"_27":227},{"_43":214,"_32":215,"_30":216,"_151":-5,"_41":42,"_40":217,"_153":25,"_38":218,"_13":63,"_34":20,"_35":219,"_24":25,"_158":-5,"_27":220},{"_43":206,"_32":207,"_30":208,"_151":-5,"_41":42,"_40":209,"_153":25,"_38":210,"_13":211,"_34":156,"_35":212,"_24":25,"_158":-5,"_27":213},{"_43":198,"_32":199,"_30":200,"_151":-5,"_41":42,"_40":201,"_153":25,"_38":202,"_13":203,"_34":156,"_35":204,"_24":25,"_158":-5,"_27":205},{"_43":191,"_32":192,"_30":193,"_151":-5,"_41":42,"_40":194,"_153":25,"_38":195,"_13":63,"_34":156,"_35":196,"_24":25,"_158":-5,"_27":197},{"_43":183,"_32":184,"_30":185,"_151":-5,"_41":42,"_40":186,"_153":25,"_38":187,"_13":188,"_34":20,"_35":189,"_24":25,"_158":-5,"_27":190},{"_43":175,"_32":176,"_30":177,"_151":-5,"_41":42,"_40":178,"_153":25,"_38":179,"_13":180,"_34":156,"_35":181,"_24":25,"_158":-5,"_27":182},{"_43":167,"_32":168,"_30":57,"_151":-5,"_41":42,"_40":169,"_153":25,"_38":170,"_13":171,"_34":172,"_35":173,"_24":25,"_158":-5,"_27":174},{"_43":160,"_32":161,"_30":162,"_151":-5,"_41":42,"_40":155,"_153":25,"_38":163,"_13":164,"_34":156,"_35":165,"_24":25,"_158":-5,"_27":166},{"_43":148,"_32":149,"_30":150,"_151":-5,"_41":42,"_40":152,"_153":25,"_38":154,"_13":155,"_34":156,"_35":157,"_24":25,"_158":-5,"_27":159},"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",[149],"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",[161],"b64f3437-f4bc-4279-9ad6-786ec6cac581","main.ts",162,["D",1783653141198],10,"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",[168],"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 · v166