# sitser0/flight-base architecture

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

- Interactive diagram: https://gitdiagram.com/sitser0/flight-base
- Repository: https://github.com/sitser0/flight-base

## Overview

This repository is an airline-flight database project. Its main workflow is to create a local PostgreSQL schema, populate it through one of three routes (synthetic data, Aviationstack flight data, or airport CSV data), then use the SQL request collection; a separate directory contains database views. The sampled loaders reveal airline, aircraft, airport, flight, passenger, ticket, baggage, and flight-status data. SQL definitions and queries were not sampled, so their internal behavior is not expanded here.

Main entry points: [`scripts/inserts_flights.py`](https://github.com/sitser0/flight-base/blob/main/scripts/inserts_flights.py) (API loader), [`scripts/inserting_airports.py`](https://github.com/sitser0/flight-base/blob/main/scripts/inserting_airports.py) (CSV loader), [`scripts/builder.sql`](https://github.com/sitser0/flight-base/blob/main/scripts/builder.sql) (Schema builder), [`scripts/random_insert.py`](https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py) (Synthetic loader)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_schema["Database schema"]
  node_builder["Schema builder<br/>[builder.sql]"]
  node_postgres[("PostgreSQL database")]
end

subgraph group_ingestion["Data ingestion"]
  node_random["Synthetic loader<br/>[random_insert.py]"]
  node_api_loader["API loader<br/>[inserts_flights.py]"]
  node_airport_csv["Airport CSV<br/>[apinfo.csv]"]
  node_csv_loader["CSV loader"]
end

subgraph group_domain["Flight data"]
  node_airlines["Airlines<br/>[random_insert.py]"]
  node_aircraft["Aircraft<br/>[random_insert.py]"]
  node_airports["Airports<br/>[random_insert.py]"]
  node_flights["Flights<br/>[random_insert.py]"]
  node_passengers["Passengers<br/>[random_insert.py]"]
  node_tickets_baggage["Tickets and baggage<br/>[random_insert.py]"]
  node_status_history["Flight status history<br/>[random_insert.py]"]
end

subgraph group_sql["SQL access"]
  node_requests["SQL requests"]
  node_views["Database views"]
end

node_operator(("Operator"))
node_aviationstack["Aviationstack API"]

node_operator -->|"runs"| node_builder
node_builder -->|"creates schema"| node_postgres
node_operator -->|"runs"| node_random
node_random -->|"inserts data"| node_postgres
node_operator -->|"runs"| node_api_loader
node_api_loader -->|"fetches flights"| node_aviationstack
node_api_loader -->|"inserts data"| node_postgres
node_operator -->|"runs"| node_csv_loader
node_csv_loader -->|"reads"| node_airport_csv
node_csv_loader -->|"inserts airports"| node_postgres
node_requests -->|"queries"| node_postgres
node_views -.->|"defines views"| node_postgres

click node_builder "https://github.com/sitser0/flight-base/blob/main/scripts/builder.sql"
click node_random "https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py"
click node_api_loader "https://github.com/sitser0/flight-base/blob/main/scripts/inserts_flights.py"
click node_airport_csv "https://github.com/sitser0/flight-base/blob/main/scripts/apinfo.csv"
click node_csv_loader "https://github.com/sitser0/flight-base/blob/main/scripts/inserting_airports.py"
click node_airlines "https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py"
click node_aircraft "https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py"
click node_airports "https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py"
click node_flights "https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py"
click node_passengers "https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py"
click node_tickets_baggage "https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py"
click node_status_history "https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py"
click node_requests "https://github.com/sitser0/flight-base/tree/main/requests"
click node_views "https://github.com/sitser0/flight-base/tree/main/%D0%9F%D1%80%D0%B5%D0%B4%D1%81%D1%82%D0%B0%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D1%8F"

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_builder,node_postgres toneBlue
class node_random,node_api_loader,node_airport_csv,node_csv_loader toneAmber
class node_airlines,node_aircraft,node_airports,node_flights,node_passengers,node_tickets_baggage,node_status_history,node_aviationstack toneMint
class node_requests,node_views toneRose
class node_operator toneIndigo
```

## Components

### Database schema

- [Schema builder](https://github.com/sitser0/flight-base/blob/main/scripts/builder.sql): `scripts/builder.sql`
- **PostgreSQL database**

### Data ingestion

- [Synthetic loader](https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py): `scripts/random_insert.py`
- [API loader](https://github.com/sitser0/flight-base/blob/main/scripts/inserts_flights.py): `scripts/inserts_flights.py`
- [Airport CSV](https://github.com/sitser0/flight-base/blob/main/scripts/apinfo.csv): `scripts/apinfo.csv`
- [CSV loader](https://github.com/sitser0/flight-base/blob/main/scripts/inserting_airports.py): `scripts/inserting_airports.py`

### Flight data

- [Airlines](https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py): `scripts/random_insert.py`
- [Aircraft](https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py): `scripts/random_insert.py`
- [Airports](https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py): `scripts/random_insert.py`
- [Flights](https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py): `scripts/random_insert.py`
- [Passengers](https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py): `scripts/random_insert.py`
- [Tickets and baggage](https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py): `scripts/random_insert.py`
- [Flight status history](https://github.com/sitser0/flight-base/blob/main/scripts/random_insert.py): `scripts/random_insert.py`

### SQL access

- [SQL requests](https://github.com/sitser0/flight-base/tree/main/requests): `requests`
- [Database views](https://github.com/sitser0/flight-base/tree/main/%D0%9F%D1%80%D0%B5%D0%B4%D1%81%D1%82%D0%B0%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D1%8F): `Представления`

### Other components

- **Operator**
- **Aviationstack API**

## Connections

- Operator → Schema builder: runs (evidence: `README.md`)
- Schema builder → PostgreSQL database: creates schema (evidence: `README.md`)
- Operator → Synthetic loader: runs (evidence: `README.md`)
- Synthetic loader → PostgreSQL database: inserts data (evidence: `scripts/random_insert.py`)
- Operator → API loader: runs (evidence: `README.md`)
- API loader → Aviationstack API: fetches flights (evidence: `scripts/inserts_flights.py`)
- API loader → PostgreSQL database: inserts data (evidence: `scripts/inserts_flights.py`)
- Operator → CSV loader: runs (evidence: `README.md`)
- CSV loader → Airport CSV: reads (evidence: `scripts/inserting_airports.py`)
- CSV loader → PostgreSQL database: inserts airports (evidence: `scripts/inserting_airports.py`)
- SQL requests → PostgreSQL database: queries (evidence: `README.md`)
- Database views → PostgreSQL database: defines views
