 CREATE TABLE calc_renpass_gis.renpass_gis_scenario
 (
 
-  id integer,
+  id integer NOT NULL DEFAULT nextval('calc_renpass_gis.renpass_gis_scenario_id_seq'),
   name character varying(250)  UNIQUE NOT NULL,
   CONSTRAINT renpass_gis_scenario_pkey PRIMARY KEY (id)
 )

   ADD CONSTRAINT results_scenario_fkey
   FOREIGN KEY (scenario_id) 
   REFERENCES calc_renpass_gis.renpass_gis_scenario(id);



-- ToDOs
-- Add further constraints



CREATE TABLE calc_renpass_gis.renpass_gis_storage
(
  id bigint NOT NULL DEFAULT nextval('calc_renpass_gis.renpass_gis_storage_id_seq'),
  scenario_id integer,
  label character varying(250),
  source character varying(250), --- check constraints()
