|
|
|
|
# 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.
|
|
|
|
|
#
|
|
|
|
|
# This file is the source Rails uses to define your schema when running `bin/rails
|
|
|
|
|
# db:schema:load`. When creating a new database, `bin/rails db:schema:load` tends to
|
|
|
|
|
# be faster and is potentially less error prone than running all of your
|
|
|
|
|
# migrations from scratch. Old migrations may fail to apply correctly if those
|
|
|
|
|
# migrations use external dependencies or application code.
|
|
|
|
|
#
|
|
|
|
|
# It's strongly recommended that you check this file into your version control system.
|
|
|
|
|
|
|
|
|
|
ActiveRecord::Schema.define(version: 2021_11_18_090831) do
|
|
|
|
|
|
|
|
|
|
# These are extensions that must be enabled in order to support this database
|
|
|
|
|
enable_extension "plpgsql"
|
|
|
|
|
|
|
|
|
|
create_table "case_logs", force: :cascade do |t|
|
|
|
|
|
t.integer "status", default: 0
|
|
|
|
|
t.datetime "created_at", precision: 6, null: false
|
|
|
|
|
t.datetime "updated_at", precision: 6, null: false
|
|
|
|
|
t.string "tenant_code"
|
|
|
|
|
t.integer "age1"
|
|
|
|
|
t.string "sex1"
|
|
|
|
|
t.integer "ethnic"
|
|
|
|
|
t.integer "national"
|
|
|
|
|
t.integer "prevten"
|
|
|
|
|
t.integer "ecstat1"
|
|
|
|
|
t.integer "hhmemb"
|
|
|
|
|
t.string "relat2"
|
|
|
|
|
t.integer "age2"
|
|
|
|
|
t.string "sex2"
|
|
|
|
|
t.integer "ecstat2"
|
|
|
|
|
t.string "relat3"
|
|
|
|
|
t.integer "age3"
|
|
|
|
|
t.string "sex3"
|
|
|
|
|
t.integer "ecstat3"
|
|
|
|
|
t.string "relat4"
|
|
|
|
|
t.integer "age4"
|
|
|
|
|
t.string "sex4"
|
|
|
|
|
t.integer "ecstat4"
|
|
|
|
|
t.string "relat5"
|
|
|
|
|
t.integer "age5"
|
|
|
|
|
t.string "sex5"
|
|
|
|
|
t.integer "ecstat5"
|
|
|
|
|
t.string "relat6"
|
|
|
|
|
t.integer "age6"
|
|
|
|
|
t.string "sex6"
|
|
|
|
|
t.integer "ecstat6"
|
|
|
|
|
t.string "relat7"
|
|
|
|
|
t.integer "age7"
|
|
|
|
|
t.string "sex7"
|
|
|
|
|
t.integer "ecstat7"
|
|
|
|
|
t.string "relat8"
|
|
|
|
|
t.integer "age8"
|
|
|
|
|
t.string "sex8"
|
|
|
|
|
t.integer "ecstat8"
|
|
|
|
|
t.integer "homeless"
|
|
|
|
|
t.integer "underoccupation_benefitcap"
|
|
|
|
|
t.integer "leftreg"
|
|
|
|
|
t.integer "reservist"
|
|
|
|
|
t.integer "illness"
|
|
|
|
|
t.integer "preg_occ"
|
|
|
|
|
t.string "accessibility_requirements"
|
|
|
|
|
t.string "condition_effects"
|
|
|
|
|
t.string "tenancy_code"
|
|
|
|
|
t.integer "startertenancy"
|
|
|
|
|
t.integer "tenancylength"
|
|
|
|
|
t.integer "tenancy"
|
|
|
|
|
t.string "lettype"
|
|
|
|
|
t.integer "landlord"
|
|
|
|
|
t.string "previous_postcode"
|
|
|
|
|
t.integer "rsnvac"
|
|
|
|
|
t.integer "unittype_gn"
|
|
|
|
|
t.string "property_building_type"
|
|
|
|
|
t.integer "beds"
|
|
|
|
|
t.string "property_void_date"
|
|
|
|
|
t.integer "offered"
|
|
|
|
|
t.integer "wchair"
|
|
|
|
|
t.integer "earnings"
|
|
|
|
|
t.integer "incfreq"
|
|
|
|
|
t.integer "benefits"
|
|
|
|
|
t.integer "period"
|
|
|
|
|
t.integer "brent"
|
|
|
|
|
t.integer "scharge"
|
|
|
|
|
t.integer "pscharge"
|
|
|
|
|
t.integer "supcharg"
|
|
|
|
|
t.integer "tcharge"
|
|
|
|
|
t.integer "layear"
|
|
|
|
|
t.integer "lawaitlist"
|
|
|
|
|
t.string "property_postcode"
|
|
|
|
|
t.integer "reasonpref"
|
|
|
|
|
t.string "reasonable_preference_reason"
|
|
|
|
|
t.integer "cbl"
|
|
|
|
|
t.integer "chr"
|
|
|
|
|
t.integer "cap"
|
|
|
|
|
t.string "other_reason_for_leaving_last_settled_home"
|
|
|
|
|
t.integer "housingneeds_a"
|
|
|
|
|
t.integer "housingneeds_b"
|
|
|
|
|
t.integer "housingneeds_c"
|
|
|
|
|
t.integer "housingneeds_f"
|
|
|
|
|
t.integer "housingneeds_g"
|
|
|
|
|
t.integer "housingneeds_h"
|
|
|
|
|
t.integer "accessibility_requirements_prefer_not_to_say"
|
|
|
|
|
t.integer "illness_type_1"
|
|
|
|
|
t.integer "illness_type_2"
|
|
|
|
|
t.integer "illness_type_3"
|
|
|
|
|
t.integer "illness_type_4"
|
|
|
|
|
t.integer "illness_type_8"
|
|
|
|
|
t.integer "illness_type_5"
|
|
|
|
|
t.integer "illness_type_6"
|
|
|
|
|
t.integer "illness_type_7"
|
|
|
|
|
t.integer "illness_type_9"
|
|
|
|
|
t.integer "illness_type_10"
|
|
|
|
|
t.integer "rp_homeless"
|
|
|
|
|
t.integer "rp_insan_unsat"
|
|
|
|
|
t.integer "rp_medwel"
|
|
|
|
|
t.integer "rp_hardship"
|
|
|
|
|
t.integer "rp_dontknow"
|
|
|
|
|
t.datetime "discarded_at"
|
|
|
|
|
t.string "tenancyother"
|
|
|
|
|
t.integer "override_net_income_validation"
|
|
|
|
|
t.string "net_income_known"
|
|
|
|
|
t.string "gdpr_acceptance"
|
|
|
|
|
t.string "gdpr_declined"
|
|
|
|
|
t.string "property_owner_organisation"
|
|
|
|
|
t.string "property_manager_organisation"
|
|
|
|
|
t.string "sale_or_letting"
|
|
|
|
|
t.string "tenant_same_property_renewal"
|
|
|
|
|
t.string "rent_type"
|
|
|
|
|
t.string "intermediate_rent_product_name"
|
|
|
|
|
t.string "needs_type"
|
|
|
|
|
t.string "purchaser_code"
|
|
|
|
|
t.integer "reason"
|
|
|
|
|
t.string "propcode"
|
|
|
|
|
t.integer "majorrepairs"
|
|
|
|
|
t.string "la"
|
|
|
|
|
t.string "prevloc"
|
|
|
|
|
t.integer "hb"
|
|
|
|
|
t.integer "hbrentshortfall"
|
|
|
|
|
t.integer "tshortfall"
|
|
|
|
|
t.string "postcode"
|
|
|
|
|
t.string "postcod2"
|
|
|
|
|
t.string "ppostc1"
|
|
|
|
|
t.string "ppostc2"
|
|
|
|
|
t.integer "property_relet"
|
|
|
|
|
t.datetime "mrcdate"
|
|
|
|
|
t.integer "mrcday"
|
|
|
|
|
t.integer "mrcmonth"
|
|
|
|
|
t.integer "mrcyear"
|
|
|
|
|
t.integer "other_hhmemb"
|
|
|
|
|
t.integer "incref"
|
|
|
|
|
t.datetime "sale_completion_date"
|
|
|
|
|
t.datetime "startdate"
|
|
|
|
|
t.integer "armedforces"
|
|
|
|
|
t.index ["discarded_at"], name: "index_case_logs_on_discarded_at"
|
|
|
|
|
end
|
|
|
|
|
|
|
|
|
|
create_table "users", force: :cascade do |t|
|
|
|
|
|
t.string "email", default: "", null: false
|
|
|
|
|
t.string "encrypted_password", default: "", null: false
|
|
|
|
|
t.string "reset_password_token"
|
|
|
|
|
t.datetime "reset_password_sent_at"
|
|
|
|
|
t.datetime "remember_created_at"
|
|
|
|
|
t.datetime "created_at", precision: 6, null: false
|
|
|
|
|
t.datetime "updated_at", precision: 6, null: false
|
|
|
|
|
t.index ["email"], name: "index_users_on_email", unique: true
|
|
|
|
|
t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
|
|
|
|
|
end
|
|
|
|
|
|
|
|
|
|
end
|
