stevenbeales / mental-test

# frozen_string_literal: true

# Creates tables for association class between participants and studies

class CreateStudyParticipants < ActiveRecord::Migration[5.1]

  def change

    create_table :study_participants do |t|

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

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

      t.string :subject_number, null: true

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

    end

    add_index :study_participants, %i[participant_id study_id], unique: true, name: 'index_participant_study'

    add_index :study_participants, %i[study_id subject_number], name: 'index_study_subject_number'

  end

end

# Migration to create users table

# Users are linked to Alexa users via Account Linking

class CreateUsers < ActiveRecord::Migration[5.1]

  def change

    create_table :users, comment: 'Users table' do |t|

      t.string :username, null: false

      t.string :firstname, null: true

      t.string :lastname, null: true

      t.text :access_token, null: false, default: ''

      t.jsonb :preferences, null: false, default: '{}'

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

    end

    add_indexes_and_keys

  end

  def add_indexes_and_keys

    add_index :users, :preferences, using: :gin, name: 'preferences'

    add_index :users, :username, unique: true, name: 'username'

  end

end

# frozen_string_literal: true

# Creates table for visits

class CreateVisits < ActiveRecord::Migration[5.1]

  def change

    create_table :visits, comment: 'Visits table' do |t|

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

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

      t.string :name, null: true

      t.integer :number, null: false, default: 1

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

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

    end

    add_foreign_key :visits, :users

    add_foreign_key :visits, :surveys

    add_index :visits, %i[survey_id user_id number], unique: true, name: 'index_by_survey_user_number'

  end

end

# frozen_string_literal: true

# Migration to create instruments table

class CreateInstruments < ActiveRecord::Migration[5.1]

  def change

    create_table :instruments, comment: 'Instruments table' do |t|

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

      t.string :version_number, null: false, default: '1.0'

      t.string :instrument_type, null: false, default: 'json'

      t.jsonb :json_content, null: false, default: '{}'

      t.text :csv_content, null: false, index: true, default: ''

      t.text :instructions, null: false, default: ''

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

    end

    add_index :instruments, :json_content, using: :gin, name: 'instrument_json_content'

    add_index :instruments, %i[name version_number], unique: true

  end

end