About This Architecture
Fast-food inventory management data dictionary defining seven core entities: Categoria, Producto, Proveedor, Inventario, Movimiento, Usuario, and Receta with primary and foreign key relationships. The schema enforces referential integrity through foreign keys linking products to categories, inventory records to products, stock movements to users and products, and recipes to ingredients via a recommended junction table. This normalized structure prevents data anomalies, ensures audit trails for inventory transactions, and supports role-based access control across Admin, Almacen, and Cocina user roles. Fork this diagram on Diagrams.so to customize column definitions, add the OrdenCompra bridge table, or export as .drawio for use in database design tools. The ENUM fields for movement types and user roles enable efficient filtering and reporting on inventory flows and operational permissions.