Defra Government Procurement Card Spend - Transactions Over £500

CREATE TABLE defra_government_procurement_card_spend_transactions_over_500 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_april_2017 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_april_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_april_2019_revised (
  "jncc_26_04_2019_park_avenue_hotel_belfast_4_555_50_one_ca3b5745" VARCHAR  -- JNCC,26/04/2019,"Park Avenue Hotel, Belfast","Ł4,555.50",One Hundredth And Ninth Meeting Of The Joint Nature Conservation Committee And Audit Risk Assurance Committee To Be Held On 5-6 June In Belfast,
  "n__dinner_at_park4_avenue_hotel_for_10_jncc_staff" VARCHAR  -- Dinner At Park4 Avenue Hotel For 10 JNCC Staff,
  "n__9_official_attendees" VARCHAR  -- 9 Official Attendees,
  "n__11_committee_members_accommodation_x_9_jncc_staff_8_57571042" VARCHAR  -- 11 Committee Members. Accommodation X 9 JNCC Staff (8 X 2 Nights,
  "n__1_x_1_night" VARCHAR  -- 1 X 1 Night),
  "n__4_committee_members_x_2_nights" VARCHAR  -- 4 Committee Members X 2 Nights,
  "n__x_1_night_x_2_official_attendees" VARCHAR  -- X 1 Night X 2 Official Attendees,
  "n__meeting_refreshments_x_2_days_for_10_jncc_staff" VARCHAR  -- Meeting Refreshments X 2 Days For 10 JNCC Staff,
  "n__11_committee_members" VARCHAR  -- 11 Committee Members,
  "n__10_guests" VARCHAR  -- 10 Guests,
  "n__9_official_attendees_d685ce" VARCHAR  -- 9 Official Attendees.
);

CREATE TABLE defra_gpc_spend_over_500_april_2020_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_august_2017_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_august_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_august_2019_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_august_2020_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_december_2016 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_december_2017_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_december_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_december_2019_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_february_2017 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_february_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_february_2019_revised (
  "jncc_25_02_2019_themanagementcentr_3835_2_accommodatio_f3842f27" VARCHAR  -- JNCC,25/02/2019,THEMANAGEMENTCENTR,3835.2,Accommodation And Dinner For The One Hundreth And Eighteenth Meeting Of The Joint Nature Conservation Committee Held On 14 March At Natural Resources Resources Wales,
  "n__dinner_at_bangor_university_dinner_for_9_jncc_staff" VARCHAR  -- Dinner At Bangor University. Dinner For 9 JNCC Staff,
  "n__5_officials" VARCHAR  -- 5 Officials,
  "n__8_committee_members" VARCHAR  -- 8 Committee Members,
  "n__and_2_guests_accommodation_x_11_jncc_staff" VARCHAR  -- And 2 Guests. Accommodation X 11 JNCC Staff,
  "n__4_committee_members" VARCHAR  -- 4 Committee Members,
  "n__2_audit_risk_accounting_committee_members_and_1_guest" VARCHAR  -- 2 Audit Risk Accounting Committee Members And 1 Guest
);

CREATE TABLE defra_gpc_spend_over_500_february_2020_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_january_2017 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_january_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_january_2019_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_january_2020_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_july_2017 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_july_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_july_2019_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE defra_gpc_spend_over_500_july_2020_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);