class CreateTables < ActiveRecord::Migration
  def change
    create_table "study_engine_answers" do |t|
      t.integer  "result_id",          limit: 4
      t.string   "question_context",   limit: 255
      t.string   "response_title",     limit: 255
      t.string   "response_id",        limit: 255
      t.datetime "created_at",                     null: false
      t.datetime "updated_at",                     null: false
      t.string   "question_id",        limit: 255
      t.string   "question_title",     limit: 255
      t.string   "question_promis_id", limit: 255
      t.string   "response_promis_id", limit: 255
      t.string   "response_before",    limit: 255
    end

    create_table "study_engine_assessments" do |t|
      t.text     "finished_cat_assessment_ids", limit: 65535
      t.datetime "created_at",                                null: false
      t.datetime "updated_at",                                null: false
      t.string   "study_id",                    limit: 255
      t.string   "event",                       limit: 255
      t.integer  "group_index",                 limit: 4
      t.string   "method_applied",              limit: 255
      t.integer  "coordinator_id",              limit: 4
      t.datetime "assessment_updated_at",                     null: false
      t.text     "notes",                       limit: 65535
      t.datetime "completed_at"
    end

    create_table "study_engine_results" do |t|
      t.integer  "assessment_id",  limit: 4
      t.string   "bank_id",        limit: 255
      t.boolean  "finished",                                            default: false
      t.decimal  "theta",                      precision: 10, scale: 5
      t.decimal  "standard_error",             precision: 10, scale: 5
      t.datetime "created_at",                                                          null: false
      t.datetime "updated_at",                                                          null: false
    end

    add_index "study_engine_results", ["assessment_id"], name: "index_study_engine_results_on_assessment_id", using: :btree
    add_index "study_engine_results", ["bank_id"], name: "index_results_on_cat_assessment_id", using: :btree

    create_table "study_engine_study_ids" do |t|
      t.string   "study_id_study", limit: 255
      t.string   "study_id_site",  limit: 255
      t.string   "study_id_id",    limit: 255
      t.datetime "created_at"
      t.datetime "updated_at"
    end
  end
end