generated from coulomb/repo-seed
Bernd Worsch
2605c1c977
Some checks failed
Test / test (push) Has been cancelled
Adds bounded AI support to the IHF governance loop. All AI outputs are attributed (model_ref), reviewable (AgentReviewRecord), and reversible. No autonomous decisions; no silent requirement promotion. - T01: Schema — agent_proposals, agent_review_records, confidence_annotations (migration 1743379200) - T02: AgentProposalsController (index/show/accept/reject, idempotent review guard), global nav "Agent" link - T03: SummarizeClusterAction — Claude API cluster summary on widget show - T04: DraftRequirementAction — AI requirement draft; acceptance creates RequirementCandidate (human-gated) - T05: DetectDuplicatesAction — duplicate_flag proposal on candidate show - T06: DetectPolicySensitivityAction — policy_flag with ConfidenceAnnotations per concern scope - T07: ProposeImplementationAction — impl_proposal from decision show - T08: AgentAuditDashboardAction — autoRefresh; KPI row, unreviewed queue, recent proposals, attribution log matrix - T09: integration tests, SCOPE.md updated, phase5-summary.md, flake.nix adds http-conduit/aeson/string-conversions Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
45 lines
2.0 KiB
SQL
45 lines
2.0 KiB
SQL
-- Phase 5: Agent-Assisted Distillation and Suggestion
|
|
-- AgentProposal, AgentReviewRecord, ConfidenceAnnotation
|
|
|
|
CREATE TABLE agent_proposals (
|
|
id UUID DEFAULT uuid_generate_v4() PRIMARY KEY NOT NULL,
|
|
proposal_type TEXT NOT NULL,
|
|
source_widget_id UUID REFERENCES widgets(id) ON DELETE SET NULL,
|
|
source_candidate_id UUID REFERENCES requirement_candidates(id) ON DELETE SET NULL,
|
|
source_thread_id UUID REFERENCES annotation_threads(id) ON DELETE SET NULL,
|
|
source_decision_id UUID REFERENCES decision_records(id) ON DELETE SET NULL,
|
|
content TEXT NOT NULL,
|
|
model_ref TEXT NOT NULL,
|
|
confidence NUMERIC CHECK (confidence BETWEEN 0 AND 1),
|
|
status TEXT NOT NULL DEFAULT 'pending',
|
|
created_at TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL
|
|
);
|
|
|
|
CREATE INDEX agent_proposals_proposal_type_idx ON agent_proposals (proposal_type);
|
|
CREATE INDEX agent_proposals_status_idx ON agent_proposals (status);
|
|
CREATE INDEX agent_proposals_source_widget_id_idx ON agent_proposals (source_widget_id);
|
|
CREATE INDEX agent_proposals_created_at_idx ON agent_proposals (created_at DESC);
|
|
|
|
CREATE TABLE agent_review_records (
|
|
id UUID DEFAULT uuid_generate_v4() PRIMARY KEY NOT NULL,
|
|
proposal_id UUID NOT NULL REFERENCES agent_proposals(id) ON DELETE CASCADE,
|
|
reviewer_id UUID REFERENCES users(id),
|
|
decision TEXT NOT NULL,
|
|
notes TEXT,
|
|
reviewed_at TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL,
|
|
UNIQUE (proposal_id)
|
|
);
|
|
|
|
CREATE INDEX agent_review_records_proposal_id_idx ON agent_review_records (proposal_id);
|
|
|
|
CREATE TABLE confidence_annotations (
|
|
id UUID DEFAULT uuid_generate_v4() PRIMARY KEY NOT NULL,
|
|
proposal_id UUID NOT NULL REFERENCES agent_proposals(id) ON DELETE CASCADE,
|
|
dimension TEXT NOT NULL,
|
|
score NUMERIC NOT NULL CHECK (score BETWEEN 0 AND 1),
|
|
explanation TEXT,
|
|
created_at TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL
|
|
);
|
|
|
|
CREATE INDEX confidence_annotations_proposal_id_idx ON confidence_annotations (proposal_id);
|