search for: activity_fields

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

2006 Jul 06
1
Multiple Keys in a Database Table
...ACTIVITY_TYPES table (and joined by an activity_type_id in the activities table, naturally). Right now, there are four activity types, but that table will eventually expand. Each activity type (e.g., "registration," "phone call," "email," etc.) has many fields, in the ACTIVITY_FIELDS table, associated with it, and those fields propagate up to the individual activities. These two tables are joined by a has_and_belongs_to_many association, because certain fields should be available to multiple activity types. So available fields (e.g., "phone number," "email addres...