PVA-SLICE-01 Schema Addendum — M-02B Corrections
internal prototype · canonical JSON + Dreamborn Forge HTML
internal generated
schema-addendum · supabase_json

PVA-SLICE-01 Schema Addendum — M-02B Corrections

schema-addendum artifact · for Patient Visit Advocate · phase M-02B · status approved

Planning Surface

Use this to decide what happens next.

Status

approved

Phase

M-02B

decision

M02B_SCHEMA_CORRECTIONS_CAN_UNBLOCK_IMPLEMENTATION_PLANNING

Agent Handoff
Start Here

schema-addendum artifact · for Patient Visit Advocate · phase M-02B · status approved

Completion Evidence

No explicit evidence field yet. Require tests, screenshots, linked PRs, or reviewed outputs before marking complete.

Decision

M02B_SCHEMA_CORRECTIONS_CAN_UNBLOCK_IMPLEMENTATION_PLANNING

Structured Payload

Machine-readable source fields

title

PVA-SLICE-01 Schema Addendum — M-02B Corrections

status

ready_for_review

decision

M02B_SCHEMA_CORRECTIONS_CAN_UNBLOCK_IMPLEMENTATION_PLANNING

resolves
  • Vikram BLOCKER-01
  • Vikram BLOCKER-02
  • Vikram DEFECT-01
created at

2026-05-08T11:48:51.211Z

output ref

studio/pva/PVA-SLICE-01/schema-addendum-m02b.md

required sql
publish status check

CHECK (publish_status NOT IN ('ready', 'published') OR (lint_status IN ('passed', 'waived') AND review_status = 'approved'))

import row count check

CHECK (status != 'imported' OR imported_row_count = expected_row_count)

lint findings unique index

CREATE UNIQUE INDEX pva_qna_lint_findings_unique_rule_field_snippet ON pva_qna_lint_findings (qna_item_id, rule_id, field_name, (COALESCE(snippet, '')));