# rigo-godoy/proyecto-final-bdd architecture

> Architecture diagram of the GitHub repository rigo-godoy/proyecto-final-bdd, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-02). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/rigo-godoy/proyecto-final-bdd
- Repository: https://github.com/rigo-godoy/proyecto-final-bdd

## Overview

This is a console-based medical patient manager. The main workflow accepts patient details or an operation from the user, coordinates patient CRUD through a DAO, and accesses MariaDB over JDBC. The documented SQL setup also defines the wider Patients–Appointments–Payments schema and optional stored procedures for daily sales, current patients, and patient insertion; these are distinct from the Java menu. The source excerpts support the Java calls and schema relationships, but do not show the SQL script contents directly.

Main entry points: [`src/main/java/Proyecto_Final_bdd/PacienteDAO.java`](https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/src/main/java/Proyecto_Final_bdd/PacienteDAO.java) (Patient CRUD), [`src/main/java/Proyecto_Final_bdd/Main.java`](https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/src/main/java/Proyecto_Final_bdd/Main.java) (Menu coordinator), [`appHospital.sql`](https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/appHospital.sql) (Hospital schema), [`pl_sql.sql`](https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/pl_sql.sql) (Stored procedures)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_console["Console workflow"]
  node_main["Menu coordinator<br/>[Main.java]"]
end

subgraph group_patient["Patient operations"]
  node_patient_model["Patient model<br/>[Paciente.java]"]
  node_patient_dao["Patient CRUD<br/>[PacienteDAO.java]"]
end

subgraph group_database["Database access"]
  node_connection["JDBC connection<br/>[ConexionSQL.java]"]
  node_mariadb[("MariaDB")]
end

subgraph group_sql["SQL capabilities"]
  node_schema[("Hospital schema<br/>[appHospital.sql]")]
  node_procedures["Stored procedures<br/>[pl_sql.sql]"]
end

node_user(("Console user"))

node_user -->|"enters choices"| node_main
node_main -->|"dispatches CRUD"| node_patient_dao
node_main -->|"builds patient"| node_patient_model
node_patient_dao -->|"reads fields"| node_patient_model
node_patient_dao -->|"opens connection"| node_connection
node_connection -->|"connects JDBC"| node_mariadb
node_patient_dao -->|"queries patients"| node_schema
node_schema -.->|"creates schema"| node_mariadb
node_procedures -->|"uses tables"| node_schema
node_procedures -.->|"defines procedures"| node_mariadb

click node_main "https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/src/main/java/Proyecto_Final_bdd/Main.java"
click node_patient_model "https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/src/main/java/Proyecto_Final_bdd/Paciente.java"
click node_patient_dao "https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/src/main/java/Proyecto_Final_bdd/PacienteDAO.java"
click node_connection "https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/src/main/java/Proyecto_Final_bdd/ConexionSQL.java"
click node_schema "https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/appHospital.sql"
click node_procedures "https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/pl_sql.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_main,node_user toneBlue
class node_patient_model,node_patient_dao toneAmber
class node_connection,node_mariadb toneMint
class node_schema,node_procedures toneRose
```

## Components

### Console workflow

- [Menu coordinator](https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/src/main/java/Proyecto_Final_bdd/Main.java): `src/main/java/Proyecto_Final_bdd/Main.java`

### Patient operations

- [Patient model](https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/src/main/java/Proyecto_Final_bdd/Paciente.java): `src/main/java/Proyecto_Final_bdd/Paciente.java`
- [Patient CRUD](https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/src/main/java/Proyecto_Final_bdd/PacienteDAO.java): `src/main/java/Proyecto_Final_bdd/PacienteDAO.java`

### Database access

- [JDBC connection](https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/src/main/java/Proyecto_Final_bdd/ConexionSQL.java): `src/main/java/Proyecto_Final_bdd/ConexionSQL.java`
- **MariaDB**

### SQL capabilities

- [Hospital schema](https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/appHospital.sql): `appHospital.sql`
- [Stored procedures](https://github.com/rigo-godoy/proyecto-final-bdd/blob/main/pl_sql.sql): `pl_sql.sql`

### Other components

- **Console user**

## Connections

- Console user → Menu coordinator: enters choices (evidence: `src/main/java/Proyecto_Final_bdd/Main.java`)
- Menu coordinator → Patient CRUD: dispatches CRUD (evidence: `src/main/java/Proyecto_Final_bdd/Main.java`)
- Menu coordinator → Patient model: builds patient (evidence: `src/main/java/Proyecto_Final_bdd/Main.java`)
- Patient CRUD → Patient model: reads fields (evidence: `src/main/java/Proyecto_Final_bdd/PacienteDAO.java`)
- Patient CRUD → JDBC connection: opens connection (evidence: `src/main/java/Proyecto_Final_bdd/PacienteDAO.java`)
- JDBC connection → MariaDB: connects JDBC (evidence: `README.md`)
- Patient CRUD → Hospital schema: queries patients (evidence: `README.md`)
- Hospital schema → MariaDB: creates schema (evidence: `README.md`)
- Stored procedures → Hospital schema: uses tables (evidence: `README.md`)
- Stored procedures → MariaDB: defines procedures (evidence: `README.md`)
