I'm working on a php/mysql lcd monitor database for a new site and the database structure is getting complicated and i'm not sure about the lookup tables and fields...

i outlined what i what to do and the current 'on paper' table structure and fields and output i want at http://lcdmonitorinfo.com/templates/dbtemplate2.html

anyone would like to go over the database structure and provide suggestions or advice as to better do this ?

thanks