Hi guys, I just need some advice on my DB structure. The DB is used to store form submissions. The form has around 52 fields and I intend on adding a few more fields for other purposes (let's call it tracking info)...so in all, it's gonna be around 60 fields in all.
The 52 form fields are gonna be displayed [via php etc, another story] on similar pages.
1. Now, my question is, do I cram all of them in one table or put the 52 fields in one table and the tracking info in another table? I cant really decide on that
For now, I've crammed em in one table since I can just loop through an array to display the results.
2. Also, I've got most of the dropdowns (except numericals) in my DB as ENUMs...any word on that?