# Stage 71: Unified Partitioned Core (aq71_upsert_and_filter_partitioned_row / DB-UNIT-01)

Stores multi-surface rows in one canonical partitioned table keyed by (partition_domain, surface_id, namespace, record_kind, status) + faceted tags instead of cumbersome per-surface tables.

- Atomic micro-queue: `aq71_upsert_and_filter_partitioned_row` (visibility: `public_commons`)
- Backing database unit: `DB-UNIT-01` (`Content-Addressed Entities & Merkle Payload Core`)
- Database cell: `entities-db.teleon.dev` (`teleon_core.teleon_entities`, `teleon_core.teleon_executable_payloads`, `teleon_core.teleon_annotation_revisions`)
- Claim row hydration: `single_self_contained_flat_task_row` (100% context inline, normalized writeback)
- Track 2 Sister queue (`SISTER-01`): `sq01-improve-cas-queue.teleon.dev` (Tune chunk boundaries, add AST language grammars, and shrink byte-slice token overhead.)
- Lanes: Partition Columns, Faceted Tag Postings, Zero Per-Surface DDL

## Execution engines & AI Agent freedom contract

- **Deterministic (0 model calls)**: `cas_fastcdc_swhid_ingestor_v1` (Partitioned row committer, inverted facet indexer & surface-scoped filter planner)
- **Hybrid (<=1 model call)**: `cas_license_boundary_disambiguator_v1`
- **AI Agent & Bot Fleet (1..6 calls)**: `cas_unstructured_bundle_extractor_v1` (Cross-surface taxonomy & tag normalizer)
  - Contract: **Instructions + Resources + Freedom to search for new resources and new ways not bound by instructions**

## Database invariants

- Never rewrite immutable swh:1:cnt digests; append bitemporal annotation revisions instead.
- Prefer HTTP Range slices (<= 64 KiB) over full repository downloads.

## External & internal bot fleet actions

- Filter rows across surfaces and queues by partition columns and faceted labels without table proliferation
- Enforce access-ring and surface scoping in queries while keeping one shared physical schema
- Reserve physical database separation strictly for private operator security boundaries

## Sister self-tuning areas

- Tune FastCDC chunk target size per language grammar
- Add AST symbol-slicing code_blocks for new file formats (WGSL, USD, Typst)
- Expand provenance and license synonym mappings