gistfile1.txt

# 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 => 20100427181820) do

  create_table "alternative_titles", :force => true do |t|
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "onet_soc_code"
  end

  add_index "alternative_titles", ["onet_soc_code"], :name => "index_alternative_titles_on_onet_soc_code"

  create_table "alternative_titles_occupations", :id => false, :force => true do |t|
    t.integer "alternative_title_id"
    t.integer "occupation_id"
  end

  create_table "delayed_jobs", :force => true do |t|
    t.integer  "priority",   :default => 0
    t.integer  "attempts",   :default => 0
    t.text     "handler"
    t.string   "last_error"
    t.datetime "run_at"
    t.datetime "locked_at"
    t.datetime "failed_at"
    t.string   "locked_by"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "email_templates", :force => true do |t|
    t.string   "name"
    t.string   "subject"
    t.text     "body"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "invites", :force => true do |t|
    t.string   "email"
    t.integer  "user_id"
    t.integer  "inviter_id"
    t.boolean  "used",       :default => false
    t.boolean  "approved",   :default => false
    t.datetime "sent_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "invites", ["email"], :name => "index_invites_on_email"

  create_table "job_searches", :force => true do |t|
    t.string   "job_title"
    t.string   "salary"
    t.string   "zip_code"
    t.string   "search_radius"
    t.string   "keywords"
    t.string   "industry"
    t.string   "company"
    t.string   "employee_type"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "lay_titles", :id => false, :force => true do |t|
    t.string "soc_code"
    t.string "soc_title"
    t.string "onet_soc_code"
    t.string "onet_soc_title"
    t.string "lay_title"
    t.string "type"
    t.string "source"
  end

  add_index "lay_titles", ["onet_soc_code"], :name => "index_lay_titles_on_onet_soc_code"

  create_table "occupation_reference", :id => false, :force => true do |t|
    t.string "onet_soc_code"
    t.string "onet_soc_title"
  end

  create_table "occupations", :force => true do |t|
    t.string   "title"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "onet_soc_code"
  end

  add_index "occupations", ["onet_soc_code"], :name => "index_occupations_on_onet_soc_code"
  add_index "occupations", ["title"], :name => "index_occupations_on_title"

  create_table "occupations_salaries", :id => false, :force => true do |t|
    t.integer "occupation_id"
    t.integer "salary_id"
  end

  create_table "occupations_skills", :id => false, :force => true do |t|
    t.integer "occupation_id"
    t.integer "skill_id"
  end

  create_table "occupations_tasks", :id => false, :force => true do |t|
    t.integer "occupation_id"
    t.integer "task_id"
  end

  create_table "oe_area", :id => false, :force => true do |t|
    t.string "area_code"
    t.string "areatype_code"
    t.string "area_name"
  end

  add_index "oe_area", ["area_code"], :name => "index_oe_area_on_area_code"

  create_table "oe_data_0_current", :id => false, :force => true do |t|
    t.string "series_id"
    t.string "year"
    t.string "period"
    t.string "salary"
    t.string "footnote_codes"
  end

  add_index "oe_data_0_current", ["series_id"], :name => "index_oe_data_0_current_on_series_id"

  create_table "oe_series", :id => false, :force => true do |t|
    t.string "series_id"
    t.string "seasonal"
    t.string "areatype_code"
    t.string "area_code"
    t.string "industry_code"
    t.string "occupation_code"
    t.string "datatype_code"
    t.string "footnote_codes"
    t.string "begin_year"
    t.string "begin_period"
    t.string "end_year"
    t.string "end_period"
  end

  add_index "oe_series", ["area_code"], :name => "index_oe_series_on_area_code"
  add_index "oe_series", ["datatype_code"], :name => "index_oe_series_on_datatype_code"
  add_index "oe_series", ["occupation_code"], :name => "index_oe_series_on_occupation_code"
  add_index "oe_series", ["series_id"], :name => "index_oe_series_on_series_id"

  create_table "onet_skills", :id => false, :force => true do |t|
    t.string "onet_soc_code"
    t.string "element_id"
    t.string "element_name"
    t.string "scale_id"
    t.string "data_value"
    t.string "n"
    t.string "standard_error"
    t.string "lower_ci_bound"
    t.string "upper_ci_bound"
    t.string "reccomend_suppress"
    t.string "not_relevant"
    t.string "date"
  end

  add_index "onet_skills", ["element_id"], :name => "index_onet_skills_on_element_id"
  add_index "onet_skills", ["onet_soc_code"], :name => "index_onet_skills_on_onet_soc_code"
  add_index "onet_skills", ["scale_id"], :name => "index_onet_skills_on_scale_id"

  create_table "profiles", :force => true do |t|
    t.string   "first_name"
    t.string   "last_name"
    t.integer  "user_id"
    t.boolean  "subscribed",          :default => false
    t.string   "avatar_file_name"
    t.string   "avatar_content_type"
    t.integer  "avatar_file_size"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "profiles", ["user_id"], :name => "index_profiles_on_user_id"

  create_table "referrals", :force => true do |t|
    t.integer  "referrer_id"
    t.integer  "referred_user_id"
    t.string   "email_address"
    t.text     "email_text"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "referrals", ["referred_user_id"], :name => "index_referrals_on_referred_user_id"
  add_index "referrals", ["referrer_id"], :name => "index_referrals_on_referrer_id"

  create_table "related_occupation_data", :id => false, :force => true do |t|
    t.string "onet_soc_code"
    t.string "related_onet_soc_code"
  end

  add_index "related_occupation_data", ["onet_soc_code"], :name => "index_related_occupation_data_on_onet_soc_code"
  add_index "related_occupation_data", ["related_onet_soc_code"], :name => "index_related_occupation_data_on_related_onet_soc_code"

  create_table "related_occupations", :id => false, :force => true do |t|
    t.integer "related_occupation_id"
    t.integer "main_occupation_id"
  end

  create_table "salaries", :force => true do |t|
    t.string   "onet_soc_code"
    t.string   "area_name"
    t.string   "areatype_code"
    t.string   "salary"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "pct_10"
    t.string   "pct_25"
    t.string   "median"
    t.string   "pct_75"
    t.string   "pct_90"
  end

  create_table "site_settings", :force => true do |t|
    t.string   "url"
    t.string   "description"
    t.string   "name"
    t.string   "admin_email"
    t.boolean  "beta_invites",    :default => false
    t.boolean  "user_avatars",    :default => false
    t.boolean  "referrals",       :default => false
    t.boolean  "public_profiles", :default => false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "skills", :force => true do |t|
    t.string   "onet_soc_code"
    t.string   "skill_id"
    t.string   "name"
    t.string   "importance"
    t.string   "level"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "skills", ["onet_soc_code"], :name => "index_skills_on_onet_soc_code"

  create_table "slugs", :force => true do |t|
    t.string   "name"
    t.integer  "sluggable_id"
    t.integer  "sequence",                     :default => 1, :null => false
    t.string   "sluggable_type", :limit => 40
    t.string   "scope",          :limit => 40
    t.datetime "created_at"
  end

  add_index "slugs", ["name", "sluggable_type", "scope", "sequence"], :name => "index_slugs_on_name_and_sluggable_type_and_scope_and_sequence", :unique => true
  add_index "slugs", ["sluggable_id"], :name => "index_slugs_on_sluggable_id"

  create_table "task_statements", :id => false, :force => true do |t|
    t.string "onet_soc_code"
    t.string "task_id"
    t.string "task"
    t.string "task_type"
    t.string "incumbants_responding"
    t.string "date"
    t.string "domain_source"
  end

  create_table "tasks", :force => true do |t|
    t.integer  "task_id"
    t.string   "description"
    t.string   "task_type"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "onet_soc_code"
  end

  create_table "users", :force => true do |t|
    t.string   "login"
    t.string   "email",                                  :null => false
    t.string   "crypted_password",                       :null => false
    t.string   "password_salt",                          :null => false
    t.string   "persistence_token",                      :null => false
    t.string   "single_access_token",                    :null => false
    t.string   "perishable_token",                       :null => false
    t.integer  "login_count",         :default => 0,     :null => false
    t.integer  "failed_login_count",  :default => 0,     :null => false
    t.datetime "last_request_at"
    t.datetime "current_login_at"
    t.datetime "last_login_at"
    t.string   "current_login_ip"
    t.string   "last_login_ip"
    t.string   "time_zone"
    t.integer  "invites",             :default => 0,     :null => false
    t.boolean  "admin",               :default => false, :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "users", ["email"], :name => "index_users_on_email", :unique => true
  add_index "users", ["login"], :name => "index_users_on_login", :unique => true

end