I would like both theory and technical disscussion to follow.
Peesonally I can see two potential methods:
1. You actually ALTER the table with the appropriate fields adding/removing as required
2. You store custom fields in a separate table something like below:
Code: Select all
pkid, table_name, field_type, field_name, field_valueLastly (a technique I've used in the past) was to store custom fields in a single text field for each row:
Code: Select all
pkid, fname, lname, age, sex, customSo I'd like to hear you ideas, opinions on best practice, experiences on past adventures, etc...
Cheers