legacy_schema.rb

class V1User < ActiveRecord::Base
  self.table_name = 'user'
  establish_connection :legacy
end

class V1Group < ActiveRecord::Base
  self.table_name = 'group'
  has_and_belongs_to_many :users, class_name: 'V1User', join_table: 'user_group',
                          foreign_key: 'group_id', association_foreign_key: 'user_id'
  establish_connection :legacy
end

class V1Feed < ActiveRecord::Base
  self.table_name = 'feed'
  self.inheritance_column = ''
  belongs_to :group, class_name: 'V1Group', foreign_key: 'group_id'
  establish_connection :legacy
end

class V1Type < ActiveRecord::Base
  self.table_name = 'type'
  establish_connection :legacy
end

class V1Content < ActiveRecord::Base
  self.table_name = 'content'
  self.inheritance_column = ''
  belongs_to :user, class_name: 'V1User', foreign_key: 'user_id'
  belongs_to :type, class_name: 'V1Type', foreign_key: 'type_id'
  establish_connection :legacy
end

class V1Submission < ActiveRecord::Base
  self.table_name = 'feed_content'
  establish_connection :legacy  
end

class V1Template < ActiveRecord::Base
  self.table_name = 'template'
  establish_connection :legacy
  has_many :fields, class_name: 'V1Field', foreign_key: 'template_id'
end

class V1Field < ActiveRecord::Base
  self.table_name = 'field'
  belongs_to :template, class_name: 'V1Template', foreign_key: 'template_id'
  belongs_to :type, class_name: 'V1Type', foreign_key: 'type_id'
  establish_connection :legacy
end

class V1Screen < ActiveRecord::Base
  self.table_name = 'screen'
  self.inheritance_column = ''
  establish_connection :legacy
  belongs_to :template, class_name: 'V1Template', foreign_key: 'template_id'
  has_many :subscriptions, class_name: 'V1Subscription', foreign_key: 'screen_id'
end

class V1Subscription < ActiveRecord::Base
  self.table_name = 'position'
  belongs_to :field, class_name: 'V1Field', foreign_key: 'field_id'
  belongs_to :screen, class_name: 'V1Screen', foreign_key: 'screen_id'
  belongs_to :feed, class_name: 'V1Feed', foreign_key: 'feed_id'
  establish_connection :legacy
end