Displaying 1 result from an estimated 1 matches for "activity_field_valu".
Did you mean:
activity_field_values
2006 Jul 06
1
Multiple Keys in a Database Table
...ivity type, and I can drill down into the list of
available fields by calling @activity.activity_type.activity_fields.
My problem, however, is that the activity fields and the individual values
per activity for those fields are stored in separate tables. I have my
activity_fields table and also an ACTIVITY_FIELD_VALUES table. This table
stores the value separately so I can provide a CRUD interface for the fields
themselves without querying and grouping a key/value table of fields and
their values (if a field never gets set in that table, but should still
exist, that query wouldn''t find it). The way I t...