hello
I have an idea of an rack space table which has hostnames and uheight info on it. But as I'm quite new to this mysql programming I actually dont have much of knowledge on this programming.
I was thinking the database to be of both single table or multiple tables. Dont know if this even could be done with single table.
The idea itself is to have a table with rows and columns, which pictures of a server rack(s). As a server is added to this rack you could mark it to this database with uheight information. Uheight could be marked for example with this hostname on each line where this server is located (if the server has a height of 4U's it would be marked in the table on 4 rows) OR the area the server is located is to be marked with red color (reserved) and the host name on the top line of the area only.
Available/free area should be marked with green color of course.
And when you click on this hostname it could jump to another page which gives you details on this server.. e.g. last modified etc..
standard rack height is 42U's and the table should be limited to 42 rows.
could someone help me to kick start this? :)