Schema for intermediate

CREATE TABLE "cim_substations" (
"substation_id" TEXT,
  "substation_name" TEXT,
  "source" TEXT,
  "licence" TEXT,
  "type" TEXT,
  "location" TEXT
);
CREATE TABLE "cim_transformers" (
"transformer_id" TEXT,
  "transformer_name" TEXT,
  "source" TEXT,
  "node_id_1" TEXT,
  "node_id_2" TEXT,
  "node_id_3" TEXT,
  "gsp_group_id" TEXT,
  "gsp_group_name" TEXT,
  "bsp_group_id" TEXT,
  "substation_id" TEXT,
  "bsp_group_name" TEXT,
  "substation_name" TEXT,
  "node_1" TEXT,
  "node_2" TEXT,
  "node_3" TEXT,
  "nom_rating" REAL,
  "voltage_1" REAL,
  "voltage_2" REAL,
  "voltage_3" REAL,
  "transformer_type" TEXT,
  "licence" TEXT
);
CREATE TABLE "cim_circuits" (
"circuit_id" TEXT,
  "circuit_name" TEXT,
  "source" TEXT,
  "licence" TEXT,
  "equipment" TEXT,
  "node_id_1" TEXT,
  "node_id_2" TEXT,
  "node_name_1" TEXT,
  "node_name_2" TEXT,
  "substation_id_1" TEXT,
  "substation_id_2" TEXT,
  "substation_name_1" TEXT,
  "substation_name_2" TEXT,
  "rating" REAL,
  "circuit_length" REAL,
  "normally_open" INTEGER,
  "voltage" REAL,
  "gsp_group_id" TEXT,
  "gsp_group_name" TEXT
);
CREATE TABLE "substations" (
"substation_id" TEXT,
  "substation_name" TEXT,
  "source" TEXT,
  "licence" TEXT,
  "type" TEXT,
  "location" TEXT,
  "name" TEXT,
  "longitude" REAL,
  "latitude" REAL,
  "geometry" TEXT,
  "source_id" TEXT,
  "region" 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,
  "country" TEXT
);
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
);
CREATE TABLE "transformer_flows" (
"name" TEXT,
  "type" TEXT,
  "longitude" REAL,
  "latitude" REAL,
  "voltage" REAL,
  "firm_capacity" REAL,
  "min_transformer_flow" REAL,
  "max_transformer_flow" REAL,
  "source" TEXT,
  "location" TEXT,
  "geometry" TEXT,
  "licence" TEXT,
  "source_id" TEXT
);
CREATE TABLE "metadata" (
"date" TIMESTAMP,
  "host" TEXT,
  "user" TEXT,
  "git_commit_id" TEXT,
  "git_branch" TEXT
)