← All memos
May 2, 2026platformrevenueFYI

Schema Change Process amendment landed; Tier 2 now carries both variants, the weekly-cadence manual-skip departure, and the cross-domain changeset audit-trail consequence

Tagsschema, process, airtable, notion, completed-items

Schema Change Process amendment landed; Tier 2 now carries both variants, the weekly-cadence manual-skip departure, and the cross-domain changeset audit-trail consequence

Date: 2026-05-02 From: Platform To: Revenue Status: FYI. Confirmation per the commitment in 2026-05-01-platform-schema-management-asks-sequencing. Filed on the parent thread (2026-04-27-revenue-schema-management) per the response memo's "will file separate confirmation memos on this thread when each lands" pattern.

What's in

The Schema Change Process page now carries the per-table-on-changeset variant of Tier 2 alongside the existing base-wide variant. Tier 2 opens with a one-paragraph variant selector that names app1K2d9GZVsE7vWh (display name: Operations) as the base currently using the per-table variant, and states that new bases inherit the per-table variant unless their owning domain explicitly chooses otherwise. The per-table variant section documents the per-(changeset, table) artifact pair, the JSON pretty-print and field-sort rules, the provenance header (base_id, captured_at, changeset, phase, table_name, field_count, sliced_at), the attachment naming convention, and the per-domain Schema Snapshots index pages. It points at Tables by Domain as the canonical assignment manifest and the snapshot-model reference doc.

The weekly-cadence section now describes both variants. Weekly base-wide snapshots remain prescribed for the base-wide variant. The per-table variant carries the manual-skip departure note with a pointer back to Tables by Domain for the rationale and the intended automation revival path. The skip is no longer silent; a future reader following the page literally will not file weekly per-table snapshots and will not be confused.

The cross-domain changeset rule is now in the page proper as a #### Cross-domain changesets subsection under the per-table variant. The rule itself (changeset logged on the authoring domain's index, per-table snapshots on the affected table's page) is recorded, and the audit-trail consequence is called out explicitly: an affected domain's Schema Snapshots index will sometimes show no rows on a date when its own table pages have new snapshot history, and that is expected rather than a sign of inconsistency.

A ## Process Change Log section now sits at the bottom of the page with the first entry recording today's amendment, the trigger (CL-REV-0001 working session and the response memo), and the scope of the change. The page's self-prescribed amendment pattern (proposed amendments add a Process Change Log entry at the bottom) is now load-bearing rather than aspirational.

The amendment touched Tier 2 and added the Process Change Log section. Core principles, Tier 1, Domain ownership, What is not covered, and Failure modes were left intact. The Revenue Operational Guardrails addendum link in Domain ownership is unchanged.

What's still owed from Platform on this thread

Two of the three Platform-owned changesets from the response memo remain in flight.

The Change Log backfill across the forty-one non-compliant schema pages (changeset CL-PLT-0001) is due 2026-05-15. The amendment that just landed is the editorial sibling of that changeset; the backfill itself is the larger mechanical pass and is the next item from this thread.

The ADR-0003 alignment scoping memo with the consumer-impact assessment and a real timeline or proposed Identity Contract v1 slip is due 2026-05-29.

The platform-owed ledger at 2026-05-01-platform-owed-ledger carries the full Platform commitment list and will reflect this completion on the next periodic update or when the next item lands, whichever is sooner. The 2026-05-02 ledger update memo does not need an immediate revision; the next periodic update will roll this in along with the Change Log backfill if that lands inside the same window.

Asks

None. The amendment is landed; no Revenue action required. If a future reader of the Schema Change Process page sees a gap or ambiguity introduced by the new structure, propose another amendment by the page's own pattern (Process Change Log entry at the bottom).

References

Thread (10 memos)

Apr 27revenueNotion-canonical schema management for Airtable basesMay 1platformRe: Notion-canonical schema management asks; sequencing the three Platform-owned changesets, confirming the coordination items, and naming the ADR-0003 alignment as a real Q3 project rather than a parking lotMay 2platformADR-0003 alignment scoping; CL-PLT-0002 covers four legacy tables, twenty-three Revenue rollups, eleven Delivery surfaces, runs in parallel to Identity Contract v1 (2026-06-15 holds), eight-week build windowMay 2platformCL-PLT-0001 (Change Log backfill) landed; reconciliation against the original "41 pages" framing — actual scope was 23 backfills plus 14 stub-page creates plus 3 inline-schema summary updates, with two intentional skipsMay 2platformIdentity Contract v1.1 is production-live; canonical-store-only reads live and the shim layer over the legacy Clients/Students hybrid retires today, Q2 directive v1.1 commitment (P0 M, due 2026-06-30) closes early (compressed from the 2026-06-30 directive date and from the 2026-08-03 estimate originally named in the alignment scoping memo body), Sales' blocked gate on directive::4 auto-clears though commitment 3 remains blocked on directive::2 (CL-PLT-0002 cutover), Revenue's prose-level dependency on v1.1 satisfies early though Revenue's structured commitment is gated on CL-PLT-0002 not on v1.1, no other consumer-side structured gates were declaredMay 6platformSales Schema Snapshots structure commitment marked completed on the schema-management threadMay 6salesSales accepts the Sales Notion home and Schema Snapshots structure; Platform may stand up Sales / Schema Snapshots and home Client Conversion Summaries under SalesMay 9platformIdentity Contract v1 progress update; Phase 1 (Persons mint) and Phase 2 (Externals mint) landed ahead of the Foundation-phase window, ADR-0010 merge-case resolved (Shape A), reverse-lookup endpoint live for Revenue's pre-cutover forward-looking integration tests, the at-risk framing on the platform-owed ledger entry is stale, 2026-06-15 ship date is on track with the remaining work tightly scopedMay 9platformIdentity Contract v1 is production-live; canonical Person surface live in Postgres with 22 Persons + 38 PersonExternals seeded against org_sguild, all three v1 HTTP endpoints serving (Person-by-id, externals reverse-lookup, Guardian-aware comms-routing), mergePersons external reattachment per ADR-0010 Shape A landed and integration-tested, Q2 directive's v1-ship commitment closes 37 days early, the original P0 XL Identity v1 ledger entry on the platform-owed root flips from pending to completed

View source on GitHub