← WI-063 Tracking identity & ingestion physical (QR/aliases/bindings/labels/scans/checkout + P5 ingestion tables + promotion RPC + direct-write prevention + scan/validation storage) ★ Live Board · Overview WI-065 MCP proposal/approval & controlled actions (proposal+grant+automation-policy, policy evaluator, domain-mapped actions, bulk-as-frozen-plan, live e2e) →

WI-064 · Platform & Contracts · marketplace-intel-disposition

Marketplace, intelligence, disposition & public-safe surfaces (buyer tables + public views/RPCs, ranking/demand storage, disposition/recovery, appraisal privacy, leakage tests)

queued P2 medium risk   Owner: Paul   Reviewer: Mark Hilleary   0% · 0/1 tasks complete

Gates: P6 Requirements: — Updated: 2026-06-22

At a glance

CodeWI-064
PhasePlatform & Contracts
Order25 of 93
Story points13
Primary surfacemarketplace/buyer + seller-intelligence + disposition + public-safe views/RPCs
Retires—
Depends onData authority & RLS foundation (tenants/memberships/roles/permissions/assignments, auth helpers, deny-by-default membership RLS, schema+migration contract, demo parity)
Blocks—
Evidence
queued (P6 marketplace)

Goals

Build the buyer/marketplace, seller-intelligence, and disposition/recovery domains with strictly buyer-safe public projections, the P4 ranking/demand storage, the appraisal inherit-location privacy model, and the public-data leakage test suite.

Spec document

P6-data-model-layers → · source ↗

Implementation — what to build

Buyer + public

  • buyer-owned tables (buyer_id RLS), public views/RPCs + resolver (allowlist projections), garage-sale submissions, /api/out attribution; public-leakage tests (named cols + nested JSON).

Intelligence + disposition

  • item_demand_signals + frozen demand_snapshots + ranking_receipts + profiles (P4); wishlist_matches (aggregate-only to seller); buyer_offers (private); disposition recommendations/actions + donation/auction/clearance + responsible_disposal.

Privacy + policy

  • appraisal location_context inherit model; privacy_class classification; tenant_provider_policies (P2 retention/training/region).

Checklist

  • ○ P6 Data-model layers are consolidated (canonical, marketplace, seller-intelligence, tracking-identity, disposition, ingestion) with a documented RLS owner-scoped upgrade path.

Gates & testing

  • ○ P6 Data-model layers are consolidated (canonical, marketplace, seller-intelligence, tracking-identity, disposition, ingestion) with a documented RLS owner-scoped upgrade path.
    CODE TEST HITL QA

Requirements

No linked requirements.

Verify (done when)

Marketplace/buyer tables + public-safe views/RPCs + public QR resolver (exclude all private fields; nested-JSON leakage tests pass); seller-intelligence incl. P4 frozen demand_snapshots + ranking_receipts + versioned profiles; offers (private); disposition recommendations/actions + responsible-disposal terminal; appraisal privacy (location_context inherit model); outbound attribution (/api/out no open redirect); append-only audit. Per spec section 26-36, 45-49, 61 #2/#3. Serves F/marketplace.

Cost triggers

No paid API / infra spend triggered by this item.

Status & editing

queued   Sprint: P&C Wave 4: Data & Surfaces

Edit status / sprint on the ★ Live Board → — changes are logged live with who / when / why.

Human-in-the-loop

No human tasks linked.

Findings

None recorded yet.

Concerns

None recorded yet.

Risks

None recorded yet.

Tech debt

None recorded yet.

Tools used

No tool calls recorded.

Files & artifacts

No files / artifacts recorded.

Update log

No log entries yet.