Trafford Council - Parking Account

CREATE TABLE trafford_parking_account (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "period" VARCHAR,
  "on_street_income_parking" DOUBLE,
  "on_street_income_permit" DOUBLE,
  "on_street_income_pcn" DOUBLE,
  "on_street_income_blue_badge" BIGINT,
  "on_street_income_other" DOUBLE,
  "on_street_income_total" DOUBLE,
  "on_street_costs_enforcement" DOUBLE,
  "on_street_costs_admin" DOUBLE,
  "on_street_costs_schemes" BIGINT,
  "on_street_costs_capital" DOUBLE,
  "on_street_costs_other" BIGINT,
  "on_street_costs_total" DOUBLE,
  "on_street_surplus_deficit" DOUBLE,
  "on_street_surplus_deficit_spend_off_street_parking" BIGINT,
  "on_street_surplus_deficit_spend_park_and_ride" BIGINT,
  "on_street_surplus_deficit_spend_supported_bus" BIGINT,
  "on_street_surplus_deficit_spend_concessionary_fares" BIGINT,
  "on_street_surplus_deficit_spend_community_transport" BIGINT,
  "on_street_surplus_deficit_spend_shopmobility" BIGINT,
  "on_street_surplus_deficit_spend_school_crossing" BIGINT,
  "on_street_surplus_deficit_spend_highway_maintenance" DOUBLE,
  "on_street_surplus_deficit_spend_transport_planning" BIGINT,
  "on_street_surplus_deficit_spend_other" BIGINT,
  "off_street_income_parking" DOUBLE,
  "off_street_income_pcn" VARCHAR,
  "off_street_income_other" DOUBLE,
  "off_street_income_total" DOUBLE,
  "off_street_costs_total" DOUBLE,
  "off_street_surplus_deficit" DOUBLE
);

CREATE TABLE trafford_parking_account_metadata (
  "name" VARCHAR,
  "description" VARCHAR
);