How jackson04-dev/dentalapp-database works
This repository is the database schema for a dental-clinic management system. Its main workflow runs from patient and staff identity through appointment scheduling and check-in, clinical records and treatment, then invoicing and payment. The schema also supports service and treatment-plan catalogs, supplier-linked products, and inventory intake and usage. The README describes these relationships and operational flows; no source excerpts were provided. Although it describes a payment table, none appears in the supplied tree, so it is not represented as a repository component.
Main entry points: 18_lich_hen.sql Appointments · 01_tai_khoan.sql Accounts · 20_ho_so_benh_an.sql Medical Records · 21_hoa_don.sql Invoices
Components 29
Identity and Profiles
Catalog and Inventory
- Services
tables/level_0/02_dich_vu.sql - Service Details
tables/level_1/08_chi_tiet_dich_vu.sql - Products
tables/level_0/03_san_pham.sql - Suppliers
tables/level_0/04_nha_cung_cap.sql - Supplier Products
tables/level_1/12_san_pham_nha_cung_cap.sql - Plan Templates
tables/level_0/05_phac_do_mau.sql - Template Steps
tables/level_1/13_chi_tiet_phac_do_mau.sql - Promotions
tables/level_0/06_khuyen_mai.sql - Stock Receipts
tables/level_2/16_phieu_nhap_kho.sql - Receipt Details
tables/level_3/19_chi_tiet_nhap_kho.sql
Scheduling
- Treatment Rooms
tables/level_0/07_phong_dieu_tri.sql - Dentist Shifts
tables/level_2/15_ca_lam_viec.sql - Appointments
tables/level_3/18_lich_hen.sql
Clinical Care
- Medical Records
tables/level_4/20_ho_so_benh_an.sql - Treatment Services
tables/level_5/23_dich_vu_dieu_tri.sql - Used Materials
tables/level_5/25_vat_tu_su_dung.sql - Prescriptions
tables/level_5/24_don_thuoc.sql - Prescription Details
tables/level_6/26_chi_tiet_don_thuoc.sql - Treatment Plans
tables/level_2/17_phac_do_dieu_tri.sql - Plan Stages
tables/level_4/22_giai_doan_phac_do.sql
Billing
- Invoices
tables/level_4/21_hoa_don.sql
Other components
- Patient / App
- Clinic Staff
- Dentist
Connections 33
- Patient / App → Accounts: registers
readme.md - Accounts → Patients: profiles
readme.md - Clinic Staff → Accounts: creates accounts
readme.md - Accounts → Dentists: creates profile
readme.md - Accounts → Staff: creates profile
readme.md - Services → Service Details: has offerings
readme.md - Plan Templates → Template Steps: has steps
readme.md - Supplier Products → Products: links products
readme.md - Supplier Products → Suppliers: links suppliers
readme.md - Clinic Staff → Dentist Shifts: schedules
readme.md - Dentist Shifts → Treatment Rooms: assigns room
readme.md - Dentist Shifts → Dentists: assigns dentist
readme.md - Patient / App → Appointments: books
readme.md - Appointments → Patients: identifies patient
readme.md - Appointments → Dentists: selects dentist
readme.md - Appointments → Services: selects service
readme.md - Dentist → Medical Records: documents visit
readme.md - Appointments → Medical Records: starts visit record
readme.md - Medical Records → Treatment Services: records services
readme.md - Medical Records → Used Materials: records consumption
readme.md - Medical Records → Prescriptions: records prescription
readme.md - Prescriptions → Prescription Details: contains items
readme.md - Dentist → Treatment Plans: creates plan
readme.md - Plan Templates → Treatment Plans: seeds plan
readme.md - Treatment Plans → Plan Stages: defines stages
readme.md - Clinic Staff → Stock Receipts: creates receipt
readme.md - Stock Receipts → Receipt Details: records lots
readme.md - Receipt Details → Products: updates stock
readme.md - Used Materials → Products: deducts stock
readme.md - Clinic Staff → Invoices: issues invoice
readme.md - Invoices → Appointments: references visit
readme.md - Invoices → Treatment Plans: may bill plan
readme.md - Invoices → Plan Stages: settles stages
readme.md