Schema for master_data

CREATE TABLE "distribution_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,
  "node_1_type" TEXT,
  "node_1_substation_type_id" TEXT,
  "node_2_type" TEXT,
  "node_2_substation_type_id" TEXT,
  "circuit_gen_headroom" REAL,
  "circuit_dem_headroom" REAL,
  "global_gen_headroom" REAL,
  "global_dem_headroom" REAL,
  "upstream_constraint_gen" TEXT,
  "upstream_constraint_dem" TEXT,
  "path" TEXT
);
CREATE TABLE "distribution_projects" (
"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,
  "assumed_bsp_substation" INTEGER,
  "assumed_gsp_substation" INTEGER,
  "outside_bsp_boundary" INTEGER,
  "outside_gsp_boundary" INTEGER,
  "assumed_coordinates" INTEGER,
  "repd_project_id" TEXT
);
CREATE TABLE "distribution_substations" (
"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,
  "bsp_group_id" TEXT,
  "bsp_group_name" TEXT,
  "gsp_group_id" TEXT,
  "gsp_group_name" TEXT,
  "other_substation_ids" TEXT,
  "global_gen_headroom" REAL,
  "global_dem_headroom" REAL
);
CREATE TABLE "transmission_substations" (
"substation_id" TEXT,
  "source_id" TEXT,
  "location" TEXT,
  "site_code" TEXT,
  "voltages" TEXT,
  "name" TEXT,
  "type" TEXT,
  "source" TEXT,
  "licence" TEXT,
  "transformer_id" TEXT,
  "transformers" TEXT,
  "transformer_count" INTEGER,
  "retain_edits" INTEGER,
  "longitude" REAL,
  "latitude" REAL,
  "connected" REAL,
  "diagram_url" TEXT
);
CREATE TABLE "transmission_circuits" (
"node_1" TEXT,
  "node_2" TEXT,
  "circuit_length" REAL,
  "equipment" TEXT,
  "summer_rating" REAL,
  "source" TEXT,
  "licence" TEXT,
  "year" INTEGER,
  "status" TEXT,
  "voltage" REAL,
  "rating" REAL,
  "node_1_substation_id" TEXT,
  "source_id" TEXT,
  "node_1_location" TEXT,
  "site_code" TEXT,
  "voltages" TEXT,
  "node_1_name" TEXT,
  "node_1_type" TEXT,
  "source_node_1" TEXT,
  "licence_node_1" TEXT,
  "transformer_id" TEXT,
  "transformers" TEXT,
  "transformer_count" REAL,
  "retain_edits" INTEGER,
  "longitude" REAL,
  "latitude" REAL,
  "node_2_substation_id" TEXT,
  "source_id_node_2" TEXT,
  "node_2_location" TEXT,
  "site_code_node_2" TEXT,
  "voltages_node_2" TEXT,
  "node_2_name" TEXT,
  "node_2_type" TEXT,
  "source_node_2" TEXT,
  "licence_node_2" TEXT,
  "transformer_id_node_2" TEXT,
  "transformers_node_2" TEXT,
  "transformer_count_node_2" REAL,
  "retain_edits_node_2" REAL,
  "longitude_node_2" REAL,
  "latitude_node_2" REAL,
  "circuit_id" TEXT,
  "is_ignored" INTEGER
);
CREATE TABLE "transmission_tec" (
"customer_site" TEXT,
  "customer_name" TEXT,
  "connection_site" TEXT,
  "stage" INTEGER,
  "connected" REAL,
  "target_energisation_date" TEXT,
  "connection_status" TEXT,
  "source" TEXT,
  "plant_type" TEXT,
  "project_id" TEXT,
  "location" TEXT,
  "type" TEXT,
  "substation_id" TEXT,
  "retain_edits" INTEGER,
  "source_id" TEXT
);
CREATE TABLE "metadata" (
"date" TIMESTAMP,
  "host" TEXT,
  "user" TEXT,
  "git_commit_id" TEXT,
  "git_branch" TEXT
)