+# == Schema Information
+#
+# Table name: relations
+#
+# relation_id :bigint(8) not null, primary key
+# changeset_id :bigint(8) not null
+# timestamp :datetime not null
+# version :bigint(8) not null, primary key
+# visible :boolean default(TRUE), not null
+# redaction_id :integer
+#
+# Indexes
+#
+# relations_changeset_id_idx (changeset_id)
+# relations_timestamp_idx (timestamp)
+#
+# Foreign Keys
+#
+# relations_changeset_id_fkey (changeset_id => changesets.id)
+# relations_redaction_id_fkey (redaction_id => redactions.id)
+#
+
+class OldRelation < ApplicationRecord
+ self.table_name = "relations"
+
+ # NOTE: this needs to be included after the table name changes, or
+ # the queries generated by Redactable will use the wrong table name.
+ include Redactable
+
+ belongs_to :changeset
+ belongs_to :redaction, :optional => true
+ belongs_to :current_relation, :class_name => "Relation", :foreign_key => "relation_id", :inverse_of => :old_relations
+
+ has_many :old_members, -> { order(:sequence_id) }, :class_name => "OldRelationMember", :query_constraints => [:relation_id, :version], :inverse_of => :old_relation
+ has_many :old_tags, :class_name => "OldRelationTag", :query_constraints => [:relation_id, :version], :inverse_of => :old_relation
+
+ validates :changeset, :associated => true
+ validates :timestamp, :presence => true
+ validates :visible, :inclusion => [true, false]