# hasina-mlbb/test_db-master architecture

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

- Interactive diagram: https://gitdiagram.com/hasina-mlbb/test_db-master
- Repository: https://github.com/hasina-mlbb/test_db-master

## Overview

test_db is a sample employee database and a small PHP browser for department and employee records, search, and a department-change demonstration. The main workflow browses departments into employee lists and employee details; search results use session-backed pagination. The database install, alternate PostgreSQL schema, and integrity checks are documented product capabilities. PHP excerpts show the MySQL-backed UI; database SQL contents and unsampled components are not inspected, so their detailed wiring is omitted.

Main entry points: [`employees.sql`](https://github.com/hasina-mlbb/test_db-master/blob/main/employees.sql) (Employees database), [`function.php`](https://github.com/hasina-mlbb/test_db-master/blob/main/function.php) (Database query helpers), [`index.php`](https://github.com/hasina-mlbb/test_db-master/blob/main/index.php) (Department overview), [`employe.php`](https://github.com/hasina-mlbb/test_db-master/blob/main/employe.php) (Department employees)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Employee browser"]
  node_department_page["Department overview<br/>[index.php]"]
  node_employee_list["Department employees<br/>[employe.php]"]
  node_employee_detail["Employee profile<br/>[fiche.php]"]
  node_search_form["Search criteria<br/>[formulaire.php]"]
  node_search_results["Search results<br/>[recherche.php]"]
  node_next_page["Next results<br/>[prochain.php]"]
  node_change_form["Department change form"]
  node_change_preview["Change preview"]
  node_query_helpers["Database query helpers<br/>[function.php]"]
end

subgraph group_db["Sample database"]
  node_mysql_db[("Employees database<br/>[employees.sql]")]
  node_partitioned_db[("Partitioned variant")]
  node_postgres_db[("PostgreSQL schema<br/>[employees.sql]")]
  node_pg_loader["PostgreSQL loader"]
end

subgraph group_integrity["Integrity checks"]
  node_integrity_test["SHA-256 integrity test"]
  node_pg_integrity_test["PostgreSQL integrity test"]
end

node_visitor(("Visitor"))
node_mysql_server[("MySQL-compatible server")]
node_postgres_server[("PostgreSQL server")]

node_visitor -->|"opens"| node_department_page
node_department_page -->|"loads departments"| node_query_helpers
node_department_page -->|"opens department"| node_employee_list
node_employee_list -->|"opens profile"| node_employee_detail
node_employee_list -->|"queries records"| node_mysql_db
node_employee_detail -->|"queries profile"| node_mysql_db
node_visitor -->|"enters criteria"| node_search_form
node_search_form -->|"submits criteria"| node_search_results
node_search_results -->|"searches employees"| node_query_helpers
node_search_results -->|"opens next page"| node_next_page
node_next_page -->|"loads next batch"| node_query_helpers
node_employee_detail -->|"opens change form"| node_change_form
node_change_form -->|"lists departments"| node_query_helpers
node_change_form -->|"submits change"| node_change_preview
node_change_preview -->|"reads employee"| node_mysql_db
node_query_helpers -->|"queries records"| node_mysql_db
node_mysql_server -.->|"hosts schema"| node_mysql_db
node_visitor -->|"installs via SQL"| node_mysql_db
node_visitor -->|"installs variant"| node_partitioned_db
node_visitor -->|"runs loader"| node_pg_loader
node_pg_loader -->|"loads schema"| node_postgres_db
node_postgres_server -->|"hosts schema"| node_postgres_db
node_visitor -->|"runs checksum test"| node_integrity_test
node_visitor -->|"runs checksum test"| node_pg_integrity_test

click node_department_page "https://github.com/hasina-mlbb/test_db-master/blob/main/index.php"
click node_employee_list "https://github.com/hasina-mlbb/test_db-master/blob/main/employe.php"
click node_employee_detail "https://github.com/hasina-mlbb/test_db-master/blob/main/fiche.php"
click node_search_form "https://github.com/hasina-mlbb/test_db-master/blob/main/formulaire.php"
click node_search_results "https://github.com/hasina-mlbb/test_db-master/blob/main/recherche.php"
click node_next_page "https://github.com/hasina-mlbb/test_db-master/blob/main/prochain.php"
click node_change_form "https://github.com/hasina-mlbb/test_db-master/blob/main/formulaire_changement.php"
click node_change_preview "https://github.com/hasina-mlbb/test_db-master/blob/main/traitement_changement.php"
click node_query_helpers "https://github.com/hasina-mlbb/test_db-master/blob/main/function.php"
click node_mysql_db "https://github.com/hasina-mlbb/test_db-master/blob/main/employees.sql"
click node_partitioned_db "https://github.com/hasina-mlbb/test_db-master/blob/main/employees_partitioned.sql"
click node_postgres_db "https://github.com/hasina-mlbb/test_db-master/blob/main/postgresql/employees.sql"
click node_pg_loader "https://github.com/hasina-mlbb/test_db-master/blob/main/postgresql/load_employees_db.sh"
click node_integrity_test "https://github.com/hasina-mlbb/test_db-master/blob/main/test_employees_sha2.sql"
click node_pg_integrity_test "https://github.com/hasina-mlbb/test_db-master/blob/main/postgresql/test_employees_sha2.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_department_page,node_employee_list,node_employee_detail,node_search_form,node_search_results,node_next_page,node_change_form,node_change_preview,node_query_helpers toneBlue
class node_mysql_db,node_partitioned_db,node_postgres_db,node_pg_loader,node_mysql_server,node_postgres_server toneAmber
class node_integrity_test,node_pg_integrity_test toneMint
class node_visitor toneIndigo
```

## Components

### Employee browser

- [Department overview](https://github.com/hasina-mlbb/test_db-master/blob/main/index.php): `index.php`
- [Department employees](https://github.com/hasina-mlbb/test_db-master/blob/main/employe.php): `employe.php`
- [Employee profile](https://github.com/hasina-mlbb/test_db-master/blob/main/fiche.php): `fiche.php`
- [Search criteria](https://github.com/hasina-mlbb/test_db-master/blob/main/formulaire.php): `formulaire.php`
- [Search results](https://github.com/hasina-mlbb/test_db-master/blob/main/recherche.php): `recherche.php`
- [Next results](https://github.com/hasina-mlbb/test_db-master/blob/main/prochain.php): `prochain.php`
- [Department change form](https://github.com/hasina-mlbb/test_db-master/blob/main/formulaire_changement.php): `formulaire_changement.php`
- [Change preview](https://github.com/hasina-mlbb/test_db-master/blob/main/traitement_changement.php): `traitement_changement.php`
- [Database query helpers](https://github.com/hasina-mlbb/test_db-master/blob/main/function.php): `function.php`

### Sample database

- [Employees database](https://github.com/hasina-mlbb/test_db-master/blob/main/employees.sql): `employees.sql`
- [Partitioned variant](https://github.com/hasina-mlbb/test_db-master/blob/main/employees_partitioned.sql): `employees_partitioned.sql`
- [PostgreSQL schema](https://github.com/hasina-mlbb/test_db-master/blob/main/postgresql/employees.sql): `postgresql/employees.sql`
- [PostgreSQL loader](https://github.com/hasina-mlbb/test_db-master/blob/main/postgresql/load_employees_db.sh): `postgresql/load_employees_db.sh`

### Integrity checks

- [SHA-256 integrity test](https://github.com/hasina-mlbb/test_db-master/blob/main/test_employees_sha2.sql): `test_employees_sha2.sql`
- [PostgreSQL integrity test](https://github.com/hasina-mlbb/test_db-master/blob/main/postgresql/test_employees_sha2.sql): `postgresql/test_employees_sha2.sql`

### Other components

- **Visitor**
- **MySQL-compatible server**
- **PostgreSQL server**

## Connections

- Visitor → Department overview: opens (evidence: `index.php`)
- Department overview → Database query helpers: loads departments (evidence: `index.php`)
- Department overview → Department employees: opens department (evidence: `index.php`)
- Department employees → Employee profile: opens profile (evidence: `employe.php`)
- Department employees → Employees database: queries records (evidence: `employe.php`)
- Employee profile → Employees database: queries profile (evidence: `fiche.php`)
- Visitor → Search criteria: enters criteria (evidence: `formulaire.php`)
- Search criteria → Search results: submits criteria (evidence: `formulaire.php`)
- Search results → Database query helpers: searches employees (evidence: `recherche.php`)
- Search results → Next results: opens next page (evidence: `recherche.php`)
- Next results → Database query helpers: loads next batch (evidence: `prochain.php`)
- Employee profile → Department change form: opens change form (evidence: `fiche.php`)
- Department change form → Database query helpers: lists departments (evidence: `formulaire_changement.php`)
- Department change form → Change preview: submits change (evidence: `formulaire_changement.php`)
- Change preview → Employees database: reads employee (evidence: `traitement_changement.php`)
- Database query helpers → Employees database: queries records (evidence: `function.php`)
- MySQL-compatible server → Employees database: hosts schema (evidence: `README.md`)
- Visitor → Employees database: installs via SQL (evidence: `README.md`)
- Visitor → Partitioned variant: installs variant (evidence: `README.md`)
- Visitor → PostgreSQL loader: runs loader (evidence: `README.md`)
- PostgreSQL loader → PostgreSQL schema: loads schema (evidence: `README.md`)
- PostgreSQL server → PostgreSQL schema: hosts schema (evidence: `README.md`)
- Visitor → SHA-256 integrity test: runs checksum test (evidence: `README.md`)
- Visitor → PostgreSQL integrity test: runs checksum test (evidence: `README.md`)
