search for: activity_types

...I''m wondering if there''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...

I have two data frames with a number of common variables that I wish to put into "long format". The first contains the variables es(Csales) [1] "terr" "Dec.02" "Jan.03" "Feb.03" "Mar.03" "Apr.03" "May.03" "Jun.03" [9] "Jul.03" "Aug.03" "Sep.03" "Oct.03"

I have problems on a simple design problem. I have many companies. Each company have one or more commercial activity. Activities types are: ecommerce, local unit, television, automatic vending machines, and so on. Company may have one or more ecommerce activity or one or more local unit activity, one ormore vending machines, etc. How can I model this scenario? Company has_many ecommerce has_many

Hi, I am almost embarrased to ask this and I am sure it has been answered previously but the search feature is down on ruby-forum so I am not finding the answer. I have several controllers (leads, orders, activities, etc...). I have a ton of repeated html in each of the views for these controllers. For example, my list view has the same table/tr/td and for..in type of code and it just

Hi all, I''m having some trouble with a has_many association on a table using the single table inheritance model that I''m hoping someone can help me with. The schema for the table is: CREATE TABLE `comments` ( `id` int(11) NOT NULL auto_increment, `user_id` int(11) default NULL, `type` varchar(20) NOT NULL default '''', `type_id` int(11) NOT NULL default