I'm trying to design an app where users take a new survey everyday (that's not the main part of app but it's an important part). I've never designed a database before so what I'm trying to do might not make any sense.

I'm using MySQL and I have a table for user information (user_id, name, password, etc). What I plan on doing is making a new table for each new survey and linking it with the user_id. So basically, I would have one table having a relationship with hundreds of other tables.

Is that how it would work? I thought about adding a column to the user table for every survey but I read that it's bad design to add columns often.

1 Answer 1


Make one table for all surveys. Don't make a new table for each survey.

Also, make sure you hash and salt your passwords with bcrypt.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.