This repository has no description
1-- AI-solve questionnaires: one cached JSON tree per issue (engine GET /questionnaire).
2
3create table if not exists public.tangled_issue_questionnaires (
4 issue_uri text primary key,
5 payload jsonb not null,
6 created_at timestamptz not null default now(),
7 updated_at timestamptz not null default now(),
8 constraint tangled_issue_questionnaires_payload_is_object
9 check (jsonb_typeof(payload) = 'object')
10);
11
12comment on table public.tangled_issue_questionnaires is
13 'Cached branching questionnaire JSON per sh.tangled.repo.issue AT-URI (AI-solve engine).';
14
15comment on column public.tangled_issue_questionnaires.issue_uri is
16 'at://…/sh.tangled.repo.issue/<rkey> — same key as tangled_issues.uri when indexed.';
17
18comment on column public.tangled_issue_questionnaires.payload is
19 'Full questionnaire object (version 2): introduction, items, followups tree.';
20
21create index if not exists tangled_issue_questionnaires_updated_at_idx
22 on public.tangled_issue_questionnaires (updated_at desc);
23
24create index if not exists tangled_issue_questionnaires_payload_gin_idx
25 on public.tangled_issue_questionnaires using gin (payload);