I have a problem with my database design.
I have two options in mind but none of them really solves my problem:
FB (ID, Year, Question, Value)
ID | Year| Quest.|Value
1 | 2004| Q1 | hello
1 | 2004| Q2500 | 15.2.12
1 | 2004| Q2 | 56
1 | 2003| Q1 | bye
2 | 2003| Q2 | 55
2 | 2003| Q1 |salut
The problem with Option 1 is that the data type of field Value can be really everything! To solve that problem I thought of
1. creating a table for each datatype or
2. changing the table to FB (ID, Year, Question, Valueint, Valuestring, .etc.)
Neither 1. nor 2. seems right to me.