stevenbeales / mental-test

# frozen_string_literal: true

# Creates table for association class between study_events and instruments

class CreateStudyEventInstruments < ActiveRecord::Migration[5.1]

  def change

    create_table :study_event_instruments do |t|

      t.references :study_event, null: false

      t.references :instrument, null: false

      t.timestamps null: false, default: -> { 'CURRENT_TIMESTAMP' }

    end

    add_index :study_event_instruments, %i[study_event_id instrument_id], \

              unique: true, name: 'index_by_study_event_instrument' 

    add_foreign_key :study_event_instruments, :study_events

    add_foreign_key :study_event_instruments, :instruments

  end

end

# frozen_string_literal: true

# Creates table for items/questions in an instrument

class CreateItems < ActiveRecord::Migration[5.1]

  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