Freedom Of Information Case Logs

CREATE TABLE freedom_of_information_case_logs (
  "n_1915_2016_07_25_procurement_hr_member_of_the_public__04e76edf" VARCHAR,
  "n__and_c_whether_this_is_on_a_neutral_master_hybrid_ve_9fd14f2d" VARCHAR,
  "n__b_the_date_s_that_any_break_clause_s_can_be_enabled" VARCHAR,
  "n__and_c_the_length_of_time_of_any_extension_that_can__02283119" VARCHAR,
  "c_group_either_team_division_or_department_whichever_i_ab9d7056" VARCHAR,
  "d_telephone_number" VARCHAR,
  "e_email" VARCHAR,
  "n__andf_full_postal_address_inc_postcode_6_please_iden_7137becc" VARCHAR,
  "n__b_non_contracted_as_identified_within_6_above" VARCHAR,
  "n__and_c_all_temporary_workers_the_food_standards_agen_001475cc" VARCHAR
);

CREATE TABLE freedom_of_information_case_logs_for_2018 (
  "casenumber" BIGINT,
  "dateofrequestreceived" TIMESTAMP,
  "division_branch" VARCHAR,
  "applicantcategory" VARCHAR,
  "outcomes" VARCHAR,
  "exemptionsapplied" VARCHAR,
  "dateofresponsesent" TIMESTAMP,
  "daystakentocomplete" VARCHAR,
  "requestwording" VARCHAR
);