Which approach is better?
hi, i hv a situation, a table called campaigns, and each campaign may hv diff setting, or with default setting
let say, i hv 5 setting, s1, s2, s3, s4, s5, where s1 to s5 mayb string or any possible integer
Note: not every camp need those setting, some may hv s1...s5 to NULL
there should be two approach for the table
Case 1:
table A
camp_id, camp_name, s1, s2, s3, s4, s5
Case 2:
table A
camp_id, camp_name
table s1
id, camp_id, s1
table s2
id, camp_id, s2
table s3
id, camp_id, s3
table s4
id, camp_id, s4
table s5
id, camp_id, s5
then come back, i wonder which one should be best approach.
Coz once the sys running, i mayb come accross a case to check whether camp_id=5 hv setting s3 or not, to continue the script operation
Can some one tell me which would be system and programming viser?
Subject
Written By
Posted
Which approach is better?
November 07, 2006 02:55AM
November 08, 2006 06:19PM
November 09, 2006 08:59PM
November 09, 2006 09:17PM
November 09, 2006 10:52PM
November 16, 2006 09:34PM
November 16, 2006 09:51PM
November 16, 2006 10:14PM
November 17, 2006 12:18AM
November 19, 2006 09:33PM