Affordable Houses Customer Survey

CREATE TABLE affordable_housing_customer_survey (
  "ref_no" BIGINT,
  "rp" VARCHAR,
  "scheme" VARCHAR,
  "tenure" VARCHAR,
  "type" VARCHAR,
  "bed" DOUBLE,
  "residents" VARCHAR,
  "dhc" VARCHAR,
  "transfer" VARCHAR,
  "h2bsw" VARCHAR,
  "other" VARCHAR,
  "if_you_answered_other" VARCHAR,
  "how_did_you_apply_tell_us_more" VARCHAR  -- How Did You Apply - Tell Us More,
  "enough_info" VARCHAR  -- Enough Info?,
  "useful_info" VARCHAR  -- Useful Info?,
  "rp_service" VARCHAR,
  "rp_service_comments" VARCHAR,
  "well_designed" VARCHAR,
  "storage_space" VARCHAR,
  "struggle_to_store" VARCHAR  -- Struggle To Store?,
  "layout" VARCHAR,
  "kitchen_style" VARCHAR,
  "prefered_kitchen" VARCHAR,
  "noise" VARCHAR  -- Noise?,
  "what_noise" VARCHAR  -- What Noise?,
  "shared_areas" VARCHAR,
  "shared_area_comments" VARCHAR,
  "like_most" VARCHAR  -- Like Most?,
  "like_least" VARCHAR  -- Like Least?,
  "financial_support" VARCHAR  -- Financial Support?,
  "finance_support" VARCHAR  -- Finance Support?,
  "affordable" VARCHAR  -- Affordable?,
  "affordable_comment" VARCHAR  -- Affordable Comment?,
  "energy_bills" VARCHAR,
  "energy" VARCHAR,
  "car" VARCHAR  -- Car?,
  "parking" VARCHAR  -- Parking?,
  "viparking" VARCHAR  -- ViParking?,
  "parking_comments" VARCHAR,
  "no_cars" DOUBLE  -- No. Cars,
  "safe_home" VARCHAR  -- Safe Home?,
  "tum_safe_home" VARCHAR,
  "safe_outside" VARCHAR  -- Safe Outside?,
  "tum_safe_out" VARCHAR,
  "home_attractive" VARCHAR  -- Home Attractive?,
  "home_attractiveness_comment" VARCHAR,
  "street_attractive" VARCHAR  -- Street Attractive?,
  "street_attractiveness_comment" VARCHAR,
  "shops" VARCHAR,
  "schools" VARCHAR,
  "parks" VARCHAR,
  "community" VARCHAR,
  "health" VARCHAR,
  "public_transport" VARCHAR,
  "n_1" VARCHAR  -- 1,
  "n_2" VARCHAR  -- 2,
  "n_3" VARCHAR  -- 3,
  "n_4" VARCHAR  -- 4,
  "n_5" VARCHAR  -- 5,
  "n_6" VARCHAR  -- 6,
  "n_7" VARCHAR  -- 7,
  "n_8" VARCHAR  -- 8,
  "n_9" VARCHAR  -- 9,
  "n_10" VARCHAR  -- 10,
  "n_11" VARCHAR  -- 11,
  "n_12" VARCHAR  -- 12,
  "disability" VARCHAR,
  "have_adaptions_been_made" VARCHAR,
  "happy_with_adaptions" VARCHAR,
  "adaptations" VARCHAR,
  "overall_satisfaction" VARCHAR,
  "comments" VARCHAR,
  "age" VARCHAR,
  "gender" VARCHAR
);