Schema

_archivesourcetypescript
Path: _archive/loom-stale-pre-sprint-snapshot/src/db/schema.tsRelative: loom-stale-pre-sprint-snapshot/src/db/schema.tsSubproject: _archiveCategory: archived
Lines: 108Bytes: 3,990Imports: 1Exports: 7
_archivesourcetypescriptloom-stale-pre-sprint-snapshotsrcdb

Content Preview

  1. import { sqliteTable, text, integer, index } from "drizzle-orm/sqlite-core";
  3. /**
  4. * 7-table D1 schema — mirrors LOOM-SPEC-001 §D1 1:1.
  5. * SQLite semantics identical local (wrangler dev --persist-to) and edge (D1).
  6. * JSON columns hold contract-validated payloads; the contract layer (ajv)
  7. * is the gate, the DB stores what passed it.
  8. */
  10. export const goals = sqliteTable("goals", {
  11. goalId: text("goal_id").primaryKey(),
  12. originalSpec: text("original_spec").notNull(),
  13. specHash: text("spec_has