DixielandJobflow
No hidden transfersStaging for Lee oversight
Database v2

Admin readiness dashboard

Forms, Q&A migration, search, backups, access, and automation stay visible before production data entry.

Not production readyGenerated Jun 3, 2026, 12:59 AM
Worksheet families9
Q&A file targets7
Search facets14
Backup controls5
Blocked3
Needs review4
Go-live blockers5 controls still need proof
ControlWhy it mattersClears when
Durable Postgres writesDaily Work Record has a Postgres transaction writer and tenant/template seed data, but production persistence still needs a reviewed database URL, applied migrations, and environment proof.Seeded tenant/template data plus form submissions, normalized rows, search documents, context observations, and audit events write inside one reviewed transaction.
Auth and RLSOwner/admin access cannot be considered remote-safe until provider auth, roles, and RLS policies are reviewed.Each Database v2 role has tested RLS coverage and auth smoke tests in staging.
Restore drillBackups are not bulletproof until a restore has been tested and recorded.Managed backup, PITR, encrypted export, source artifact backup, and restore-drill evidence are visible to admins.
Q&A archive profilerThe Q&A contract is mapped and a safe profiler exists, but it has not yet been run against the real archive/source folder.The profiler records reviewed Q&A source file fingerprints and sanitized stats without committing raw legacy records.
Remote owner accessOwners need a verified remote route into Database v2 before production reliance.Owner/admin login, HTTPS, role landing page, and audit visibility pass a staging smoke test.
office manager

Worksheet Form Intake

Blocked
Worksheet families
9
Scanned worksheet families mapped to Database v2 templates.
Template maps
27
Source field groups tied to normalized table destinations.
First form packet
Transactional
Uses canonical tenant UUID plus worksheet template seed data.
Proof

Daily Work, Rough-In, Material Order, Purchase Order, Job Costing, Job Invoice Summary, Panel Catalog, and Materials Catalog paths produce raw payloads, semantic values, normalized rows, aliases/source/context observations, search documents, audit events, parameterized Postgres transaction plans, and seed SQL for tenant/template lookups.

Next action

Apply the foundation schema and seed SQL, then run the transaction against a reviewed Postgres environment after RLS is approved.

reviewer

Q&A Migration Review

Needs review
Archive entries
1,955
Sanitized entry count from the received preservation ZIP.
Source file targets
7
DTF/IDX targets queued for profiling and staging.
Profiler
Implemented
Emits hashes, sizes, file statuses, and index presence without raw values.
Proof

The 2026-05-26 archive reference, parser targets, review states, reviewed-search behavior, safe profiler command, profile persistence, and raw/staged record transaction are modeled without raw records in git.

Next action

Run `npm run qa:profile -- <source-directory> --persist` against the real extracted archive path, review the fingerprints, then connect the parser/extractor to the raw-record staging transaction.

owner admin

Unified Search Index

Needs review
Facets
14
Shared filters for live Jobflow and reviewed Q&A records.
Live forms
8 staged
Daily Work, Rough-In, Material Order, Purchase Order, Job Costing, Job Invoice Summary, Panel Catalog, and Materials Catalog plan search documents.
Legacy records
Reviewed gate
Reviewed or merged Q&A staged records can be searchable.
Proof

Search facets cover jobs, worksheets, phase, paper color, ink color, people, materials, PO, invoice, source system, and review state.

Next action

Connect search document writes to durable form and Q&A staging transactions.

owner admin

Backup Redundancy

Blocked
managed-postgres-backup
daily
Provider backup status and retention window are visible to admins.
point-in-time-recovery
continuous
PITR setting is enabled before production data entry.
encrypted-logical-export
scheduled
Encrypted export exists outside the primary database provider.
Proof

The backup contract requires managed backups, PITR, encrypted logical exports, source artifact backup, and restore drills.

Next action

Create backup snapshot tracking and record a restore drill before production data entry.

owner admin

Remote Owner Access

Blocked
Roles
6
Owner/admin, office, billing, scheduler, crew, and reviewer.
RLS
Missing
Policy tests are required before production data.
Smoke test
Missing
Owner/admin remote login has not been verified.
Proof

Database v2 role keys exist, but provider auth, RLS policies, and remote smoke tests are not wired yet.

Next action

Stand up provider-managed auth and verify owner/admin remote access over HTTPS.

office manager

Admin Adjustable Rules

Needs review
Phase rules
Drafted
Workflow phase config table exists in the schema draft.
Worksheet rules
Drafted
Paper color, ink color, author role, and phase can drive rules.
Guardrails
Audit required
Financial, destructive, and migration changes need review.
Proof

Workflow phase configs, worksheet method rules, and automation rules are represented in the schema draft.

Next action

Build safe admin editors after Alicia confirms paper colors, ink colors, and phase meanings.

owner admin

Automation Monitoring

Needs review
Rules
Drafted
Automation rules are disabled by default and require review.
Audit trail
Drafted
Writes and future automation events can land in audit_events.
Outcomes
Not live
No production automation results exist yet.
Proof

Automation rules and audit events are modeled, but no live automation worker has run yet.

Next action

Track automation outcomes alongside form intake, Q&A import, search, and backups.