How matheus-212/modelagem-centro-logistico-ii works
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: script.sql Order and items · massa_dados.sql Demonstration data
Components 13
Orders and catalog
- Order and items
docs/script.sql - Customer and products
docs/script.sql
Manufacturing and stock
- Product formulas
docs/script.sql - Materials and suppliers
docs/script.sql - Production records
docs/script.sql - Machines and stoppages
docs/script.sql - Finished-goods lots
docs/script.sql - Inventory movements
docs/script.sql
Fulfillment and oversight
- Dispatch
docs/script.sql - Invoices and delivery
docs/script.sql - Management queries
docs/script.sql - Demonstration data
docs/massa_dados.sql
Other components
- Customer
Connections 15
- Customer → Order and items: places
README.md - Order and items → Customer and products: identifies items
README.md - Order and items → Product formulas: guides production
README.md - Product formulas → Materials and suppliers: specifies inputs
README.md - Materials and suppliers → Production records: supplies
README.md - Production records → Machines and stoppages: records equipment
README.md - Production records → Finished-goods lots: forms
README.md - Finished-goods lots → Inventory movements: tracks movements
README.md - Inventory movements → Dispatch: feeds
README.md - Dispatch → Invoices and delivery: proceeds to
README.md - Invoices and delivery → Customer: delivers to
README.md - Order and items → Management queries: informs analysis
README.md - Inventory movements → Management queries: informs analysis
README.md - Machines and stoppages → Management queries: informs analysis
README.md - Demonstration data → Order and items: populates