|
Hi Guys,
I want to know the table creation for the problem described below.
I have a 26 parameters for a customer feed back,
and i have a set of sites , some sites don't have some parameters in my 26 points, and some site want more then 26 points,
so i thought to create table like
id(int),parametename(Nvarchar(max)),site1(bit),site2(bit),site3(bit),site4(bit)
and i will allow in UI to check which point is applicable for which site,
this solution is for time being,
my concern is id the site name may add in future that time we have to change the parameter table and modify the insert and update methods as well as Store procedure,
How can avoid the re-coding by creating customized table.
Please suggest me the solution.
Thanks and regards
Vishwa
|
|
|
|
|
You should have a table that stores the list of sites identified by a SiteID column. And then you can store the values in your table with these columns
id(int),parametename(Nvarchar(max)),SiteID(int),value(bit)
Whenever there is a new site is to be added, just add it to the site table and insert a new row with that id in this table.
|
|
|
|
|
Table: site
- id
- Site_name
- Site_url
Table: site_parameter
- id
- Site_id (foreign key to above table)
- name
- value
For "26 parameters" you would have 26 rows in the site_parameter table.
|
|
|
|