How aryaa-pawar/prakritiopd-dbms works
PrakritiOPD is a MySQL database project for managing a Panchakarma outpatient clinic, rather than an application with a separate user interface. Its documented workflow covers patient and appointment records, treatment planning and therapy sessions, inventory use, and billing and payments, with staff management as a supporting capability. SQL files define the schema, sample data, queries, views, procedures, and triggers. The README documents how these files are run, but source excerpts were unavailable, so internal call wiring is not inferred.
Main entry points: schema.sql Clinic schema · data.sql Sample records · procedures.sql Stored procedures · triggers.sql Business triggers
Components 9
Clinic data model
- Clinic schema
schema.sql - Sample records
data.sql
Database automation
- Stored procedures
procedures.sql - Business triggers
triggers.sql
Queries and reporting
- Reporting views
views.sql - Operational queries
queries.sql - Demo queries
demo_queries.sql
Other components
- Database operator
- MySQL database
Connections 14
- Database operator → Clinic schema: runs first
- Database operator → Sample records: loads records
- Database operator → Reporting views: installs views
- Database operator → Stored procedures: installs procedures
- Database operator → Business triggers: installs triggers
- Database operator → Operational queries: runs queries
- Database operator → Demo queries: runs examples
- Clinic schema → MySQL database: defines tables
- Sample records → MySQL database: inserts records
- Reporting views → MySQL database: defines views
- Stored procedures → MySQL database: defines procedures
- Business triggers → MySQL database: defines triggers
- Operational queries → MySQL database: queries data
- Demo queries → MySQL database: queries data