but yeah, now that u said it, i see that it would have been cleverer to add a table containing teh companies, another one for the vlans,... and just add the ids in the correspondant fields, bass yalla, if i can bypass this, i prefere, i don't want to redo and repair everything unless it's necessary
well it is ur decision if u want to redo part of the work or stay with the current database
i guess this depends on how much u are going to use the system u did and future development
if u are going to use it a lot and for long time.. u better start something new and clean
can i suggest something :
you can create a table where u can collect the name of the companies
in the switch table.. u don't have to link to the companies Id. just leave it like it is
and everytime u insert new company.make sure to insert it automatically in companies table
like that you don't have to write a long running query every time u want a list of the companies
or every time u want to query something about companies
it is just a suggestion.. u can follow or u can not
now i am just too lazy to think about anything :) ..