reqlanOverviewIdeasFilesCode filesClustersAttributesGraphPrint

Printable idea sheet

ideas_table

reqlan rq/indexer/sqlite-schema.rq:47

Katz 0.045

Table `ideas` stores one row per idea, one-liner, or ideaset.
Columns:
- `id` TEXT PRIMARY KEY
- `name` TEXT NOT NULL
- `kind` TEXT NOT NULL — `block` | `oneliner` | `ideaset` ( types.rs )
- `file_uri` TEXT NOT NULL — path relative to the owning base root
- `line_start` / `line_end` INTEGER NOT NULL
- `summary` TEXT NOT NULL
- `attributes_json` TEXT NOT NULL DEFAULT `'{}'`
- `content_hash` TEXT NOT NULL
- `git_created_at` / `git_modified_at` TEXT nullable
- `git_change_count` INTEGER nullable ( schema v4 )
Indexes: `idx_ideas_file(file_uri)`, `idx_ideas_name(name)`.
ideas_index_sqlite
git_dates_background_indexing

Interactive page: ideas_table