26A-24 — Printable Target Table Confirmation
SCHEMA INSPECTION ONLY — NO WRITE
Best Candidate Summary
| Candidate found | No |
|---|---|
| Best candidate table | No candidate table detected |
| Column group score | 0 / 11 |
| Notes | No candidate table was detected by this read-only inspection. |
| Approval phrase | SAVE_ONE_DRAFT_SHIFT |
| Rollback phrase | ROLLBACK_ONE_DRAFT_SHIFT |
Candidate Table Inspection
| Table | Exists | Score | Matched Groups | Missing Groups |
|---|---|---|---|---|
| hd_employee_schedule_draft_shifts | No | 0 / 11 | — | employee reference, employee name snapshot, draft date, start time, end time, position or role, draft status, publish lock, notification lock, test marker, timestamps |
| hd_employee_schedule_drafts | No | 0 / 11 | — | employee reference, employee name snapshot, draft date, start time, end time, position or role, draft status, publish lock, notification lock, test marker, timestamps |
| employee_schedule_draft_shifts | No | 0 / 11 | — | employee reference, employee name snapshot, draft date, start time, end time, position or role, draft status, publish lock, notification lock, test marker, timestamps |
| employee_schedule_drafts | No | 0 / 11 | — | employee reference, employee name snapshot, draft date, start time, end time, position or role, draft status, publish lock, notification lock, test marker, timestamps |
| employee_draft_shifts | No | 0 / 11 | — | employee reference, employee name snapshot, draft date, start time, end time, position or role, draft status, publish lock, notification lock, test marker, timestamps |
| draft_shifts | No | 0 / 11 | — | employee reference, employee name snapshot, draft date, start time, end time, position or role, draft status, publish lock, notification lock, test marker, timestamps |
| employee_scheduled_shifts | No | 0 / 11 | — | employee reference, employee name snapshot, draft date, start time, end time, position or role, draft status, publish lock, notification lock, test marker, timestamps |
| employee_schedule_shifts | No | 0 / 11 | — | employee reference, employee name snapshot, draft date, start time, end time, position or role, draft status, publish lock, notification lock, test marker, timestamps |
| employee_shifts | No | 0 / 11 | — | employee reference, employee name snapshot, draft date, start time, end time, position or role, draft status, publish lock, notification lock, test marker, timestamps |
| schedule_shifts | No | 0 / 11 | — | employee reference, employee name snapshot, draft date, start time, end time, position or role, draft status, publish lock, notification lock, test marker, timestamps |
| shifts | No | 0 / 11 | — | employee reference, employee name snapshot, draft date, start time, end time, position or role, draft status, publish lock, notification lock, test marker, timestamps |
Manager Confirmation Checklist
- Confirm the best candidate table is the correct draft-shift target table.
- Confirm employee reference column exists.
- Confirm shift date column exists.
- Confirm start and end time columns exist.
- Confirm position or role column exists.
- Confirm draft status or state column exists.
- Confirm publish lock/status column is available or confirm future write leaves publish disabled another way.
- Confirm notification lock/status column is available or confirm future write cannot send notifications.
- Confirm a test marker, note, or phase column can safely identify the one-row test.
- Confirm rollback can target only the created test row.
Future Write Column Requirements
- Required: employee reference.
- Required: draft or shift date.
- Required: start time.
- Required: end time.
- Required: position or role.
- Required: draft/unpublished status.
- Recommended: test token or source phase marker.
- Recommended: manager initials or note field.
- Required for safety: future write must keep publish disabled.
- Required for safety: future write must keep notifications disabled.
Schema Inspection Rules
- Only Schema::hasTable and Schema::getColumnListing are used for candidate inspection.
- No insert, update, save, delete, truncate, migration, notification, mail, queue, event, or publish action is called.
- Candidate scoring is advisory only and does not authorize a future write.
- The manager must confirm the exact target table and required columns before any future controlled write.
- The approval phrase remains required but does not unlock a write in this phase.
- Rollback phrase remains documented only and does not install a cleanup command.
Safety Locks
- No ENV changes.
- No database writes.
- No database deletes.
- No migration creation or execution.
- No real draft shift save.
- No real rollback or cleanup command is installed.
- No published schedule.
- No employee self-view change.
- No employee text message.
- No employee email notification.
- No payroll, POS, reservation, payment, waiver, or customer profile changes.
- No hard conflict blocking.
- No automatic scheduling.
- No Payfast Office file, route, controller, or database action.
- This phase performs read-only schema/table inspection only.
Next Step Notes
- Recommended next phase: 26A-25 — Controlled One-Row Draft Save Final Approval Gate / Still No Write.
- Do not run a real one-row write from this phase.
- A future write phase must use the confirmed target table and validated payload only.
- A future write phase must immediately display created row id, test token, and rollback instructions.
- Employee notifications and schedule publishing must remain disabled.