# wanwisa2548/purrpetcare-web architecture

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

- Interactive diagram: https://gitdiagram.com/wanwisa2548/purrpetcare-web
- Repository: https://github.com/wanwisa2548/purrpetcare-web

## Overview

PurrPet Care is a customer-facing pet hotel and grooming booking website with an admin operations area, backed by SQL Server. Customers register or sign in, manage pet profiles, check grooming prices and room/groomer availability, create bookings, and track their status. Admins manage bookings, grooming schedules, room turnover, payments, and dashboard information. The Express server serves the web pages and routes API requests; route handlers use a shared SQL access layer. README documents database features implemented in SQL scripts, but those scripts were not sampled, so their internal relationships are not expanded here.

Main entry points: [`src/server.js`](https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/server.js) (Express server), [`src/db.js`](https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/db.js) (SQL access layer), [`public`](https://github.com/wanwisa2548/purrpetcare-web/tree/main/public) (Customer pages), [`public/js/common.js`](https://github.com/wanwisa2548/purrpetcare-web/blob/main/public/js/common.js) (Shared UI helpers)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Web interface"]
  node_customer_pages["Customer pages"]
  node_login_pages["Login pages"]
  node_admin_pages["Admin pages"]
  node_shared_ui["Shared UI helpers<br/>[common.js]"]
end

subgraph group_server["Web server"]
  node_express_server["Express server<br/>[server.js]"]
end

subgraph group_customer["Customer services"]
  node_auth_routes["Authentication<br/>[auth.js]"]
  node_customer_routes["Catalog, pets, booking<br/>[customer.js]"]
end

subgraph group_operations["Admin operations"]
  node_admin_routes["Admin endpoints<br/>[admin.js]"]
end

subgraph group_data["SQL data layer"]
  node_db_access["SQL access layer<br/>[db.js]"]
  node_db_schema["Database schema"]
  node_db_logic["Views and procedures"]
  node_db_security["Web login security"]
end

node_customer_actor(("Customer"))
node_admin_actor(("Admin"))
node_sql_server[("SQL Server")]

node_customer_actor -->|"uses"| node_customer_pages
node_customer_actor -->|"signs in"| node_login_pages
node_admin_actor -->|"uses"| node_admin_pages
node_customer_pages -.->|"uses"| node_shared_ui
node_login_pages -.->|"uses"| node_shared_ui
node_admin_pages -.->|"uses"| node_shared_ui
node_customer_pages -->|"loads pages"| node_express_server
node_login_pages -->|"loads pages"| node_express_server
node_admin_pages -->|"loads pages"| node_express_server
node_express_server -->|"mounts routes"| node_auth_routes
node_express_server -->|"mounts routes"| node_customer_routes
node_express_server -->|"mounts routes"| node_admin_routes
node_auth_routes -->|"calls"| node_db_access
node_customer_routes -->|"calls"| node_db_access
node_admin_routes -->|"calls"| node_db_access
node_db_access -->|"connects"| node_sql_server
node_db_schema -->|"defines schema"| node_sql_server
node_db_logic -->|"defines data logic"| node_sql_server
node_db_security -->|"configures login"| node_sql_server

click node_customer_pages "https://github.com/wanwisa2548/purrpetcare-web/tree/main/public"
click node_login_pages "https://github.com/wanwisa2548/purrpetcare-web/tree/main/public"
click node_admin_pages "https://github.com/wanwisa2548/purrpetcare-web/tree/main/public"
click node_shared_ui "https://github.com/wanwisa2548/purrpetcare-web/blob/main/public/js/common.js"
click node_express_server "https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/server.js"
click node_auth_routes "https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/routes/auth.js"
click node_customer_routes "https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/routes/customer.js"
click node_admin_routes "https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/routes/admin.js"
click node_db_access "https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/db.js"
click node_db_schema "https://github.com/wanwisa2548/purrpetcare-web/blob/main/database/PurrPetCare_Phase1.sql"
click node_db_logic "https://github.com/wanwisa2548/purrpetcare-web/blob/main/database/PurrPetCare_Phase2.sql"
click node_db_security "https://github.com/wanwisa2548/purrpetcare-web/blob/main/database/PurrPetCare_WebLogin.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_customer_pages,node_login_pages,node_admin_pages,node_shared_ui toneBlue
class node_express_server,node_sql_server toneAmber
class node_auth_routes,node_customer_routes toneMint
class node_admin_routes toneRose
class node_db_access,node_db_schema,node_db_logic,node_db_security,node_customer_actor,node_admin_actor toneIndigo
```

## Components

### Web interface

- [Customer pages](https://github.com/wanwisa2548/purrpetcare-web/tree/main/public): `public`
- [Login pages](https://github.com/wanwisa2548/purrpetcare-web/tree/main/public): `public`
- [Admin pages](https://github.com/wanwisa2548/purrpetcare-web/tree/main/public): `public`
- [Shared UI helpers](https://github.com/wanwisa2548/purrpetcare-web/blob/main/public/js/common.js): `public/js/common.js`

### Web server

- [Express server](https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/server.js): `src/server.js`

### Customer services

- [Authentication](https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/routes/auth.js): `src/routes/auth.js`
- [Catalog, pets, booking](https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/routes/customer.js): `src/routes/customer.js`

### Admin operations

- [Admin endpoints](https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/routes/admin.js): `src/routes/admin.js`

### SQL data layer

- [SQL access layer](https://github.com/wanwisa2548/purrpetcare-web/blob/main/src/db.js): `src/db.js`
- [Database schema](https://github.com/wanwisa2548/purrpetcare-web/blob/main/database/PurrPetCare_Phase1.sql): `database/PurrPetCare_Phase1.sql`
- [Views and procedures](https://github.com/wanwisa2548/purrpetcare-web/blob/main/database/PurrPetCare_Phase2.sql): `database/PurrPetCare_Phase2.sql`
- [Web login security](https://github.com/wanwisa2548/purrpetcare-web/blob/main/database/PurrPetCare_WebLogin.sql): `database/PurrPetCare_WebLogin.sql`

### Other components

- **Customer**
- **Admin**
- **SQL Server**

## Connections

- Customer → Customer pages: uses (evidence: `README.md`)
- Customer → Login pages: signs in (evidence: `README.md`)
- Admin → Admin pages: uses (evidence: `README.md`)
- Customer pages → Shared UI helpers: uses
- Login pages → Shared UI helpers: uses
- Admin pages → Shared UI helpers: uses
- Customer pages → Express server: loads pages (evidence: `src/server.js`)
- Login pages → Express server: loads pages (evidence: `src/server.js`)
- Admin pages → Express server: loads pages (evidence: `src/server.js`)
- Express server → Authentication: mounts routes (evidence: `src/server.js`)
- Express server → Catalog, pets, booking: mounts routes (evidence: `src/server.js`)
- Express server → Admin endpoints: mounts routes (evidence: `src/server.js`)
- Authentication → SQL access layer: calls (evidence: `src/routes/auth.js`)
- Catalog, pets, booking → SQL access layer: calls (evidence: `src/routes/customer.js`)
- Admin endpoints → SQL access layer: calls (evidence: `src/routes/admin.js`)
- SQL access layer → SQL Server: connects (evidence: `src/db.js`)
- Database schema → SQL Server: defines schema (evidence: `README.md`)
- Views and procedures → SQL Server: defines data logic (evidence: `README.md`)
- Web login security → SQL Server: configures login (evidence: `README.md`)
