# encoding: UTF-8 # This file is auto-generated from the current state of the database. Instead # of editing this file, please use the migrations feature of Active Record to # incrementally modify your database, and then regenerate this schema definition. # # Note that this schema.rb definition is the authoritative source for your # database schema. If you need to create the application database on another # system, you should be using db:schema:load, not running all the migrations # from scratch. The latter is a flawed and unsustainable approach (the more migrations # you'll amass, the slower it'll run and the greater likelihood for issues). # # It's strongly recommended that you check this file into your version control system. ActiveRecord::Schema.define(version: 20151208012348) do create_table "answers", force: :cascade 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 "assessments", force: :cascade 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 "results", force: :cascade 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 "results", ["assessment_id"], name: "index_results_on_assessment_id", using: :btree add_index "results", ["bank_id"], name: "index_results_on_cat_assessment_id", using: :btree create_table "study_engine_study_ids", force: :cascade 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