Design a website where you can search for STB's based on your specific requirements. The target audience will be network operators.
STB manufacturers will be able to setup an account and populate the website with their inventory, and its specfications, depending on the STB features it may need to connect to another table, like if the STB has CAS on it, then I want to know the CAS vendor and which version, same if it has middleware, I want to know which middleware vendor and version.
Finally network operators have to register to be able to search, they need to setup an account. The network operator account is the only account that can search for STB, all other accounts can only manage their own inventory. I need to verify/ok the operator account, the middleware and STB accounts can be created on line via an email address for authentication/verification.
I as the website administrator can go in as any account, to add in inventory on the behalf of any vendor. I can suspend/delete accounts.
The long term goal is to generate revenue from advertising if I can get enough people coming to the website, so the site needs to be designed so that later I can add in adverts.
The file contains my version of table structures, the coloured cells show the common attributes that link the table. A front end GUI needs to be designed to populate and mange the DB.