search for: activity_field_id

Displaying 1 result from an estimated 1 matches for "activity_field_id".

2006 Jul 06
1
Multiple Keys in a Database Table
...f a field never gets set in that table, but should still exist, that query wouldn''t find it). The way I thought about this problem initially was to have the activity_fields table set up like this: id, name, description, and the activity_field_values table set up like this: id, activity_id, activity_field_id, value. Doing that, I''d have unique activity field values for each activity and field ID. The problem I ran into was... how do I access that value? If I accessed @ activity.activity_type.activity_fields, I could get all the fields associated with a particular activity type (the keys). But...