CREATE TABLE destinos (
    id_destino INT PRIMARY KEY,
    ciudad VARCHAR(50) NOT NULL,
    pais VARCHAR(50) NOT NULL,
    categoria VARCHAR(50) NOT NULL
);
--Tabla 2
CREATE TABLE clientes (
    id_cliente INT PRIMARY KEY,
    nombre VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    telefono VARCHAR(20) NOT NULL  
);
--Tabla 3
CREATE TABLE paquetes (
    id_paquete INT PRIMARY KEY,
    nombre_paquete VARCHAR(100) NOT NULL,
    id_destino INT NOT NULL,
    duracion_dias INT NOT NULL,
    precio_persona DECIMAL(10,2) NOT NULL,
    
    FOREIGN KEY (id_destino) 
    REFERENCES destinos(id_destino)
);
--Tabla 4
CREATE TABLE reservaciones (
    id_reserva INT PRIMARY KEY,
    id_cliente INT NOT NULL,
    id_paquete INT NOT NULL,
    fecha_reserva DATE NOT NULL,
    num_personas INT NOT NULL,
    monto_total DECIMAL(10,2) NOT NULL,  
    FOREIGN KEY (id_cliente) 
    REFERENCES clientes(id_cliente),
    FOREIGN KEY (id_paquete) 
    REFERENCES paquetes(id_paquete)
);