Database Checker

Back to Setup

All required tables, columns, views, roles, and settings are present.

Table	Table Status	Rows	Columns
roles	EXISTS	18	role_id role_name description
users	EXISTS	17	user_id role_id branch_id username email password_hash full_name permissions_json status
branches	EXISTS	1	branch_id branch_code branch_name po_enabled grn_enabled grn_billing_enabled stock_adjustment_enabled price_adjustment_enabled expiry_update_enabled open_stock_enabled department_feature_settings status
specializations	EXISTS	11	specialization_id name
doctors	EXISTS	4	doctor_id user_id specialization_id name status
assistants	EXISTS	2	assistant_id user_id name status
doctor_assistants	EXISTS	1	id doctor_id assistant_id assigned_date status
patients	EXISTS	0	patient_id patient_code name blood_group allergies
test_categories	EXISTS	9	category_id name status
tests	EXISTS	41	test_id category_id test_name price status
medicines	EXISTS	65	medicine_id name item_type therapeutic_category generic_name trade_name status default_purchase_price default_retail_price
sessions	EXISTS	0	session_id doctor_id room_id session_date status
session_slots	EXISTS	0	slot_id session_id patient_id status
medical_records	EXISTS	0	record_id slot_id patient_id session_id opd_visit_id record_source weight blood_pressure_systolic pulse
prescriptions	EXISTS	0	prescription_id slot_id patient_id doctor_id session_id opd_visit_id prescription_source status
opd_consultation_visits	EXISTS	0	visit_id visit_no branch_id patient_id doctor_id admission_id bht_number source_department status created_by
referrals	EXISTS	0	referral_id prescription_id from_doctor_id to_doctor_id referred_to status
system_settings	EXISTS	3	setting_key setting_value
pharmacy_suppliers	EXISTS	1	supplier_id supplier_name status
medicine_therapeutics	EXISTS	29	therapeutic_id item_type name status
pharmacy_purchase_orders	EXISTS	0	po_id po_number branch_id department_code supplier_id supplier_name po_date status
pharmacy_po_items	EXISTS	0	po_item_id po_id medicine_id medicine_name qty_ordered
pharmacy_grns	EXISTS	0	grn_id grn_number branch_id department_code po_id grn_type supplier_id supplier_invoice_no reference_name reference_page_no supplier_name grn_date status notes subtotal_amount tax_amount total_amount
pharmacy_grn_items	EXISTS	0	grn_item_id grn_id branch_id department_code medicine_id batch_no qty_received free_qty qty_available is_free tax_percent retail_price tax_amount line_total
pharmacy_bills	EXISTS	0	bill_id bill_number branch_id department_code grn_id bill_date status payment_method cheque_no subtotal_amount tax_amount total_amount
pharmacy_dispenses	EXISTS	0	dispense_id dispense_code branch_id department_code prescription_id patient_id admission_id bht_number member_id member_no dispense_date bill_type bill_series stock_subtotal drug_markup_percent drug_markup_amount doctor_charge institute_charge service_charge_total vaccine_charge_total payment_status payment_collection_mode payment_method
pharmacy_dispense_sequences	EXISTS	0	branch_id department_code bill_series sequence_date last_number
pharmacy_dispense_items	EXISTS	0	dispense_item_id dispense_id prescription_medicine_id batch_item_id qty_dispensed
pharmacy_sales_returns	EXISTS	0	sales_return_id return_code branch_id department_code dispense_id return_date total_amount
pharmacy_sales_return_items	EXISTS	0	sales_return_item_id sales_return_id dispense_item_id qty_returned unit_price line_total
pharmacy_open_stock_headers	EXISTS	0	open_stock_header_id branch_id department_code draft_no stock_date reference_no reference_name notes status linked_grn_id created_by completed_by completed_at
pharmacy_open_stock_items	EXISTS	0	open_stock_item_id open_stock_header_id medicine_id medicine_name batch_no expiry_date page_no qty_received free_qty unit_cost is_free tax_percent retail_price tax_amount line_total created_by
pharmacy_open_stock_returns	EXISTS	0	open_stock_return_id branch_id department_code return_no grn_id grn_item_id source_grn_no supplier_name qty_returned qty_before qty_after
pharmacy_grn_returns	EXISTS	0	grn_return_id branch_id department_code return_no grn_id grn_item_id qty_returned qty_before qty_after
pharmacy_stock_adjustments	EXISTS	0	adjustment_id branch_id department_code grn_item_id adjustment_type qty_before qty_change qty_after created_at
pharmacy_price_adjustments	EXISTS	0	adjustment_id branch_id department_code grn_item_id old_unit_cost new_unit_cost old_retail_price new_retail_price created_at
pharmacy_expiry_updates	EXISTS	0	update_id branch_id department_code grn_item_id old_expiry_date new_expiry_date created_at
pharmacy_department_medicine_prices	EXISTS	0	price_id branch_id department_code medicine_id default_purchase_price default_retail_price
pharmacy_department_transfer_rules	EXISTS	0	rule_id branch_id source_department target_department cost_markup_percent cost_round_mode cost_round_to retail_markup_percent retail_round_mode retail_round_to status
pharmacy_department_transfers	EXISTS	0	transfer_id transfer_no branch_id source_department target_department transfer_date status cost_markup_percent cost_round_mode cost_round_to retail_markup_percent retail_round_mode retail_round_to received_grn_id reversed_at reversal_notes
pharmacy_department_transfer_request_items	EXISTS	0	request_item_id transfer_id medicine_id medicine_name requested_qty issued_qty
pharmacy_department_transfer_items	EXISTS	0	transfer_item_id transfer_id request_item_id source_grn_item_id medicine_id batch_no qty_transferred unit_cost retail_price target_unit_cost target_retail_price received_grn_item_id
pharmacy_department_stock_batches	EXISTS	0	department_stock_batch_id branch_id department_code transfer_item_id source_grn_item_id medicine_id batch_no qty_received qty_available unit_cost retail_price status
consultation_invoices	EXISTS	0	invoice_id invoice_no slot_id session_id patient_id doctor_id branch_id doctor_fee_amount institute_fee_amount amount status payment_method cash_amount card_amount
radiology_services	EXISTS	2	service_id name modality default_price institute_fee_amount status
radiology_doctors	EXISTS	3	doctor_id status
radiology_doctor_modalities	EXISTS	9	doctor_id modality
radiology_service_prices	EXISTS	1	price_id service_id doctor_id price
radiology_sessions	EXISTS	0	session_id modality session_date start_time end_time max_patients branch_id doctor_id status created_by
radiology_session_slots	EXISTS	0	slot_id session_id slot_number patient_id doctor_id service_id doctor_fee_amount institute_fee_amount price_charged status
radiology_invoices	EXISTS	0	invoice_id invoice_no slot_id session_id patient_id doctor_id service_id branch_id admission_id bht_number doctor_fee_amount institute_fee_amount amount status payment_method
opd_billing_catalog_items	EXISTS	0	catalog_item_id item_type item_name default_price default_doctor_charge institute_charge_percent linked_medicine_id status
opd_bill_extra_items	EXISTS	0	extra_item_id dispense_id item_type catalog_item_id item_name qty unit_price doctor_charge institute_charge line_total
insurance_companies	EXISTS	1	insurance_company_id company_name company_code contact_number status
channeling_rooms	EXISTS	0	room_id branch_id room_name room_code location status notes
admission_floors	EXISTS	1	floor_id branch_id floor_name sort_order status
admission_room_types	EXISTS	1	room_type_id branch_id type_name daily_rate max_occupancy is_vip facilities status
admission_rooms	EXISTS	5	room_id branch_id floor_id room_type_id room_number room_name bed_count status
admissions	EXISTS	0	admission_id admission_no bht_number etu_number branch_id patient_id room_id room_rate age_years age_months age_days guardian_name guardian_relationship guardian_mobile has_insurance insurance_company_id admitted_at discharged_at status
admission_room_allocations	EXISTS	0	allocation_id admission_id room_id room_label room_type_name daily_rate days_override started_at ended_at status
admission_deposits	EXISTS	0	deposit_id admission_id deposit_no deposit_date amount status payment_method cash_amount card_amount reference_no paid_at paid_by
admission_charge_items	EXISTS	0	charge_item_id admission_id charge_source charge_category doctor_id charge_date description qty unit_price amount status
admission_final_bills	EXISTS	0	final_bill_id admission_id final_bill_no branch_id bill_date subtotal_amount deposit_amount net_amount status payment_method
patient_allergies	EXISTS	0	allergy_id patient_id drug_allergies food_allergies other_comments remarks recorded_by
tbl_members	EXISTS	0	id MemberType MemberNo DivitionNo GramaDivition NICNo IDType FullName NamewithINI PermanantAdd Address1 Address2 DOB Occupation Email ContactNo Age MaritalStaus Gender EngName EngAddress MemberStatus SaveDate Status
tbl_member_dependants	EXISTS	0	id MemberNo DependentName DAdd LineNumber LineDistrinutionNo DepnedentName DRelation DDOB DNIC
membership_member_profiles	EXISTS	0	profile_id member_id photo_path created_at updated_at
membership_divisions	EXISTS	0	division_id division_name status created_at updated_at
membership_grama_divisions	EXISTS	0	grama_id division_id grama_name status created_at updated_at
audit_logs	EXISTS	30	log_id user_id action table_name
user_sessions	EXISTS	0	id user_id session_token expires_at
csrf_tokens	EXISTS	0	id token expires_at

Roles

Role Name	Status
Admin	EXISTS
Reception	EXISTS
Assistant	EXISTS
Doctor	EXISTS
Pharmacy	EXISTS
Admission	EXISTS
Main Drug Stores	EXISTS
General Stores	EXISTS
Indoor Dispensary	EXISTS
OPD Dispensary	EXISTS
Theatre	EXISTS
Endoscopy	EXISTS
Channeling	EXISTS
Membership	EXISTS

Views

View Name	Status
v_todays_sessions	EXISTS
v_patient_history	EXISTS

Procedures

No required procedures configured in this checker.

System Settings

Setting Key	Status	Current Value	Expected Default
institute_charge_amount	EXISTS	0.00	0.00
membership_discount_type	EXISTS	percent	none
membership_discount_value	EXISTS	5.00	0.00

All Existing Views (Auto-Detected)

v_patient_history v_todays_sessions

All Existing Procedures (Auto-Detected)

No procedures found in current database.