Create table definition documentation for downloads

[virtix]

Some people will use existing databases and tools with data downloads. It would be helpful to create a table definition for data downloaded through the HMDA UI. For example, some DDL like the following that people can use (the data types, obviously, are not be ideal):

postrgeSQL

-- Table: hmda_lar

-- DROP TABLE hmda_lar;

CREATE TABLE hmda_lar
(
  tract_to_msamd_income character varying(128),
  rate_spread character varying(128),
  population character varying(128),
  minority_population character varying(128),
  number_of_owner_occupied_units character varying(128),
  number_of_1_to_4_family_units character varying(128),
  loan_amount_000s character varying(128),
  hud_median_family_income character varying(128),
  applicant_income_000s character varying(128),
  state_name character varying(128),
  state_abbr character varying(128),
  sequence_number character varying(128),
  respondent_id character varying(128),
  purchaser_type_name character varying(128),
  property_type_name character varying(128),
  preapproval_name character varying(128),
  owner_occupancy_name character varying(128),
  msamd_name character varying(128),
  loan_type_name character varying(128),
  loan_purpose_name character varying(128),
  lien_status_name character varying(128),
  hoepa_status_name character varying(128),
  edit_status_name character varying(128),
  denial_reason_name_3 character varying(128),
  denial_reason_name_2 character varying(128),
  denial_reason_name_1 character varying(128),
  county_name character varying(128),
  co_applicant_sex_name character varying(128),
  co_applicant_race_name_5 character varying(128),
  co_applicant_race_name_4 character varying(128),
  co_applicant_race_name_3 character varying(128),
  co_applicant_race_name_2 character varying(128),
  co_applicant_race_name_1 character varying(128),
  co_applicant_ethnicity_name character varying(128),
  census_tract_number character varying(128),
  as_of_year character varying(128),
  application_date_indicator character varying(128),
  applicant_sex_name character varying(128),
  applicant_race_name_5 character varying(128),
  applicant_race_name_4 character varying(128),
  applicant_race_name_3 character varying(128),
  applicant_race_name_2 character varying(128),
  applicant_race_name_1 character varying(128),
  applicant_ethnicity_name character varying(128),
  agency_name character varying(128),
  agency_abbr character varying(128),
  action_taken_name character varying(128)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE hmda_lar
  OWNER TO postgres;