/** * Global-scope `cleo.db` — consolidated **nexus registry/identity** domain (6 tables). * * Part of the consolidated GLOBAL-scope `cleo.db` target shape authored for * SG-DB-SUBSTRATE-V2 (saga T11242, epic T11245/E2, task T11361). Target-shape * authoring only — physical names carry the `nexus_` domain prefix. The live * runtime modules `schema/nexus-schema.ts` + `schema/code-index.ts` keep their * UNPREFIXED / partially-prefixed names until the exodus migration (T11248) * swaps the substrate to this shape. * * ## Nexus code-graph residency move (ADR-090 · T11539 — REMOVED from here) * * The four per-project code/knowledge-graph tables — `nexus_nodes`, * `nexus_relations`, `nexus_contracts`, `nexus_code_index` (ADR-090 "Category A") * — were REMOVED from this GLOBAL module and now reside in PROJECT scope * (`../cleo-project/nexus-graph.ts`, T11538), dropping the `project_id` column * (scope is implicit in which project's `.cleo/cleo.db` is open). This reduces * the nexus GLOBAL table count from 10 → 6. The six tables retained here are the * genuinely-global "Category B" registry/identity tables (see below). Exodus * routes the four graph tables to PROJECT scope per * `../exodus/table-name-map.ts` (`NEXUS_GRAPH_PROJECT_TABLES`). * * ## Idempotent prefixer (AC1) * * The six retained tables: `nexus_audit_log` · `nexus_schema_meta` already carry * the recognized `nexus_` prefix and are NOT double-prefixed. The remaining four * bare tables gain the domain prefix at exodus: `project_registry` → * `nexus_project_registry` · `project_id_aliases` → `nexus_project_id_aliases` · * `user_profile` → `nexus_user_profile` · `sigils` → `nexus_sigils`. * * ## E10 typing applied * * - **§4 timestamps (Drizzle-Date non-conformers → TEXT ISO8601):** * `nexus_user_profile.{first_observed_at,last_reinforced_at}` and * `nexus_sigils.{created_at,updated_at}` were `integer({ mode:'timestamp' })` * (the 4 Date non-conformers in §4). They become canonical `text` ISO8601; * the matching `CHECK (col GLOB 'YYYY-MM-DD*')` ships as raw DDL at exodus. * - **§5b enum-like bare TEXT → `{ enum }`:** `nexus_sigils.role` → * `{ enum: SIGIL_ROLES }`. The const array below is minted in-module (no * cross-package contracts const exists) per §5b — the CHECK list derives from * the identifier, never a hand-typed literal. (`nexus_code_index.kind` → * `{ enum: CODE_INDEX_KINDS }` moved with the graph tables to * `../cleo-project/nexus-graph.ts`.) * * ## FK reconciliation to single-file Pattern A (AC4) * * The nexus source used soft FKs (plain `text` + `@cross-db` annotations) for * every cross-table reference; none crossed file boundaries via a real * `.references()`. Under the consolidated GLOBAL `cleo.db` they remain plain * `text` soft FKs: * - `nexus_project_id_aliases.canonical_id` → `nexus_project_registry` and * `nexus_audit_log.project_id` → `nexus_project_registry` stay soft because * the source never declared them as enforced FKs. * - cross-domain refs (`nexus_audit_log.session_id` → project-scope * `tasks_sessions`, `nexus_user_profile.derived_from_message_id` → * `conduit_session_messages`) point at the PROJECT-scope `cleo.db`, so they * CANNOT be native FKs — they remain soft TEXT, resolved by the nexus * accessor. No ATTACH; no cross-file FK. * * @task T11361 · T11539 (nexus graph residency removal) * @epic T11245 · T11535 (nexus residency) * @saga T11242 * @see ../cleo-project/nexus-graph.ts (the PROJECT-scope home of the 4 graph tables) * @see docs/migration/sqlite-schema-canonical.md §1 (D1″ · global counts) · §4 · §5b * @see docs/migration/sqlite-schema-columns.json (per-column affinity SSoT) * @see ../nexus-schema.ts · ../code-index.ts (the runtime source modules) * @see cleo docs fetch adr-090-nexus-graph-residency-split */ /** * Legal `nexus_sigils.role` values — the `.cant` agent role taxonomy. * * E10 §5b: `sigils.role` was bare `text('role')` (default `''`). The value is * the `role:` frontmatter field of a `.cant` agent file, parsed by * `nexus/sigil-sync.ts`. The legal set enumerated from the writer + canonical * seed roster (`project-orchestrator`, `project-dev-lead`, `project-*-worker`) * and the parsed-sigil fixtures (`subagent`, `specialist`). `''` is retained * because the column defaults to empty before a `.cant` role is associated. * * @task T11361 */ export declare const SIGIL_ROLES: readonly ["", "orchestrator", "lead", "worker", "subagent", "specialist", "validator"]; /** TypeScript union derived from {@link SIGIL_ROLES}. */ export type SigilRole = (typeof SIGIL_ROLES)[number]; /** * `nexus_project_registry` — central registry of all CLEO projects known to the * Nexus (one row per project). Bare `project_registry` → `nexus_project_registry` * under the AC1 idempotent prefixer. * * @task T11361 (target shape) · T5365 / T529 (original) */ export declare const nexusProjectRegistry: import("drizzle-orm/sqlite-core").SQLiteTableWithColumns<{ name: "nexus_project_registry"; schema: undefined; columns: { projectId: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; projectHash: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; projectPath: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; name: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; registeredAt: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; lastSeen: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; healthStatus: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; healthLastCheck: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; permissions: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; lastSync: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; taskCount: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "number int53"; data: number; driverParam: number; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}>; labelsJson: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; brainDbPath: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; tasksDbPath: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; lastIndexed: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; statsJson: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_registry"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; }; dialect: "sqlite"; }>; /** * `nexus_project_id_aliases` — maps legacy base64url(path) project IDs to their * canonical IDs (T9149 W5). Bare `project_id_aliases` → `nexus_project_id_aliases`. * * @task T11361 (target shape) · T9149 (original) */ export declare const nexusProjectIdAliases: import("drizzle-orm/sqlite-core").SQLiteTableWithColumns<{ name: "nexus_project_id_aliases"; schema: undefined; columns: { legacyId: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_id_aliases"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; canonicalId: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_id_aliases"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; createdAt: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_project_id_aliases"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; }; dialect: "sqlite"; }>; /** * `nexus_audit_log` — append-only audit log for all Nexus operations across * projects. Already domain-prefixed; the idempotent prefixer is a no-op. * * @task T11361 (target shape) · T5365 (original) */ export declare const nexusAuditLog: import("drizzle-orm/sqlite-core").SQLiteTableWithColumns<{ name: "nexus_audit_log"; schema: undefined; columns: { id: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; timestamp: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; action: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; projectHash: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; projectId: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; domain: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; operation: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; sessionId: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; requestId: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; source: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; gateway: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; success: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "number int53"; data: number; driverParam: number; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}>; durationMs: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "number int53"; data: number; driverParam: number; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}>; detailsJson: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; errorMessage: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_audit_log"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; }; dialect: "sqlite"; }>; /** * `nexus_schema_meta` — key-value schema-version tracking (single-table KV). * Already domain-prefixed. * * @task T11361 (target shape) · T5365 (original) */ export declare const nexusSchemaMeta: import("drizzle-orm/sqlite-core").SQLiteTableWithColumns<{ name: string; schema: undefined; columns: { readonly key: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: string; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; readonly value: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: string; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; }; dialect: "sqlite"; }>; /** * `nexus_user_profile` — global user identity / preference profile (PSYCHE * Wave 1, T1077). Bare `user_profile` → `nexus_user_profile`. * * E10 §4: `first_observed_at` / `last_reinforced_at` were * `integer({ mode:'timestamp' })` (Drizzle-Date non-conformers) — now canonical * TEXT ISO8601. * * @task T11361 (target shape) · T1077 (original) */ export declare const nexusUserProfile: import("drizzle-orm/sqlite-core").SQLiteTableWithColumns<{ name: "nexus_user_profile"; schema: undefined; columns: { traitKey: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_user_profile"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; traitValue: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_user_profile"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; confidence: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_user_profile"; dataType: "number double"; data: number; driverParam: number; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}>; source: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_user_profile"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; derivedFromMessageId: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_user_profile"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; firstObservedAt: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_user_profile"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; lastReinforcedAt: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_user_profile"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; reinforcementCount: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_user_profile"; dataType: "number int53"; data: number; driverParam: number; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}>; supersededBy: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_user_profile"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; }; dialect: "sqlite"; }>; /** * `nexus_sigils` — peer-card sigil identity layer for CANT agents (PSYCHE * Wave 8, T1148). Bare `sigils` → `nexus_sigils`. * * E10 §5b: `role` was bare `text('role')` → `{ enum: SIGIL_ROLES }`. * E10 §4: `created_at` / `updated_at` were `integer({ mode:'timestamp' })` * (Drizzle-Date non-conformers) — now canonical TEXT ISO8601. * * @task T11361 (target shape) · T1148 (original) */ export declare const nexusSigils: import("drizzle-orm/sqlite-core").SQLiteTableWithColumns<{ name: "nexus_sigils"; schema: undefined; columns: { peerId: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_sigils"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; cantFile: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_sigils"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; displayName: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_sigils"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; role: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_sigils"; dataType: "string enum"; data: "" | "orchestrator" | "lead" | "worker" | "subagent" | "specialist" | "validator"; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: ["", "orchestrator", "lead", "worker", "subagent", "specialist", "validator"]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; systemPromptFragment: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_sigils"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; capabilityFlags: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_sigils"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; createdAt: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_sigils"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; updatedAt: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "nexus_sigils"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; }; dialect: "sqlite"; }>; /** Row type for `nexus_project_registry` SELECT (target shape). */ export type NexusProjectRegistryRow = typeof nexusProjectRegistry.$inferSelect; /** Row type for `nexus_project_registry` INSERT (target shape). */ export type NewNexusProjectRegistryRow = typeof nexusProjectRegistry.$inferInsert; /** Row type for `nexus_project_id_aliases` SELECT (target shape). */ export type NexusProjectIdAliasRow = typeof nexusProjectIdAliases.$inferSelect; /** Row type for `nexus_project_id_aliases` INSERT (target shape). */ export type NewNexusProjectIdAliasRow = typeof nexusProjectIdAliases.$inferInsert; /** Row type for `nexus_audit_log` SELECT (target shape). */ export type NexusAuditLogRow = typeof nexusAuditLog.$inferSelect; /** Row type for `nexus_audit_log` INSERT (target shape). */ export type NewNexusAuditLogRow = typeof nexusAuditLog.$inferInsert; /** Row type for `nexus_schema_meta` SELECT (target shape). */ export type NexusSchemaMetaRow = typeof nexusSchemaMeta.$inferSelect; /** Row type for `nexus_schema_meta` INSERT (target shape). */ export type NewNexusSchemaMetaRow = typeof nexusSchemaMeta.$inferInsert; /** Row type for `nexus_user_profile` SELECT (target shape). */ export type NexusUserProfileRow = typeof nexusUserProfile.$inferSelect; /** Row type for `nexus_user_profile` INSERT (target shape). */ export type NewNexusUserProfileRow = typeof nexusUserProfile.$inferInsert; /** Row type for `nexus_sigils` SELECT (target shape). */ export type NexusSigilRow = typeof nexusSigils.$inferSelect; /** Row type for `nexus_sigils` INSERT (target shape). */ export type NewNexusSigilRow = typeof nexusSigils.$inferInsert; //# sourceMappingURL=nexus.d.ts.map