# Database Tables Summary

## Core
- users
- roles
- user_menu_privileges
- organization_settings

## Patient / Doctor
- patients
- doctors
- doctor_schedules
- appointments
- vitals
- prescriptions
- prescription_medicines

## Billing
- investigation_groups
- investigations
- investigation_consumables
- referrals
- invoices
- invoice_items
- payments

## Inventory
- inventory_items
- stock_movements
- suppliers
- purchase_orders
- purchase_order_items
- grns
- grn_items

## Lab / Radiology
- samples
- lab_reports
- radiology_reports

## Important Relationships

- invoice belongs to patient
- invoice has many invoice_items
- invoice_item belongs to investigation
- investigation has many consumables
- consumable belongs to inventory item
- sample belongs to invoice and invoice item
- lab report belongs to invoice and invoice item
- user has many user_menu_privileges