create_building_energy_performance_table.sql

CREATE SCHEMA energy
  AUTHORIZATION postgres;

CREATE TABLE energy.building_energy_performance (
	"POSTCODE_WONING" VARCHAR NOT NULL,
	"HUISNUMMER_WONING" DECIMAL NOT NULL,
	"HUISNUMMER_TOEV_WONING" VARCHAR,
	"OPNAMEDATUM" DATE NOT NULL,
	"EP_TXT" VARCHAR,
	"LABEL" VARCHAR,
	"REGISTRATIEDATUM" DATE NOT NULL
);