# murtadhahassan/flowbridgeerp architecture

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

- Interactive diagram: https://gitdiagram.com/murtadhahassan/flowbridgeerp
- Repository: https://github.com/murtadhahassan/flowbridgeerp

## Overview

FlowBridge ERP is a SQL-based business-process automation demonstration. Its documented domain model connects departments, employees, requests, and approvals; SQL reports provide employee, department, and approval views. The tree and README support these capabilities, but no SQL excerpts are available to verify exact joins, keys, or execution flow.

Main entry points: [`sample_data.sql`](https://github.com/murtadhahassan/flowbridgeerp/blob/main/sample_data.sql) (Sample Data), [`queries.sql`](https://github.com/murtadhahassan/flowbridgeerp/blob/main/queries.sql) (SQL Reports), [`schema.sql`](https://github.com/murtadhahassan/flowbridgeerp/blob/main/schema.sql) (Employees)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_domain["Business Data"]
  node_departments[("Departments<br/>[schema.sql]")]
  node_employees[("Employees<br/>[schema.sql]")]
  node_requests[("Requests<br/>[schema.sql]")]
  node_approvals[("Approvals<br/>[schema.sql]")]
  node_sample_data["Sample Data<br/>[sample_data.sql]"]
end

subgraph group_reporting["SQL Reporting"]
  node_reports["SQL Reports<br/>[queries.sql]"]
end

node_departments -->|"relates to"| node_employees
node_employees -->|"submits"| node_requests
node_requests -->|"tracks"| node_approvals
node_sample_data -->|"populates"| node_departments
node_sample_data -->|"populates"| node_employees
node_sample_data -->|"populates"| node_requests
node_sample_data -->|"populates"| node_approvals
node_reports -->|"reports on"| node_employees
node_reports -->|"reports on"| node_departments
node_reports -->|"reports on"| node_requests
node_reports -->|"reports on"| node_approvals

click node_departments "https://github.com/murtadhahassan/flowbridgeerp/blob/main/schema.sql"
click node_employees "https://github.com/murtadhahassan/flowbridgeerp/blob/main/schema.sql"
click node_requests "https://github.com/murtadhahassan/flowbridgeerp/blob/main/schema.sql"
click node_approvals "https://github.com/murtadhahassan/flowbridgeerp/blob/main/schema.sql"
click node_sample_data "https://github.com/murtadhahassan/flowbridgeerp/blob/main/sample_data.sql"
click node_reports "https://github.com/murtadhahassan/flowbridgeerp/blob/main/queries.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_departments,node_employees,node_requests,node_approvals,node_sample_data toneBlue
class node_reports toneAmber
```

## Components

### Business Data

- [Departments](https://github.com/murtadhahassan/flowbridgeerp/blob/main/schema.sql): `schema.sql`
- [Employees](https://github.com/murtadhahassan/flowbridgeerp/blob/main/schema.sql): `schema.sql`
- [Requests](https://github.com/murtadhahassan/flowbridgeerp/blob/main/schema.sql): `schema.sql`
- [Approvals](https://github.com/murtadhahassan/flowbridgeerp/blob/main/schema.sql): `schema.sql`
- [Sample Data](https://github.com/murtadhahassan/flowbridgeerp/blob/main/sample_data.sql): `sample_data.sql`

### SQL Reporting

- [SQL Reports](https://github.com/murtadhahassan/flowbridgeerp/blob/main/queries.sql): `queries.sql`

## Connections

- Departments → Employees: relates to
- Employees → Requests: submits
- Requests → Approvals: tracks
- Sample Data → Departments: populates
- Sample Data → Employees: populates
- Sample Data → Requests: populates
- Sample Data → Approvals: populates
- SQL Reports → Employees: reports on
- SQL Reports → Departments: reports on
- SQL Reports → Requests: reports on
- SQL Reports → Approvals: reports on