🩺 Schema Doctor
Database schema health — expected vs actual tables in /app/operator_app/aegis.db
Present
5
Missing
8
Extra
8
Present (5)
TableStatus
taskspresent
reportspresent
audit_logpresent
approvalspresent
modelspresent
Missing (8)
TableStatus
crm_contactsmissing
crm_dealsmissing
send_packetsmissing
send_approvalsmissing
followup_queuemissing
reply_outcomesmissing
payment_evidencemissing
paid_outcomesmissing
Extra Tables (8)
TableStatus
aegis_approval_inboxextra
aegis_autopilot_runsextra
aegis_operational_memoryextra
aegis_send_approval_eventsextra
aegis_send_packetsextra
aegis_today_queueextra
chat_messagesextra
chatsextra
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