I understand how to actually do it in the database. But what if I
wanted to know if there is a proper way to do it when I let specific
roles in my site create fields of their own.
For example: (I am building a conference software.)
John is using my site to create an event to attend.
He has the usual fields already: username, password, first name last
name, email...
But he want to add more fields. For example "school affiliation".
How would you best handle this situation?
I was thinking of creating many to many table...
Users that log into my system can attend more than one conference/event
so we have the basics like shown above.
Then people can attend various events and fill in more data.
So:
T:field
conference_id
field_name
field_type
field_required
T:user_conference_field
conference_id
user_id
field_id
data
And then I would have to create customer forms for these as they are
certainly not conventional.
That second table here is like a 3 way cosmic convergence of craziness
and I wonder if there is a better way.
---
Best Regards,
Jason Brower
