Contents

class CreateUnicoRegularizationOrAdministrativeSanctions < ActiveRecord::Migration
  def change
    create_table :unico_regularization_or_administrative_sanctions do |t|
      t.references :creditor
      t.references :regularization_or_administrative_sanction_reason
      t.date :suspended_until
      t.date :occurrence
      t.timestamps
    end

    add_foreign_key :unico_regularization_or_administrative_sanctions, :unico_creditors,
                    column: :creditor_id, name: :uroas_creditor_id_fk
    add_foreign_key :unico_regularization_or_administrative_sanctions, :unico_regularization_or_administrative_sanction_reasons,
                    column: :regularization_or_administrative_sanction_reason_id,
                    name: :uroas_regularization_or_administrative_sanction_reason_id_fk

    add_index :unico_regularization_or_administrative_sanctions, :creditor_id,
              name: :idx_uroas_on_creditor_id
    add_index :unico_regularization_or_administrative_sanctions, :regularization_or_administrative_sanction_reason_id,
              name: :idx_uroas_regularization_or_administrative_sanction_reason_id
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
unico-training-7.8.0	db/migrate/20130708170709_create_unico_regularization_or_administrative_sanctions.rb