Trafford Council - Fraud

CREATE TABLE trafford_counter_fraud (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "totaloccasionsfraudpowers" BIGINT,
  "totalfraudemployeescount" BIGINT,
  "ftefraudemployeescount" DOUBLE,
  "totalfraudspecialistscount" BIGINT,
  "ftefraudspecialistcount" DOUBLE,
  "fraudspentamount" BIGINT,
  "totalinvestigatedfraud" BIGINT
);

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