TSA Archive Manager

1. Safe Discovery

Sample limit

2. Table Selection

Filter tables Quick target set

3. Preview Filter

Mode

Quick period selectors

No quick period selected.

From date

Before date

Retention days

Limit export rows

Job ID

Subject ID

File ID

Invoice ID

Work order ID

Preview is read-only. Export writes JSONL/manifests only. Delete and restore are blocked unless enabled in .env.

4. Export & Run Actions

Archive Run ID Restore TEST target DB

Init/Rebuild is only for restore/test/staging DBs. It is hard-blocked from SOURCE_DB_NAME.

Restore back to SOURCE confirmation text

Dedicated source restore only. Keeps original IDs using INSERT IGNORE. Requires ALLOW_RESTORE=true and exact confirmation.

Delete confirmation text

Deletes source database rows only after verified export. Does not delete archive files.

Archive cleanup confirmation text

Deletes archive files/manifests and manager metadata only. It is blocked if source rows were deleted and not restored.

Source DB Health / Size Monitor

Lightweight live check from information_schema. This does not sample rows or rebuild date rules.

Status

Ready.

No active archive run loaded.

Preview Results

Raw Output

Ready.

Archive Runs

Selected Run Detail

Date Rules

Index Recommendations

Payload Analyzer

Table

Sample size

Archive Storage

Use storage outside httpdocs for security. Copy first, then update DB paths after verifying files exist in the new location.

From path

To path

Schedules

Schedules are stored here. Background execution only runs if ENABLE_ARCHIVE_SCHEDULER=true. Keep run_export off until preview/export is proven.

Name

Cron

Run export?

Help / Operations Center

Built-in operator guide for setup, scans, previews, exports, restores, deletes, cleanup and file archive testing.