In my web application there exists a web form with certain questions on it. Some of these questions will be pulled / retrieved from the database.
Here is some sample data:
My question is, is there much gain in moving the
Type column (determines what sort of HTML input element to display on the form) into its own table and have a foreign key to the question type?
You might argue that instead of the words 'Text, Select ... etc' I'll have numbers .. but they'll still repeat! is there any gain in doing this?
Any clarification would be greatly appreciated.