Displaying 5 results from an estimated 5 matches for "activity_type".
2006 Jul 06
1
Multiple Keys in a Database Table
...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_FIELD...
2007 Mar 01
0
Reshape data
...","May.04","Jun.04","Jul.04","Aug.04","Sep.04",
"Oct.04")),direction = "long")
The second dataset contains the variables
es(Ccalls)
[1] "TERRITORY" "REGION" "ACTIVITY_TYPE"
[4] "CONTACT_TYPE" "TARGETED_FLG" "CONTACT_GRADE"
[7] "CONTACT_PR_SPECIALITY" "UBM" "DEC02"
[10] "JAN03" "FEB03"...
2012 May 10
6
Is it suitable using STI?
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
2006 Jul 21
1
Partial, Table Layout, Multiple Controllers/Models... DRY?
...rows and I want "First Name", Last Name" and "Date Created" as the table
headings. Even if my object has 50 fields, I only want a select few of
them to show up in the list and want to be able to specify the ones to
show.
Then, I have an activity. For Activity, I have activity_type,
start_date, created_at, end_date, assigned_to, etc... I want the
headings to be "Activity Type", "Date Created", and "Assigned To".
What is the best approach to take here? If I make a change to the table
then I want it to be universal - so only one change instea...
2006 Mar 19
1
some strange behavior for has_many with STI
...ecord::Base
belongs_to :user
has_many :comments, :conditions => "type = ''Activity''", :foreign_key
=> "type_id"
acts_as_taggable :join_class_name => "TagActivity"
class Event < ActiveRecord::Base
include EventMatching
belongs_to :activity_type
has_and_belongs_to_many :users
has_many :comments, :conditions => "type = ''Event''", :foreign_key => "type_id"
class Comment < ActiveRecord::Base
belongs_to :user
belongs_to :activity, :conditions => "type = ''Activity''...