Database Schema Setup

Run table and column creation manually during setup or after pulling new changes.

Back to Setup Open DB Checker
Normal pages no longer run schema setup automatically. Use this tool after deployment, database import, or whenever the system structure needs repair. This page now checks all 29 models plus 1 bootstrap task and runs schema sync only on the ones that actually define it.
Model Coverage
Admission
Admission | syncSchema
Assistant
Assistant | no schema
Audit Log
AuditLog | no schema
Branches
Branch | syncSchema
Cashier
Cashier | no schema
Channeling
Channeling | syncSchema
Consultation Invoices
ConsultationInvoice | ensureSchema
Doctor
Doctor | no schema
Insurance Companies
InsuranceCompany | syncSchema
Medical Records
MedicalRecord | syncSchema
Medicines
Medicine | no schema
Medicine Generics
MedicineGeneric | no schema
Membership
Membership | syncSchema
OPD Billing Setup
OpdBilling | ensureSchema
OPD Visits
OpdVisit | syncSchema
Patients
Patient | no schema
Patient Allergies
PatientAllergy | no schema
Pharmacy Core
Pharmacy | syncSchema
Prescriptions
Prescription | syncSchema
Radiology
Radiology | ensureSchema
Radiology Invoices
RadiologyInvoice | ensureSchema
Referral
Referral | no schema
Rooms
Room | no schema
Sessions
Session | no schema
Session Slots
SessionSlot | no schema
Specializations
Specialization | no schema
System Settings
SystemSetting | ensureSchema
Tests
Test | ensureSchema
Users
User | no schema
Bootstrap Tasks
System Setting Defaults
bootstrap task
This run covers 30 total tasks.