pharma-erp

Status: Table Validation Phase Schema check

We are currently verifying the integrity of all database tables. Below is the real‑time status of each table and any errors detected.

Table validation progress

artworks ✓ Verified audit_logs ✓ Verified batch_production_steps ✗ Error boms ✓ Verified clients ✓ Verified dispatches ⏳ Pending finished_goods_lots ⚠ Warning goods_receipts ✓ Verified invoices ✓ Verified manufacturing_batches ✗ Error materials ✓ Verified material_lots ⚠ Warning production_orders ⏳ Pending products ✓ Verified purchase_orders ✓ Verified sales_orders ✓ Verified users ✓ Verified

🔍 Error feedback

manufacturing_batches: foreign key constraint violation on order_item_id

batch_production_steps: missing sequence numbers for step 3

material_lots: 2 lots have expiry_date in the past but status = "released"

📋 Recent audit actions

2026-02-16 10:23: User QA (id:5) approved material_lot #124

2026-02-16 09:57: User warehouse (id:6) adjusted stock movement #452

2026-02-16 09:12: System auto‑created audit_log for sales_orders update

Need immediate assistance? Contact the administrator.