Harley's Intake & Backlog Philosophy (A573), Design-to-Build Gate (IN-1..10) & Installed Agentic Skills (PROCESS & GOVERNANCE SPINE · A573 · IN-1 TO IN-10 · L1–L6 · G1–G7 · T0–T3 · C1–C11 · Q1–Q12 · V1–V10)

-- INTAKE, BACKLOG & ARTIFACT GOVERNANCE LEDGER (IN-1..IN-10 / A573)
CREATE TABLE owner_ask_register (
    ask_id VARCHAR(16) PRIMARY KEY, -- 'A-001' .. 'A-573', 'O-001' .. 'O-049'
    asked_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    trigger_lane VARCHAR(16) NOT NULL CHECK (trigger_lane IN ('BACKLOG','INTAKE','BUGFIX','HOTFIX','BREAKFIX','DECISION')),
    effort_tag CHAR(1) NOT NULL CHECK (effort_tag IN ('E','I','H')),
    criticality_tier CHAR(2) NOT NULL CHECK (criticality_tier IN ('T0','T1','T2','T3')),
    owner_words_verbatim TEXT NOT NULL,
    business_value_one_liner TEXT NOT NULL,
    recommendation VARCHAR(16) NOT NULL CHECK (recommendation IN ('DO_NOW','DO_SMALL','PARK')),
    sharp_challenge_one_liner TEXT,
    status VARCHAR(20) NOT NULL DEFAULT 'QUEUED'
        CHECK (status IN ('DONE','BUILDING','QUEUED','WAITING_OWNER','PARKED','BACKLOG','DECIDED')),
    result_artifact_link VARCHAR(255),
    commit_sha VARCHAR(40)
);

CREATE TABLE decisions_and_challenges_ledger (
    entry_id VARCHAR(16) PRIMARY KEY, -- 'C-01' .. 'C-51', 'FG-01' .. 'FG-99'
    ask_id VARCHAR(16) REFERENCES owner_ask_register(ask_id),
    decision_class VARCHAR(20) NOT NULL CHECK (decision_class IN (
        'DESIGN','UX','LAYOUT','WORDING','PERMISSION','STAFF','RELEASE','ARCHITECTURE'
    )),
    criticality_tier CHAR(2) NOT NULL CHECK (criticality_tier IN ('T0','T1','T2','T3')),
    owner_decision_summary TEXT NOT NULL,
    evidence_based_challenge TEXT NOT NULL,
    recommended_option TEXT NOT NULL,
    verdict_status VARCHAR(20) NOT NULL DEFAULT 'APPLIED' CHECK (verdict_status IN ('OPEN','APPLIED','OVERRULED_LOGGED','OWNER')),
    revisit_trigger TEXT,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE artifact_review_registry (
    artifact_slug VARCHAR(120) PRIMARY KEY,
    html_route VARCHAR(255) NOT NULL,
    md_source_path VARCHAR(255) NOT NULL,
    summary_12_lines TEXT NOT NULL,
    status_badge VARCHAR(20) NOT NULL DEFAULT 'IN_REVIEW'
        CHECK (status_badge IN ('DRAFT','PROPOSED','IN_REVIEW','APPROVED','CURRENT','SUPERSEDED','HISTORY')),
    superseded_by_slug VARCHAR(120),
    owner_reviewed_at TIMESTAMPTZ,
    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

Automated Gate Evidence: Verified all 11 skills installed in `/Users/srinivas/workspaces/harleys/.agents/skills/`, `/Users/srinivas/.gemini/antigravity/skills/`, and `/Users/srinivas/.claude/skills/`, and verified 100% coverage of `01-PHILOSOPHY.md` (`A573`), `02-SET-UP-LIST.md` (`IN-1..IN-10`), and `sources/*`.