In my User Profiles, I would like to have a series of questions that people can choose to answer. The goal is to help Members to get to know each other better, and to help me to build sub-communities and customize my content based on how people answer.
For example, maybe a lot of people have S-Corporations? Or maybe a lot of people have Family Businesses? Or maybe most of my Users provide "Services" versus selling "Products"?
Here are some sample questions...
1.) Why do you like working for yourself?
2.) What does your business do?
3.) If you could start over, what would you do the same?
4.) If you could start over, what would you do differently?
5.) As a Small-Business, how do you compete with Corporate America?
1.) How should I store the answers to these questions?
In my "member" table?
In a separate table?
2.) What do I call the fields?
"q01", "q02",... ??
or do I try and give them some longer, self-identifying name like "like_working_for_self", "what_does_bus_do"?
3.) What would be a reasonable field size?
I am thinking varchar(1024).
Or should I use "Text" and let them type a book?!