# linuxpreachers/bbdda2026c1com5600linuxpreachersa architecture

> Architecture diagram of the GitHub repository linuxpreachers/bbdda2026c1com5600linuxpreachersa, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-20). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa
- Repository: https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa

## Overview

This repository combines a SQL Server park-management system with a small web interface for browsing and maintaining parks. The user workflow is browser requests to the Express service, which routes park or park-type operations through controllers and repositories to SQL Server. The README also documents SQL modules for parks, employees, activities, reservations, payments, concessions, roles, imports, and reports. SQL-module connections reflect only documented execution order; their internal behavior was not sampled.

Main entry points: [`SGPN/Reinicio.sql`](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/SGPN/Reinicio.sql) (Database setup), [`App/app.js`](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/app.js) (Express service), [`App/parque/parqueRepository.js`](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/parque/parqueRepository.js) (Park repository), [`App/tipo-parque/tipoParqueRepository.js`](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/tipo-parque/tipoParqueRepository.js) (Type repository)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Web application"]
  node_webui["Park interface<br/>[app.js]"]
  node_service["Express service<br/>[app.js]"]
  node_park_routes["Park routes<br/>[parqueRoutes.js]"]
  node_park_controller["Park controller"]
  node_park_repository["Park repository"]
  node_db_connection["DB connection<br/>[conexion.js]"]
end

subgraph group_database["SQL Server system"]
  node_reset["Database setup<br/>[Reinicio.sql]"]
  node_parks_sql["Parks module"]
  node_activities_sql["Activities module"]
  node_employees_sql["Employees module"]
  node_reservations_sql["Reservations module"]
  node_payments_sql["Payments module"]
  node_concessions_sql["Concessions module"]
  node_roles_sql["Roles and logins"]
  node_imports["Data imports"]
  node_reports["Reports and APIs<br/>[0804-Reportes.sql]"]
end

subgraph group_reference["Reference data"]
  node_type_routes["Type routes"]
  node_type_controller["Type controller"]
  node_type_repository["Type repository"]
end

node_visitor(("Browser user"))
node_sqlserver[("SQL Server")]

node_visitor -->|"uses"| node_webui
node_webui -->|"fetches API"| node_service
node_service -->|"mounts routes"| node_park_routes
node_service -->|"mounts routes"| node_type_routes
node_park_routes -->|"dispatches"| node_park_controller
node_park_controller -->|"calls"| node_park_repository
node_park_repository -->|"gets pool"| node_db_connection
node_type_routes -->|"dispatches"| node_type_controller
node_type_controller -->|"calls"| node_type_repository
node_type_repository -->|"gets pool"| node_db_connection
node_park_repository -->|"queries and executes"| node_sqlserver
node_type_repository -->|"queries"| node_sqlserver
node_reset -->|"runs first"| node_parks_sql
node_reset -->|"runs after parks"| node_activities_sql
node_reset -->|"runs after activities"| node_employees_sql
node_reset -->|"runs after employees"| node_reservations_sql
node_reset -->|"runs after reservations"| node_payments_sql
node_reset -->|"runs after payments"| node_concessions_sql
node_reset -->|"runs after concessions"| node_roles_sql
node_reset -->|"runs imports"| node_imports
node_reset -->|"runs reports"| node_reports

click node_webui "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/public/app.js"
click node_service "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/app.js"
click node_park_routes "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/parque/parqueRoutes.js"
click node_park_controller "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/parque/parqueController.js"
click node_park_repository "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/parque/parqueRepository.js"
click node_db_connection "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/conexion.js"
click node_type_routes "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/tipo-parque/tipoParqueRoutes.js"
click node_type_controller "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/tipo-parque/tipoParqueController.js"
click node_type_repository "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/tipo-parque/tipoParqueRepository.js"
click node_reset "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/SGPN/Reinicio.sql"
click node_parks_sql "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Parques"
click node_activities_sql "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Actividades"
click node_employees_sql "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Empleados"
click node_reservations_sql "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Reservas"
click node_payments_sql "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Pagos"
click node_concessions_sql "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Concesiones"
click node_roles_sql "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Roles"
click node_imports "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/SGPN/Modulos/Parques/0105-Importacion.sql"
click node_reports "https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/SGPN/0804-Reportes.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_webui,node_service,node_park_routes,node_park_controller,node_park_repository,node_db_connection,node_visitor toneBlue
class node_reset,node_parks_sql,node_activities_sql,node_employees_sql,node_reservations_sql,node_payments_sql,node_concessions_sql,node_roles_sql,node_imports,node_reports,node_sqlserver toneAmber
class node_type_routes,node_type_controller,node_type_repository toneMint
```

## Components

### Web application

- [Park interface](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/public/app.js): `App/public/app.js`
- [Express service](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/app.js): `App/app.js`
- [Park routes](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/parque/parqueRoutes.js): `App/parque/parqueRoutes.js`
- [Park controller](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/parque/parqueController.js): `App/parque/parqueController.js`
- [Park repository](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/parque/parqueRepository.js): `App/parque/parqueRepository.js`
- [DB connection](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/conexion.js): `App/conexion.js`

### SQL Server system

- [Database setup](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/SGPN/Reinicio.sql): `SGPN/Reinicio.sql`
- [Parks module](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Parques): `SGPN/Modulos/Parques`
- [Activities module](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Actividades): `SGPN/Modulos/Actividades`
- [Employees module](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Empleados): `SGPN/Modulos/Empleados`
- [Reservations module](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Reservas): `SGPN/Modulos/Reservas`
- [Payments module](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Pagos): `SGPN/Modulos/Pagos`
- [Concessions module](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Concesiones): `SGPN/Modulos/Concesiones`
- [Roles and logins](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/tree/main/SGPN/Modulos/Roles): `SGPN/Modulos/Roles`
- [Data imports](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/SGPN/Modulos/Parques/0105-Importacion.sql): `SGPN/Modulos/Parques/0105-Importacion.sql`
- [Reports and APIs](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/SGPN/0804-Reportes.sql): `SGPN/0804-Reportes.sql`

### Reference data

- [Type routes](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/tipo-parque/tipoParqueRoutes.js): `App/tipo-parque/tipoParqueRoutes.js`
- [Type controller](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/tipo-parque/tipoParqueController.js): `App/tipo-parque/tipoParqueController.js`
- [Type repository](https://github.com/linuxpreachers/bbdda2026c1com5600linuxpreachersa/blob/main/App/tipo-parque/tipoParqueRepository.js): `App/tipo-parque/tipoParqueRepository.js`

### Other components

- **Browser user**
- **SQL Server**

## Connections

- Browser user → Park interface: uses (evidence: `README.md`)
- Park interface → Express service: fetches API (evidence: `App/public/app.js`)
- Express service → Park routes: mounts routes (evidence: `App/app.js`)
- Express service → Type routes: mounts routes (evidence: `App/app.js`)
- Park routes → Park controller: dispatches (evidence: `App/parque/parqueRoutes.js`)
- Park controller → Park repository: calls (evidence: `App/parque/parqueController.js`)
- Park repository → DB connection: gets pool (evidence: `App/parque/parqueRepository.js`)
- Type routes → Type controller: dispatches (evidence: `App/tipo-parque/tipoParqueRoutes.js`)
- Type controller → Type repository: calls (evidence: `App/tipo-parque/tipoParqueController.js`)
- Type repository → DB connection: gets pool (evidence: `App/tipo-parque/tipoParqueRepository.js`)
- Park repository → SQL Server: queries and executes (evidence: `App/parque/parqueRepository.js`)
- Type repository → SQL Server: queries (evidence: `App/tipo-parque/tipoParqueRepository.js`)
- Database setup → Parks module: runs first (evidence: `README.md`)
- Database setup → Activities module: runs after parks (evidence: `README.md`)
- Database setup → Employees module: runs after activities (evidence: `README.md`)
- Database setup → Reservations module: runs after employees (evidence: `README.md`)
- Database setup → Payments module: runs after reservations (evidence: `README.md`)
- Database setup → Concessions module: runs after payments (evidence: `README.md`)
- Database setup → Roles and logins: runs after concessions (evidence: `README.md`)
- Database setup → Data imports: runs imports (evidence: `README.md`)
- Database setup → Reports and APIs: runs reports (evidence: `README.md`)
