stevenbeales / mental-test

db/migrate/20180225053906_create_items.rb

# frozen_string_literal: true

# Creates table for items/questions in an instrument
class CreateItems < ActiveRecord::Migration[5.1]

This code seems to be duplicated in your project.

  def change
    create_table :items, comment: 'Items table' do |t|
      t.references :instrument, null: false, index: true
      t.string :name, null: false
      t.string :item_type, null: false
      t.string :title, null: false
      t.references :response_scale, null: true, index: true
      t.boolean :is_required, null: false, default: true
      t.timestamps null: false, default: -> { 'CURRENT_TIMESTAMP' }    
    end
    add_keys_and_indexes
  end

  def add_keys_and_indexes
    add_foreign_key :items, :instruments
    add_foreign_key :items, :response_scales
    add_index :items, :name, unique: true, name: 'index_by_item_name'
  end
end