search for: activity_type_id

...39;s an elegant way to do what I need, for my in-house customer relationship management tool: I have an ACTIVITIES table. That table is a collection of individual, unique activities created by users of the system. Activities have activity types, listed in the 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 fie...