I am in the process of transferring my flat file poll system to MySQL.
I am having problems modelling the database. Since each poll has variable number of responses, my initial thought was having one table for each poll with unique set of columns with unique data types (since some answers will be stored as INT or SMALLINT, while others are stored as ENUM [Yes,No]).
Another approach I thought of was having ONE table that would contain a "maximum" number of columns and use SMALLINT for all the answers, and use 0 - 1 (true/false - yes/no) for ENUM type of answers.
But I am open to other suggestions.
Thanks in advance.
========================================
Buh Bye!
Cheers,
Me
I am having problems modelling the database. Since each poll has variable number of responses, my initial thought was having one table for each poll with unique set of columns with unique data types (since some answers will be stored as INT or SMALLINT, while others are stored as ENUM [Yes,No]).
Another approach I thought of was having ONE table that would contain a "maximum" number of columns and use SMALLINT for all the answers, and use 0 - 1 (true/false - yes/no) for ENUM type of answers.
But I am open to other suggestions.
Thanks in advance.
========================================
Buh Bye!
Cheers,
Me