CREATE TABLE IF NOT EXISTS "solar" (
	"id" bigserial PRIMARY KEY NOT NULL,
	"longitude" real NOT NULL,
	"latitude" real NOT NULL,
	"uprn" text NOT NULL,
	"created_at" timestamp (6) with time zone DEFAULT now() NOT NULL,
	"updated_at" timestamp (6) with time zone DEFAULT now() NOT NULL,
	"api_response" jsonb NOT NULL
);
