Schema for primary

CREATE TABLE "substation_groups" (
"name" TEXT,
  "geometry" TEXT,
  "type" TEXT,
  "licence" TEXT,
  "source" TEXT,
  "location" TEXT,
  "substation_type_id" TEXT,
  "source_id" TEXT,
  "latitude" REAL,
  "longitude" REAL
);
CREATE TABLE "repd" (
"repd_project_id" TEXT,
  "operator" TEXT,
  "site_name" TEXT,
  "technology_type" TEXT,
  "installed_capacity" REAL,
  "development_status" TEXT,
  "address" TEXT,
  "county" TEXT,
  "region" TEXT,
  "country" TEXT,
  "postcode" TEXT,
  "longitude" REAL,
  "latitude" REAL,
  "planning_authority" TEXT,
  "date_permission_granted" TEXT,
  "date_under_construction" TEXT,
  "date_operational" TEXT,
  "source" TEXT,
  "location" TEXT,
  "ecr_project_id" TEXT
);
CREATE TABLE "substation_types" (
"location" TEXT,
  "type" TEXT,
  "licence" TEXT,
  "source" TEXT,
  "substation_ids" TEXT,
  "voltages" TEXT,
  "transformers" TEXT,
  "substation_type_id" TEXT,
  "latitude" REAL,
  "longitude" REAL,
  "source_id" TEXT
);
CREATE TABLE "ecr" (
"customer_name" TEXT,
  "customer_site" TEXT,
  "address_line_1" TEXT,
  "address_line_2" TEXT,
  "city" TEXT,
  "county" TEXT,
  "postcode" TEXT,
  "gsp" TEXT,
  "bsp" TEXT,
  "primary" TEXT,
  "voltage" REAL,
  "licence" TEXT,
  "energy_source" TEXT,
  "connection_status" TEXT,
  "connected_export" REAL,
  "date_connected" TEXT,
  "accepted_export" REAL,
  "accepted_import" REAL,
  "date_accepted" TEXT,
  "longitude" REAL,
  "latitude" REAL,
  "source" TEXT,
  "gsp_location" TEXT,
  "bsp_location" TEXT,
  "primary_location" TEXT,
  "ecr_project_id" TEXT,
  "primary_substation_type_id" TEXT,
  "bsp_substation_type_id" TEXT,
  "gsp_substation_type_id" TEXT,
  "country" TEXT
);
CREATE TABLE "metadata" (
"date" TIMESTAMP,
  "host" TEXT,
  "user" TEXT,
  "git_commit_id" TEXT,
  "git_branch" TEXT
)