# jonatasbispo/sistema-agendamento-devmedia architecture

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

- Interactive diagram: https://gitdiagram.com/jonatasbispo/sistema-agendamento-devmedia
- Repository: https://github.com/jonatasbispo/sistema-agendamento-devmedia

## Overview

This repository documents a PostgreSQL schema for a beauty-services appointment system, not an application workflow. Its central domain record is an appointment linking a client, professional, and service; client contact details are modeled separately. The README also describes staff and employee records. Relationships below follow the documented foreign keys; no SQL excerpts were provided to verify implementation details beyond that documentation.

Main entry points: [`projetodevmedia.sql`](https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql) (Appointments)

## Diagram (Mermaid)

```mermaid
flowchart TD

node_clients[("Clients")]
node_client_info[("Client Contact")]
node_professionals[("Professionals")]
node_services[("Service Catalog")]
node_appointments[("Appointments")]
node_employees[("Employees")]

node_client_info -->|"references client"| node_clients
node_appointments -->|"references client"| node_clients
node_appointments -->|"references professional"| node_professionals
node_appointments -->|"references service"| node_services

click node_clients "https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql"
click node_client_info "https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql"
click node_professionals "https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql"
click node_services "https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql"
click node_appointments "https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql"
click node_employees "https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.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_clients,node_client_info,node_professionals,node_services,node_appointments,node_employees toneAmber
```

## Components

### Other components

- [Clients](https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql): `projetodevmedia.sql`
- [Client Contact](https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql): `projetodevmedia.sql`
- [Professionals](https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql): `projetodevmedia.sql`
- [Service Catalog](https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql): `projetodevmedia.sql`
- [Appointments](https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql): `projetodevmedia.sql`
- [Employees](https://github.com/jonatasbispo/sistema-agendamento-devmedia/blob/main/projetodevmedia.sql): `projetodevmedia.sql`

## Connections

- Client Contact → Clients: references client (evidence: `README.md`)
- Appointments → Clients: references client (evidence: `README.md`)
- Appointments → Professionals: references professional (evidence: `README.md`)
- Appointments → Service Catalog: references service (evidence: `README.md`)