# pedroaugustopivetta/sql-mastery-hub architecture

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

- Interactive diagram: https://gitdiagram.com/pedroaugustopivetta/sql-mastery-hub
- Repository: https://github.com/pedroaugustopivetta/sql-mastery-hub

## Overview

This repository is a portfolio of five PostgreSQL relational-database scenarios, not a single application workflow. Each project documents a schema-definition stage (DDL), data-population and modification stage (DML), and query/analytics stage (DQL), applied to its domain database. The README names the principal entities and capabilities; no SQL excerpts were available, so the graph reflects those documented relationships without inferring finer-grained query or execution behavior.

Main entry points: [`E-Commerce/DDL - E-Commerce - Query.sql`](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Commerce/DDL%20-%20E-Commerce%20-%20Query.sql) (Schema DDL), [`E-Commerce/DML - E-Commerce - Query.sql`](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Commerce/DML%20-%20E-Commerce%20-%20Query.sql) (Sales Data DML), [`E-Commerce/DQL - E-Commerce - Query.sql`](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Commerce/DQL%20-%20E-Commerce%20-%20Query.sql) (Sales Queries), [`E-Learning/DDL - E-Learning - Query.sql`](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Learning/DDL%20-%20E-Learning%20-%20Query.sql) (Schema DDL)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ecommerce["E-Commerce"]
  node_ec_ddl["Schema DDL"]
  node_ec_dml["Sales Data DML"]
  node_ec_dql["Sales Queries"]
  node_ec_db[("Commerce Database")]
end

subgraph group_elearning["E-Learning"]
  node_el_ddl["Schema DDL"]
  node_el_dml["Learning Data DML"]
  node_el_dql["Learning Queries"]
  node_el_db[("Learning Database")]
end

subgraph group_streaming["Streaming"]
  node_st_ddl["Schema DDL"]
  node_st_dml["Streaming Data DML"]
  node_st_dql["Streaming Queries"]
  node_st_db[("Streaming Database")]
end

subgraph group_clinic["Medical Clinic"]
  node_mc_ddl["Schema DDL"]
  node_mc_dml["Clinic Data DML"]
  node_mc_dql["Clinic Queries"]
  node_mc_db[("Clinic Database")]
end

subgraph group_finance["Finance App"]
  node_fa_ddl["Schema DDL"]
  node_fa_dml["Finance Data DML"]
  node_fa_dql["Finance Queries"]
  node_fa_db[("Finance Database")]
end

node_ec_ddl -->|"defines schema"| node_ec_db
node_ec_dml -->|"writes data"| node_ec_db
node_ec_dql -->|"queries data"| node_ec_db
node_el_ddl -->|"defines schema"| node_el_db
node_el_dml -->|"writes data"| node_el_db
node_el_dql -->|"queries data"| node_el_db
node_st_ddl -->|"defines schema"| node_st_db
node_st_dml -->|"writes data"| node_st_db
node_st_dql -->|"queries data"| node_st_db
node_mc_ddl -->|"defines schema"| node_mc_db
node_mc_dml -->|"writes data"| node_mc_db
node_mc_dql -->|"queries data"| node_mc_db
node_fa_ddl -->|"defines schema"| node_fa_db
node_fa_dml -->|"writes data"| node_fa_db
node_fa_dql -->|"queries data"| node_fa_db

click node_ec_ddl "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Commerce/DDL%20-%20E-Commerce%20-%20Query.sql"
click node_ec_dml "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Commerce/DML%20-%20E-Commerce%20-%20Query.sql"
click node_ec_dql "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Commerce/DQL%20-%20E-Commerce%20-%20Query.sql"
click node_el_ddl "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Learning/DDL%20-%20E-Learning%20-%20Query.sql"
click node_el_dml "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Learning/DML%20-%20E-Learning%20-%20Query.sql"
click node_el_dql "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Learning/DQL%20-%20E-Learning%20-%20Query.sql"
click node_st_ddl "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/Streaming/DDL%20-%20Streaming%20-%20Query.sql"
click node_st_dml "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/Streaming/DML%20-%20Streaming%20-%20Query.sql"
click node_st_dql "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/Streaming/DQL%20-%20Streaming%20-%20Query.sql"
click node_mc_ddl "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/MedicalClinic/DDL%20-%20MedicalClinic%20-%20Query.sql"
click node_mc_dml "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/MedicalClinic/DML%20-%20MedicalClinic%20-%20Query.sql"
click node_mc_dql "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/MedicalClinic/DQL%20-%20MedicalClinic-%20Query.sql"
click node_fa_ddl "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/FinanceApp/DDL%20-%20FinanceApp%20-%20Query.sql"
click node_fa_dml "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/FinanceApp/DML%20-%20FinanceApp%20-%20Query.sql"
click node_fa_dql "https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/FinanceApp/DQL%20-%20FinanceApp%20-%20Query.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_ec_ddl,node_ec_dml,node_ec_dql,node_ec_db toneBlue
class node_el_ddl,node_el_dml,node_el_dql,node_el_db toneAmber
class node_st_ddl,node_st_dml,node_st_dql,node_st_db toneMint
class node_mc_ddl,node_mc_dml,node_mc_dql,node_mc_db toneRose
class node_fa_ddl,node_fa_dml,node_fa_dql,node_fa_db toneIndigo
```

## Components

### E-Commerce

- [Schema DDL](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Commerce/DDL%20-%20E-Commerce%20-%20Query.sql): `E-Commerce/DDL - E-Commerce - Query.sql`
- [Sales Data DML](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Commerce/DML%20-%20E-Commerce%20-%20Query.sql): `E-Commerce/DML - E-Commerce - Query.sql`
- [Sales Queries](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Commerce/DQL%20-%20E-Commerce%20-%20Query.sql): `E-Commerce/DQL - E-Commerce - Query.sql`
- **Commerce Database**

### E-Learning

- [Schema DDL](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Learning/DDL%20-%20E-Learning%20-%20Query.sql): `E-Learning/DDL - E-Learning - Query.sql`
- [Learning Data DML](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Learning/DML%20-%20E-Learning%20-%20Query.sql): `E-Learning/DML - E-Learning - Query.sql`
- [Learning Queries](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/E-Learning/DQL%20-%20E-Learning%20-%20Query.sql): `E-Learning/DQL - E-Learning - Query.sql`
- **Learning Database**

### Streaming

- [Schema DDL](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/Streaming/DDL%20-%20Streaming%20-%20Query.sql): `Streaming/DDL - Streaming - Query.sql`
- [Streaming Data DML](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/Streaming/DML%20-%20Streaming%20-%20Query.sql): `Streaming/DML - Streaming - Query.sql`
- [Streaming Queries](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/Streaming/DQL%20-%20Streaming%20-%20Query.sql): `Streaming/DQL - Streaming - Query.sql`
- **Streaming Database**

### Medical Clinic

- [Schema DDL](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/MedicalClinic/DDL%20-%20MedicalClinic%20-%20Query.sql): `MedicalClinic/DDL - MedicalClinic - Query.sql`
- [Clinic Data DML](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/MedicalClinic/DML%20-%20MedicalClinic%20-%20Query.sql): `MedicalClinic/DML - MedicalClinic - Query.sql`
- [Clinic Queries](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/MedicalClinic/DQL%20-%20MedicalClinic-%20Query.sql): `MedicalClinic/DQL - MedicalClinic- Query.sql`
- **Clinic Database**

### Finance App

- [Schema DDL](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/FinanceApp/DDL%20-%20FinanceApp%20-%20Query.sql): `FinanceApp/DDL - FinanceApp - Query.sql`
- [Finance Data DML](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/FinanceApp/DML%20-%20FinanceApp%20-%20Query.sql): `FinanceApp/DML - FinanceApp - Query.sql`
- [Finance Queries](https://github.com/pedroaugustopivetta/sql-mastery-hub/blob/main/FinanceApp/DQL%20-%20FinanceApp%20-%20Query.sql): `FinanceApp/DQL - FinanceApp - Query.sql`
- **Finance Database**

## Connections

- Schema DDL → Commerce Database: defines schema
- Sales Data DML → Commerce Database: writes data
- Sales Queries → Commerce Database: queries data
- Schema DDL → Learning Database: defines schema
- Learning Data DML → Learning Database: writes data
- Learning Queries → Learning Database: queries data
- Schema DDL → Streaming Database: defines schema
- Streaming Data DML → Streaming Database: writes data
- Streaming Queries → Streaming Database: queries data
- Schema DDL → Clinic Database: defines schema
- Clinic Data DML → Clinic Database: writes data
- Clinic Queries → Clinic Database: queries data
- Schema DDL → Finance Database: defines schema
- Finance Data DML → Finance Database: writes data
- Finance Queries → Finance Database: queries data