 	preco real,
 	PRIMARY KEY (idTipoQuarto)
 )
--- ALTER TABLE TipoQuarto OWNER TO postgres;
+
+WITH (OIDS = FALSE);
+
+ALTER TABLE TipoQuarto OWNER TO postgres;
 
 
 -- Hotel (#idHotel, nome, endereco, telefone)

	FOREIGN KEY (idCliente, numQuarto, idHotel, dataCheckIn) REFERENCES Estadia (idCliente, numQuarto, idHotel, dataCheckIn)
		MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE
)

-- Estadia (#&idCliente, #&numQuarto, #&idHotel, #dataCheckIn, dataCheckOut)
CREATE TABLE Estadia

	FOREIGN KEY (numQuarto, idHotel) REFERENCES Quarto (numQuarto, idHotel)
		MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE
)

WITH (OIDS = FALSE);

ALTER TABLE Reserva OWNER TO postgres;
