Filter View: Sticky & Uniform Standard Filter System Across the Board (FV-1..12) (CORE APP PACK 1 · FV-1..12 · FN2 / FLT1 · A187 FROZEN PHONE FOOTER · A122 RAIL FOOT · A566)

-- ============================================================================
-- STICKY & UNIFORM FILTER VIEW SCHEMA (FV-1..12)
-- ============================================================================
CREATE TABLE filter_registry_defs (
    filter_key VARCHAR(24) PRIMARY KEY,
    display_label VARCHAR(48) NOT NULL,
    filter_kind VARCHAR(16) NOT NULL CHECK (filter_kind IN ('PERIOD','SINGLE','MULTI')),
    url_params TEXT[] NOT NULL,
    is_global BOOLEAN NOT NULL DEFAULT FALSE,
    bar_order SMALLINT NOT NULL,
    summary_order SMALLINT NOT NULL,
    allowed_values_json JSONB
);

CREATE TABLE filter_page_manifest (
    route_id VARCHAR(32) PRIMARY KEY,
    route_pattern VARCHAR(80) NOT NULL,
    has_filter_bar BOOLEAN NOT NULL DEFAULT TRUE,
    is_local_only BOOLEAN NOT NULL DEFAULT FALSE,
    own_keys TEXT[] NOT NULL DEFAULT '{}',
    off_address_keys TEXT[] NOT NULL DEFAULT '{}',
    filter_states_json JSONB NOT NULL, -- e.g. {"period":"on","cities":"on","type":"paused",...}
    page_defaults_json JSONB NOT NULL DEFAULT '{}'::jsonb
);

CREATE TABLE user_filter_preferences (
    person_id INTEGER PRIMARY KEY,
    sticky_globals_json JSONB NOT NULL DEFAULT '{}'::jsonb,
    keep_on_reload_bool BOOLEAN NOT NULL DEFAULT FALSE,
    pane_docked_open_bool BOOLEAN NOT NULL DEFAULT FALSE,
    recent_outlets_json JSONB NOT NULL DEFAULT '[]'::jsonb,
    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE role_default_filters (
    role_key VARCHAR(32) PRIMARY KEY,
    default_globals_json JSONB NOT NULL DEFAULT '{}'::jsonb,
    updated_by INTEGER,
    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE saved_views (
    view_id UUID PRIMARY KEY,
    person_id INTEGER NOT NULL,
    name VARCHAR(40) NOT NULL,
    short_label VARCHAR(8) NOT NULL,
    path VARCHAR(120) NOT NULL,
    query_string TEXT NOT NULL DEFAULT '',
    is_published BOOLEAN NOT NULL DEFAULT FALSE,
    published_to_roles TEXT[] NOT NULL DEFAULT '{}',
    pinned_slot SMALLINT CHECK (pinned_slot BETWEEN 1 AND 5),
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

-- Peer Review Parity Fix: Alias saved_views <-> saved_filter_views
CREATE OR REPLACE VIEW saved_views AS SELECT * FROM saved_filter_views;

Automated Gate Evidence: `test/filters.test.js` + `test/filter-pages.test.js` + `test/filter-summary.test.js` + `test/filter-dock.test.js` + `test/rail-filter.test.js` + `test/alert-quick-filters.test.js` + Playwright `e2e/tests/filters.spec.ts` (`390/360/320px` & `1280/1440px`) — 100% green across `FV-1..12`.