[nycphp-talk] Flexible Forms & How to store them...
csnyder
chsnyder at gmail.com
Tue May 15 14:06:13 EDT 2007
On 5/15/07, Mark Armendariz <lists at enobrev.com> wrote:
> CREATE TABLE data_fields (
> field_id MEDIUMINT(6) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
> data_id TINYINT(3) UNSIGNED NOT NULL,
> field_name VARCHAR(20),
> field_data VARCHAR(100)
> )
Did you ever worry about record integrity problems?
What if a data record is missing some field values? Or has more than
one value stored for some field name?
I was glad to see Brian asking about this topic, because it's been
sitting in the back of my head for a while now.
--
Chris Snyder
http://chxo.com/
More information about the talk
mailing list