Last post Oct 27, 2018 01:45 PM by wavemaster
Oct 26, 2018 06:34 AM|nagapavanich|LINK
I have requirement of the below .i.e is one single user will have 5 or 3 crietria records for 3 competitor so how would i maintain database structure for the same .Iam thinking of creation of table with userId and companynamea,competitor a,competitor b,
competitor c as coloumns and will get 5 records for each user.Please suggest is it right way or not
Oct 26, 2018 08:30 PM|Mikesdotnetting|LINK
No, this is not the best way to design your structure. If you have a one to multiple (many) relationship, you need at least two tables - one of the principal in the relationship and one for the dependant. In this case, I think you also need a table for
you Criteria. There might be 5 at the moment, but customers change their minds and add things over time.
Oct 27, 2018 01:45 PM|wavemaster|LINK
It is not obvious from your post what the relationship is between user and company. Is this 1-1?
Also, I am thinking you will end up with a table criteriaType:
1 - criteria A
2 - criteria B
Also, can one company have multiple product names?
And what is the relationship between criteria and competitors?