create_table "ticket_assignments", :force => true do |t|
    t.integer  "ticket_id"
    t.string   "owner_type"
    t.integer  "owner_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "ticket_statuses", :force => true do |t|
    t.integer  "ticket_id"
    t.integer  "user_id"
    t.integer  "status"
    t.datetime "created_at"
  end

  create_table "tickets", :force => true do |t|
    t.string   "name"
    t.text     "description"
    t.datetime "due_date"
    t.integer  "repetition"
    t.integer  "category"
    t.integer  "user_id"
    t.integer  "consultancy_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end


--

Ticket.rb

  named_scope :assigned, lambda { |user_id,group_ids| { :joins => [:ticket_assignments],
                                                        :select => "DISTINCT tickets.*",
                                                        :conditions => [ "((ticket_assignments.owner_type IN ('User','Manager') and ticket_assignments.owner_id = ?) or " +
                                                                          "(ticket_assignments.owner_type = 'Group' and ticket_assignments.owner_id IN (?))) " , user_id, group_ids] }}


--