[SQL Course ]: Final Project

🏥 |ClinicalSYS Database| 📋

INDICE

1. CREACION DB ClinicalSYS
2. [VIEWS]
3. [FUNCTIONS]
4. [TRIGGERS]
5. [STORED PROCEDURES]
6. [INSERT DATA]
7. [PDF] DOCUMENTATION FILE

📋 Schema Overview

The ClinicalSYS database schema is designed to manage different aspects of a medical system. It includes tables for areas, doctors, administrative staff, patients, appointments, treatments, payment history, and more.

📊 Table Descriptions

1. area: Stores information about medical areas or specialties.

2. medico: Contains details of medical professionals, including their assigned area.

3. administrativo: Stores administrative staff information.

4. asignacion_medico_administrativo: Manages the assignment of medical professionals to administrative staff.

5. paciente: Stores patient information, including contact details.

6. estado_turno: Manages different states of appointments.

7. estado_pago: Records different payment states.

8. metodo_pago: Stores payment methods.

9. turno: Manages appointment scheduling, including patient, doctor, and payment information.

10. tratamiento: Contains information about medical treatments, including doctors and patients involved.

11. tipo_transaccion: Records different types of transactions.

12. historial_facturacion_turno: Maintains payment history for appointments.

13. historial_facturacion_tratamiento: Keeps payment history for treatments.

14. log_paciente: Logs patient-related operations.

15. log_turno: Logs appointment-related operations.

Feedback

This project was created for the final project of the SQL course at Coderhouse. If you have any comments or suggestions, feel free to contact me.

🔗 Links