Restorante Data Model: JPA Entities and Relationships

Documentation Index

Fetch the complete documentation index at: https://mintlify.com/NicolasMPP/restorante-springboot/llms.txt

Use this file to discover all available pages before exploring further.

​

Core Entities

​

Entity Relationship Overview

• A Gerente owns one or more Menu instances and one or more Despensa instances (both via @OneToMany with cascade ALL).
• Each Menu holds many Alimento items, linked through the menu_alimentos join table.
• Each Alimento optionally references one Receta (the receta_id FK is nullable, so drinks and desserts without preparation steps can have a null recipe).
• Each Receta belongs to one Empleado (typically a Chef) and uses many Ingrediente records, linked through receta_ingredientes.
• Each Despensa stores many Ingrediente records, linked through despensa_ingredientes. Ingredients are therefore shared data — the same Ingrediente row may appear in both a recipe and the pantry.

​

Join Tables

​

Inheritance Strategies

-- Discriminator column definition
-- @DiscriminatorColumn(name = "tipo_alimento", discriminatorType = DiscriminatorType.STRING)

SELECT tipo_alimento, COUNT(*) FROM alimentos GROUP BY tipo_alimento;

-- Discriminator column definition
-- @DiscriminatorColumn(name = "tipo_empleado", discriminatorType = DiscriminatorType.STRING)

SELECT tipo_empleado, nombre, salario FROM empleados;

-- Querying a Gerente requires a JOIN
SELECT p.nombre, p.cedula, g.id AS gerente_id
FROM personas p
JOIN gerentes g ON p.id = g.id;

-- Querying a Cliente
SELECT p.nombre, p.cedula
FROM personas p
JOIN clientes c ON p.id = c.id;