forecast_defs.sql

CREATE TABLE forecast_base_0
(
  nwp_analysis_at_date timestamp without time zone NOT NULL,
  nwp_analysis_at_time_period smallint NOT NULL,
  nwp_analysis_prognosis integer NOT NULL,
  issued_prognosis integer NOT NULL,
  valid_from_date timestamp without time zone NOT NULL,
  valid_from_time_period smallint NOT NULL,
  location_id bigint NOT NULL,
  source_id bigint NOT NULL,
  element_id bigint NOT NULL,
  pdf character varying(4000),
  value double precision NOT NULL,
  valid_toex_date timestamp without time zone NOT NULL,
  valid_toex_time_period smallint NOT NULL,
  issued_at_date timestamp without time zone NOT NULL,
  
   CONSTRAINT forecast_base_0_pkey PRIMARY KEY (location_id, source_id, element_id, nwp_analysis_at_date, nwp_analysis_at_time_period, valid_from_date, valid_from_time_period)
);
  

CREATE TABLE forecast_base_1
(
  nwp_analysis_at_date date NOT NULL,
  nwp_analysis_at_time_period smallint NOT NULL,
  nwp_analysis_prognosis smallint NOT NULL,
  issued_prognosis smallint NOT NULL,
  valid_from_date date NOT NULL,
  valid_from_time_period smallint NOT NULL,
  location_id integer NOT NULL,
  source_id integer NOT NULL,
  element_id integer NOT NULL,
  pdf character varying(4000),
  value double precision NOT NULL,
  valid_toex_date date NOT NULL,
  valid_toex_time_period smallint NOT NULL,
  issued_at_date timestamp without time zone NOT NULL,
  
  CONSTRAINT forecast_base_1_pkey PRIMARY KEY (source_id, element_id, location_id, nwp_analysis_at_date, nwp_analysis_at_time_period, valid_from_date, valid_from_time_period)  
);