# matheus-212/modelagem-centro-logistico-ii architecture

> Architecture diagram of the GitHub repository matheus-212/modelagem-centro-logistico-ii, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-15). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/matheus-212/modelagem-centro-logistico-ii
- Repository: https://github.com/matheus-212/modelagem-centro-logistico-ii

## Overview

This repository documents and implements a relational data model for JV Indústria, rather than an application with a shown runtime interface. Its principal workflow models a customer order through formula preparation, materials separation, production, lot storage, dispatch, invoicing, and delivery. The SQL schema is the central implementation artifact; the README describes the domain stages and reporting needs, but no SQL excerpts were supplied, so table-level behavior and direct SQL relationships cannot be verified.

Main entry points: [`docs/script.sql`](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql) (Order and items), [`docs/massa_dados.sql`](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/massa_dados.sql) (Demonstration data)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_order["Orders and catalog"]
  node_order["Order and items<br/>[script.sql]"]
  node_catalog["Customer and products<br/>[script.sql]"]
end

subgraph group_factory["Manufacturing and stock"]
  node_formula["Product formulas<br/>[script.sql]"]
  node_materials["Materials and suppliers<br/>[script.sql]"]
  node_production["Production records<br/>[script.sql]"]
  node_machines["Machines and stoppages<br/>[script.sql]"]
  node_lots["Finished-goods lots<br/>[script.sql]"]
  node_inventory["Inventory movements<br/>[script.sql]"]
end

subgraph group_fulfillment["Fulfillment and oversight"]
  node_dispatch["Dispatch<br/>[script.sql]"]
  node_invoices["Invoices and delivery<br/>[script.sql]"]
  node_reports["Management queries<br/>[script.sql]"]
  node_seed["Demonstration data<br/>[massa_dados.sql]"]
end

node_customer(("Customer"))

node_customer -->|"places"| node_order
node_order -->|"identifies items"| node_catalog
node_order -->|"guides production"| node_formula
node_formula -->|"specifies inputs"| node_materials
node_materials -->|"supplies"| node_production
node_production -->|"records equipment"| node_machines
node_production -->|"forms"| node_lots
node_lots -->|"tracks movements"| node_inventory
node_inventory -->|"feeds"| node_dispatch
node_dispatch -->|"proceeds to"| node_invoices
node_invoices -->|"delivers to"| node_customer
node_order -->|"informs analysis"| node_reports
node_inventory -->|"informs analysis"| node_reports
node_machines -->|"informs analysis"| node_reports
node_seed -.->|"populates"| node_order

click node_order "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql"
click node_catalog "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql"
click node_formula "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql"
click node_materials "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql"
click node_production "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql"
click node_machines "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql"
click node_lots "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql"
click node_inventory "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql"
click node_dispatch "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql"
click node_invoices "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql"
click node_reports "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql"
click node_seed "https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/massa_dados.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_order,node_catalog toneBlue
class node_formula,node_materials,node_production,node_machines,node_lots,node_inventory toneAmber
class node_dispatch,node_invoices,node_reports,node_seed toneMint
class node_customer toneIndigo
```

## Components

### Orders and catalog

- [Order and items](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql): `docs/script.sql`
- [Customer and products](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql): `docs/script.sql`

### Manufacturing and stock

- [Product formulas](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql): `docs/script.sql`
- [Materials and suppliers](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql): `docs/script.sql`
- [Production records](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql): `docs/script.sql`
- [Machines and stoppages](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql): `docs/script.sql`
- [Finished-goods lots](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql): `docs/script.sql`
- [Inventory movements](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql): `docs/script.sql`

### Fulfillment and oversight

- [Dispatch](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql): `docs/script.sql`
- [Invoices and delivery](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql): `docs/script.sql`
- [Management queries](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/script.sql): `docs/script.sql`
- [Demonstration data](https://github.com/matheus-212/modelagem-centro-logistico-ii/blob/main/docs/massa_dados.sql): `docs/massa_dados.sql`

### Other components

- **Customer**

## Connections

- Customer → Order and items: places (evidence: `README.md`)
- Order and items → Customer and products: identifies items (evidence: `README.md`)
- Order and items → Product formulas: guides production (evidence: `README.md`)
- Product formulas → Materials and suppliers: specifies inputs (evidence: `README.md`)
- Materials and suppliers → Production records: supplies (evidence: `README.md`)
- Production records → Machines and stoppages: records equipment (evidence: `README.md`)
- Production records → Finished-goods lots: forms (evidence: `README.md`)
- Finished-goods lots → Inventory movements: tracks movements (evidence: `README.md`)
- Inventory movements → Dispatch: feeds (evidence: `README.md`)
- Dispatch → Invoices and delivery: proceeds to (evidence: `README.md`)
- Invoices and delivery → Customer: delivers to (evidence: `README.md`)
- Order and items → Management queries: informs analysis (evidence: `README.md`)
- Inventory movements → Management queries: informs analysis (evidence: `README.md`)
- Machines and stoppages → Management queries: informs analysis (evidence: `README.md`)
- Demonstration data → Order and items: populates