# diogoslsceno/testes-sql architecture

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

- Interactive diagram: https://gitdiagram.com/diogoslsceno/testes-sql
- Repository: https://github.com/diogoslsceno/testes-sql

## Overview

This is a small personal collection of MySQL study notes and practical SQL exercises, not an application with a runtime workflow. The four scripts cover clinic, school, sales, and streaming topics; the README identifies MySQL Server 8.4 as the database environment. No source excerpts were provided, so relationships are limited to what the README documents.

Main entry points: [`Testes/clinica.sql`](https://github.com/diogoslsceno/testes-sql/blob/main/Testes/clinica.sql) (Clinic SQL), [`Testes/escola_tech.sql`](https://github.com/diogoslsceno/testes-sql/blob/main/Testes/escola_tech.sql) (Tech School SQL), [`Testes/loja_vendas.sql`](https://github.com/diogoslsceno/testes-sql/blob/main/Testes/loja_vendas.sql) (Sales SQL), [`Testes/streaming.sql`](https://github.com/diogoslsceno/testes-sql/blob/main/Testes/streaming.sql) (Streaming SQL)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_exercises["SQL Exercises"]
  node_clinic["Clinic SQL<br/>[clinica.sql]"]
  node_school["Tech School SQL<br/>[escola_tech.sql]"]
  node_sales["Sales SQL<br/>[loja_vendas.sql]"]
  node_streaming["Streaming SQL<br/>[streaming.sql]"]
end

subgraph group_notes["Study Notes"]
  node_context["Learning Context<br/>[CONTEXT.md]"]
end

node_learner(("SQL Learner"))
node_mysql[("MySQL Server")]

node_learner -->|"studies"| node_clinic
node_learner -->|"studies"| node_school
node_learner -->|"studies"| node_sales
node_learner -->|"studies"| node_streaming
node_learner -->|"reviews"| node_context
node_clinic -->|"uses environment"| node_mysql
node_school -->|"uses environment"| node_mysql
node_sales -->|"uses environment"| node_mysql
node_streaming -->|"uses environment"| node_mysql

click node_clinic "https://github.com/diogoslsceno/testes-sql/blob/main/Testes/clinica.sql"
click node_school "https://github.com/diogoslsceno/testes-sql/blob/main/Testes/escola_tech.sql"
click node_sales "https://github.com/diogoslsceno/testes-sql/blob/main/Testes/loja_vendas.sql"
click node_streaming "https://github.com/diogoslsceno/testes-sql/blob/main/Testes/streaming.sql"
click node_context "https://github.com/diogoslsceno/testes-sql/blob/main/Contexts/CONTEXT.md"

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_clinic,node_school,node_sales,node_streaming toneBlue
class node_context,node_mysql toneAmber
class node_learner toneIndigo
```

## Components

### SQL Exercises

- [Clinic SQL](https://github.com/diogoslsceno/testes-sql/blob/main/Testes/clinica.sql): `Testes/clinica.sql`
- [Tech School SQL](https://github.com/diogoslsceno/testes-sql/blob/main/Testes/escola_tech.sql): `Testes/escola_tech.sql`
- [Sales SQL](https://github.com/diogoslsceno/testes-sql/blob/main/Testes/loja_vendas.sql): `Testes/loja_vendas.sql`
- [Streaming SQL](https://github.com/diogoslsceno/testes-sql/blob/main/Testes/streaming.sql): `Testes/streaming.sql`

### Study Notes

- [Learning Context](https://github.com/diogoslsceno/testes-sql/blob/main/Contexts/CONTEXT.md): `Contexts/CONTEXT.md`

### Other components

- **SQL Learner**
- **MySQL Server**

## Connections

- SQL Learner → Clinic SQL: studies (evidence: `README.md`)
- SQL Learner → Tech School SQL: studies (evidence: `README.md`)
- SQL Learner → Sales SQL: studies (evidence: `README.md`)
- SQL Learner → Streaming SQL: studies (evidence: `README.md`)
- SQL Learner → Learning Context: reviews (evidence: `README.md`)
- Clinic SQL → MySQL Server: uses environment (evidence: `README.md`)
- Tech School SQL → MySQL Server: uses environment (evidence: `README.md`)
- Sales SQL → MySQL Server: uses environment (evidence: `README.md`)
- Streaming SQL → MySQL Server: uses environment (evidence: `README.md`)