🩺 Schema Doctor
Database schema health — expected vs actual tables in /app/operator_app/aegis.db
Present
5
Missing
8
Extra
8
Present (5)
| Table | Status |
|---|---|
| tasks | present |
| reports | present |
| audit_log | present |
| approvals | present |
| models | present |
Missing (8)
| Table | Status |
|---|---|
| crm_contacts | missing |
| crm_deals | missing |
| send_packets | missing |
| send_approvals | missing |
| followup_queue | missing |
| reply_outcomes | missing |
| payment_evidence | missing |
| paid_outcomes | missing |
Extra Tables (8)
| Table | Status |
|---|---|
| aegis_approval_inbox | extra |
| aegis_autopilot_runs | extra |
| aegis_operational_memory | extra |
| aegis_send_approval_events | extra |
| aegis_send_packets | extra |
| aegis_today_queue | extra |
| chat_messages | extra |
| chats | extra |
CLI Schema Report
AEGIS SCHEMA DOCTOR
Status: WARN
Tables checked: 7
Findings:
- [warn] aegis_send_packets.channel — not_null_without_default
aegis_send_packets.channel is NOT NULL with no default.
Suggested: Ensure insert compatibility fills this column before writing records.
- [warn] aegis_send_packets.recipient — not_null_without_default
aegis_send_packets.recipient is NOT NULL with no default.
Suggested: Ensure insert compatibility fills this column before writing records.
- [warn] aegis_send_packets.body — not_null_without_default
aegis_send_packets.body is NOT NULL with no default.
Suggested: Ensure insert compatibility fills this column before writing records.
- [warn] aegis_send_packets.created_at — not_null_without_default
aegis_send_packets.created_at is NOT NULL with no default.
Suggested: Ensure insert compatibility fills this column before writing records.
- [warn] aegis_send_packets.updated_at — not_null_without_default
aegis_send_packets.updated_at is NOT NULL with no default.
Suggested: Ensure insert compatibility fills this column before writing records.
- [warn] aegis_payment_evidence.* — missing_table
Missing table: aegis_payment_evidence
Suggested: Create table aegis_payment_evidence through its owning module migration.
- [warn] aegis_paid_outcomes.* — missing_table
Missing table: aegis_paid_outcomes
Suggested: Create table aegis_paid_outcomes through its owning module migration.
- [warn] aegis_proposal_packs.* — missing_table
Missing table: aegis_proposal_packs
Suggested: Create table aegis_proposal_packs through its owning module migration.
- [warn] aegis_proposal_send_conversions.* — missing_table
Missing table: aegis_proposal_send_conversions
Suggested: Create table aegis_proposal_send_conversions through its owning module migration.
- [warn] aegis_approval_inbox.approval_type — not_null_without_default
aegis_approval_inbox.approval_type is NOT NULL with no default.
Suggested: Ensure insert compatibility fills this co
CLI: ./scripts/aegis schema-doctor