ActiveRecord::Schema.define(version: 20150204142307) do

  # These are extensions that must be enabled in order to support this database
  enable_extension "plpgsql"

  create_table "adjectives", force: :cascade do |t|
    t.string   "adjective"
    t.text     "definition"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "nrusers", force: :cascade do |t|
    t.string   "email"
    t.string   "name"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "responses", force: :cascade do |t|
    t.string   "relation"
    t.integer  "survey_id"
    t.integer  "adjective_id"
    t.datetime "created_at",   null: false
    t.datetime "updated_at",   null: false
  end

  add_index "responses", ["adjective_id"], name: "index_responses_on_adjective_id", using: :btree
  add_index "responses", ["survey_id"], name: "index_responses_on_survey_id", using: :btree

  create_table "surveys", force: :cascade do |t|
    t.string   "name"
    t.string   "suid"
    t.string   "sruid"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.integer  "nruser_id"
  end

  add_index "surveys", ["nruser_id"], name: "index_surveys_on_nruser_id", using: :btree

  add_foreign_key "surveys", "nrusers"
end