Draft Pilot Local Migration Draft Review

Purpose

This page reviews the quarantined local-only draft artifact for future draft pilot schema planning. The artifact is outside active migrations and is not connected to runtime storage.

Draft Status

Status

local-only-draft

local-only-draft

Active

false

false

Executable

false

false

Deployed

false

false

D1 targeted

false

false

SQL executed

false

false

Tables created

false

false

Draft Artifact Location

docs/architecture/migration-drafts/draft-pilot-local-migration-draft.sql.md

The artifact is a markdown draft outside the active migrations folder.

Planned Tables

Table	Status	Runtime
`future_actor_refs`	local-only-draft	not runtime
`future_actor_ref_contexts`	local-only-draft	not runtime
`future_actor_ref_status_history`	local-only-draft	not runtime
`future_actor_ref_audit_events`	local-only-draft	not runtime
`future_actor_role_mappings`	local-only-draft	not runtime
`future_actor_permission_scopes`	local-only-draft	not runtime
`future_actor_role_status_history`	local-only-draft	not runtime
`future_actor_role_audit_events`	local-only-draft	not runtime
`future_pullup_pushup_drafts`	local-only-draft	not runtime
`future_pullup_pushup_draft_subject_refs`	local-only-draft	not runtime
`future_pullup_pushup_draft_status_history`	local-only-draft	not runtime
`future_pullup_pushup_draft_review_refs`	local-only-draft	not runtime
`future_pullup_pushup_draft_audit_events`	local-only-draft	not runtime
`future_morning_sheet_visibility_refs`	local-only-draft	not runtime
`future_retention_deletion_markers`	local-only-draft	not runtime
`future_draft_audit_events`	local-only-draft	not runtime

Allowed Fields

idcommunity_idworkflow_scopeactor_refsubject_actor_refreviewer_actor_refrole_keyrole_set_template_idpermission_keypermission_scopedraft_refdraft_typedraft_statusdraft_titledraft_bodyrepair_promptrecognition_promptreview_refreview_lanevisibility_statusmorning_sheet_eligibilityretention_categorydeletion_statusaudit_event_typereason_codestatus_fromstatus_toversioncreated_atupdated_atarchived_atdeleted_at

The field draft_body is future-sensitive and blocked from live storage until staff/privacy approval.

Prohibited Tables

usersaccountsidentitiesresidentsstaffprofilesemailssessionssubmissionspullupspushupsstaff_decisionsmorning_sheet_placementsattendanceparticipationanalyticsscoringrankingdisciplinecomplianceclinicalmedicallegalinsurancetrauma

Prohibited Fields

emailnamefirst_namelast_nameinitialsphoneaddressroom_numbercase_numberlegal_identifiermedical_identifierinsurance_identifierdiagnosismedicationtraumacloudflarecf_accessjwttokengroup_claimaccess_claimresident_profilestaff_profileattendance_countparticipation_countparticipation_scoreanalytics_scorerecovery_scorerankingdiscipline_pointscompliance_metricperformance_metric

Safety Labels

LOCAL-ONLY DRAFT - DO NOT RUN
Not an active migration
Not deployed
Not executed
No production or preview tables created
No D1 target
No runtime storage

Activation Blockers

draft artifact is local-only and outside active migrationsschemas are not activeSQL has not been executedD1 is not targetedno approved identity policyno approved pseudonymous actor policyno approved role mapping policyno staff/privacy approval completeno rollback plan approvedno local migration harness for this draftno disposable local SQL dry run for this draftno active migration filename approvedno live pilot approval

Future Validation Requirements

draft artifact remains outside active migrations
safety labels are present
only approved future_ table names are present in SQL blocks
prohibited table scan passes
prohibited field scan passes
no D1 target is present
no wrangler command is present
no production or preview database target is present in SQL blocks
no runtime database query is introduced
local validation harness is added in a future phase
default validation path does not execute SQL
manual disposable SQL path remains separately approved

What Remains Blocked

No SQL execution, D1 targeting, active migrations, protected live routes, protected API routes, write endpoints, draft storage, account storage, actor storage, identity capture, staff decisions, Morning Sheet placement, tracking, analytics, or scoring are active.

Recommended Next Phase

Phase 9.3 - Draft Pilot Local Migration Harness

The next safe step is a local-only validation harness for this draft artifact, without SQL execution by default and without D1, wrangler, active migrations, protected live routes, protected API routes, write endpoints, draft storage, accounts, tracking, analytics, or scoring.

Boundaries: no active migrations; no automatic SQL execution; no D1 target; no wrangler execution; no production or preview database target; no write endpoints; no protected live routes; no protected API routes; no draft storage; no account storage; no actor storage; no identity capture; no staff decisions; no Morning Sheet placement; no tracking; no analytics; no scoring.

recommended-next