Trafford Council - Organisation Chart

CREATE TABLE senior_structure_dataset (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "level" BIGINT,
  "jobtitle" VARCHAR,
  "name" VARCHAR,
  "grade" VARCHAR,
  "directorate" VARCHAR,
  "service" VARCHAR,
  "contracttype" VARCHAR,
  "sharedpost" VARCHAR,
  "contactdetails" VARCHAR,
  "salaryband" VARCHAR,
  "maximumsalary" VARCHAR,
  "vacancy" VARCHAR,
  "comments" VARCHAR
);

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