# 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 to check this file into your version control system.

ActiveRecord::Schema.define(:version => 20081127034436) do

  create_table "accesos", :force => true do |t|
    t.string   "rut_evaluado"
    t.string   "rut_evaluador"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "cargos", :force => true do |t|
    t.string   "nombre"
    t.text     "descripcion"
    t.integer  "perfil",      :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "cuestionario_cargos", :force => true do |t|
    t.integer  "codigo_cargo",    :limit => 11
    t.integer  "cuestionario_id", :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "cuestionarios", :force => true do |t|
    t.string   "nombre"
    t.text     "descripcion"
    t.integer  "puntaje_minimo", :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "perfiles", :force => true do |t|
    t.text     "descripcion_perfil"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "personas", :force => true do |t|
    t.string   "rut"
    t.string   "dv"
    t.integer  "codigo_cargo",     :limit => 11
    t.string   "nombre"
    t.string   "apellido_paterno"
    t.string   "apellido_materno"
    t.string   "email"
    t.string   "telefono_1"
    t.string   "telefono_2"
    t.string   "anexo"
    t.string   "direccion"
    t.string   "contrasena"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "preguntas", :force => true do |t|
    t.integer  "cuetionario_id", :limit => 11
    t.integer  "numero",         :limit => 11
    t.string   "enunciado"
    t.string   "alternativa_1"
    t.string   "alternativa_2"
    t.string   "alternativa_3"
    t.string   "alternativa_4"
    t.string   "alternativa_5"
    t.integer  "calificacion_1", :limit => 11
    t.integer  "calificacion_2", :limit => 11
    t.integer  "calificacion_3", :limit => 11
    t.integer  "calificacion_4", :limit => 11
    t.integer  "calificacion_5", :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "respuestas", :force => true do |t|
    t.string   "rut_evaluado"
    t.string   "rut_evaluador"
    t.integer  "cuestionario_id",         :limit => 11
    t.integer  "numero",                  :limit => 11
    t.string   "numero_alternativa"
    t.string   "descripcion_alternativa"
    t.integer  "calificacion",            :limit => 11
    t.date     "fecha"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

end