Statistics & graphing

[etc]

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?

[marco]

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