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...