# rabin-humagain/learning-postgres architecture

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

- Interactive diagram: https://gitdiagram.com/rabin-humagain/learning-postgres
- Repository: https://github.com/rabin-humagain/learning-postgres

## Overview

This is a small SQL schema and sample-data script for exploring a conceptual universe database. The documented workflow is to run the script in a SQL client, then query the resulting tables to inspect celestial objects and explore systems, joins, filtering, and aggregation. The SQL contents were not provided, so table-level relationships and implementation details cannot be verified.

Main entry points: [`universe.sql`](https://github.com/rabin-humagain/learning-postgres/blob/main/universe.sql) (Schema and sample data)

## Diagram (Mermaid)

```mermaid
flowchart TD

node_sql_client(("SQL client"))
node_universe_script["Schema and sample data<br/>[universe.sql]"]
node_universe_db[("Universe database")]

node_sql_client -->|"runs"| node_universe_script
node_universe_script -->|"creates and populates"| node_universe_db
node_sql_client -->|"queries"| node_universe_db
node_universe_db -->|"returns results"| node_sql_client

click node_universe_script "https://github.com/rabin-humagain/learning-postgres/blob/main/universe.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_sql_client toneBlue
class node_universe_script toneTeal
class node_universe_db toneAmber
```

## Components

### Other components

- **SQL client**
- [Schema and sample data](https://github.com/rabin-humagain/learning-postgres/blob/main/universe.sql): `universe.sql`
- **Universe database**

## Connections

- SQL client → Schema and sample data: runs
- Schema and sample data → Universe database: creates and populates
- SQL client → Universe database: queries
- Universe database → SQL client: returns results