I need the association model (relationship.rb) to be separate from child and outage, bc child and outage will connect to two separate remote SQL Server databases that will just read data. Where the relationship model will make the association: child belongs_to outage, outage has_many children

child.rb

class Child < ApplicationRecord
end

outage.rb

class Outage < ApplicationRecord
  has_many :relationships
  has_many :children, through: :relationships
end

relationship.rb

class Relationship < ApplicationRecord
  belongs_to :outage, optional: true
end