stevenbeales / mental-test

# frozen_string_literal: true

# Table to represent study events in an arm

class CreateStudyEvents < ActiveRecord::Migration[5.1]

  def change

    create_table :study_events do |t|

      t.string :name, null: false, index: true

      t.integer :order, null: false, index: true, default: 1

      t.references :arm, null: false, foreign_key: true, index: true 

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

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

    end

    add_index :study_events, %i[arm_id name], unique: true, name: 'index_by_arm_name'

  end

end

# frozen_string_literal: true

# Creates tables for association class between participants and surveys

class CreateSurveyParticipants < ActiveRecord::Migration[5.1]

  def change

    create_table :survey_participants do |t|

      t.references :participant, null: false, foreign_key: true

      t.references :survey, null: false, foreign_key: true

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

    end

    add_index :survey_participants, %i[participant_id survey_id], unique: true, name: 'index_by_participant_survey'

  end

end

# frozen_string_literal: true

# Creates table for association class between assessments and instruments

class CreateAssessmentInstruments < ActiveRecord::Migration[5.1]

  def change

    create_table :assessment_instruments do |t|

      t.references :assessment, null: false, foreign_key: true

      t.references :instrument, null: false, foreign_key: true

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

    end

    add_index :assessment_instruments, 

              %i[assessment_id instrument_id], 

              unique: true,

              name: 'index_by_assessment_instrument'

  end

end

# frozen_string_literal: true

# Migration to add assessment scores table

class CreateScores < ActiveRecord::Migration[5.1]

  def change

    create_table :scores, comment: 'Scores table' do |t|

      t.references :assessment, null: false, index: true

      t.string :name, null: false, index: true

      t.integer :score, null: false, default: 0

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

    end

    add_index :scores, %i[assessment_id name], unique: true, name: 'index_by_assessment_name'

  end

end