Sha256: 9ff5e63939fb739d2ddedda7dbd428fc99616d306b113d5cfdf996b805fd9889

Contents?: true

Size: 940 Bytes

Versions: 11

Compression:

Stored size: 940 Bytes

Contents

# encoding: UTF-8
class CreateResponses < ActiveRecord::Migration
  def self.up
    create_table :responses do |t|
      # Context
      t.integer :response_set_id
      t.integer :question_id

      # Content
      t.integer :answer_id
      t.datetime :datetime_value # handles date, time, and datetime (segregate by answer.response_class)

      #t.datetime :time_value
      t.integer :integer_value
      t.float :float_value
      t.string :unit
      t.text :text_value
      t.string :string_value
      t.string :response_other #used to hold the string entered with "Other" type answers in multiple choice questions

      # arbitrary identifier used to group responses
      # the pertinent example here is Q: What's your car's make/model/year
      # group 1: Ford/Focus/2007
      # group 2: Toyota/Prius/2006
      t.string :response_group

      t.timestamps
    end
  end

  def self.down
    drop_table :responses
  end
end

Version data entries

11 entries across 11 versions & 4 rubygems

Version Path
upgrade_surveyor-1.4.2 lib/generators/surveyor/templates/db/migrate/create_responses.rb
affectiva-surveyor-1.5.0.pre.disco.2 lib/generators/surveyor/templates/db/migrate/create_responses.rb
hssc_surveyor-1.4.3.pre lib/generators/surveyor/templates/db/migrate/create_responses.rb
hssc_surveyor-1.4.2.pre lib/generators/surveyor/templates/db/migrate/create_responses.rb
hssc_surveyor-1.4.1.pre lib/generators/surveyor/templates/db/migrate/create_responses.rb
surveyor-1.4.0 lib/generators/surveyor/templates/db/migrate/create_responses.rb
surveyor-1.3.0 lib/generators/surveyor/templates/db/migrate/create_responses.rb
surveyor-1.2.0 lib/generators/surveyor/templates/db/migrate/create_responses.rb
surveyor-1.1.0 lib/generators/surveyor/templates/db/migrate/create_responses.rb
surveyor-1.0.1 lib/generators/surveyor/templates/db/migrate/create_responses.rb
surveyor-1.0.0 lib/generators/surveyor/templates/db/migrate/create_responses.rb