# jaydeepkgajera/metadatabase architecture

> Architecture diagram of the GitHub repository jaydeepkgajera/metadatabase, 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/jaydeepkgajera/metadatabase
- Repository: https://github.com/jaydeepkgajera/metadatabase

## Overview

This appears to be a Little Lemon restaurant database project, covering a data model, SQL setup and operations, table-booking queries, and a MySQL Python client. The tree also includes Tableau screenshots, suggesting a reporting or visualization deliverable. The README is empty and no source excerpts are available, so the graph records these documented artifacts without asserting how they connect or what they execute.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_model["Data model"]
  node_data_model["Little Lemon model"]
end

subgraph group_sql["SQL operations"]
  node_forward_sql["Forward engineering"]
  node_queries_procedures["Queries and procedures"]
  node_booking_sql["Table booking SQL<br/>[table_booking.sql]"]
end

subgraph group_client["Client access"]
  node_python_client["MySQL Python client"]
end

subgraph group_reporting["Reporting"]
  node_tableau["Tableau screenshots"]
end

click node_data_model "https://github.com/jaydeepkgajera/metadatabase/blob/develop/Workbench/little_lemon_data_model.mwb"
click node_forward_sql "https://github.com/jaydeepkgajera/metadatabase/blob/develop/sql-queries/little_lemon_forward_eng.sql"
click node_queries_procedures "https://github.com/jaydeepkgajera/metadatabase/blob/develop/sql-queries/little_lemon_queries_procedures.sql"
click node_booking_sql "https://github.com/jaydeepkgajera/metadatabase/blob/develop/sql-queries/table_booking.sql"
click node_python_client "https://github.com/jaydeepkgajera/metadatabase/blob/develop/sql-queries/mysql-python-client.ipynb"
click node_tableau "https://github.com/jaydeepkgajera/metadatabase/blob/develop/tableau/tableau_screenshots.docx"

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_data_model toneBlue
class node_forward_sql,node_queries_procedures,node_booking_sql toneAmber
class node_python_client toneMint
class node_tableau toneRose
```

## Components

### Data model

- [Little Lemon model](https://github.com/jaydeepkgajera/metadatabase/blob/develop/Workbench/little_lemon_data_model.mwb): `Workbench/little_lemon_data_model.mwb`

### SQL operations

- [Forward engineering](https://github.com/jaydeepkgajera/metadatabase/blob/develop/sql-queries/little_lemon_forward_eng.sql): `sql-queries/little_lemon_forward_eng.sql`
- [Queries and procedures](https://github.com/jaydeepkgajera/metadatabase/blob/develop/sql-queries/little_lemon_queries_procedures.sql): `sql-queries/little_lemon_queries_procedures.sql`
- [Table booking SQL](https://github.com/jaydeepkgajera/metadatabase/blob/develop/sql-queries/table_booking.sql): `sql-queries/table_booking.sql`

### Client access

- [MySQL Python client](https://github.com/jaydeepkgajera/metadatabase/blob/develop/sql-queries/mysql-python-client.ipynb): `sql-queries/mysql-python-client.ipynb`

### Reporting

- [Tableau screenshots](https://github.com/jaydeepkgajera/metadatabase/blob/develop/tableau/tableau_screenshots.docx): `tableau/tableau_screenshots.docx`