HotelDruid

Hi Marco,

I'd like to make graphs with occupancy levels, revenue, extra costs etc over the time. The approach I'm considering is to install some php graphing package on my php-residence server and use the data directly from reservation database. Do you have any ER diagram (like this: http://www.cs.unm.edu/~luo/ridgeway/ER.jpg) of the database so I don't have to reverse engineer it?

Or would you suggest a different approach?

I don't have a diagram, but I think you'll only need the information in prenotaYYYY tables that are linked to the clienti table with "idclienti <--> idclienti" and costiprenotaYYYY (the extra costs) with "idprenota <--> idprenota".

Marco