text: --
  -- PostgreSQL database dump
  --
  
  -- Dumped from database version 12.4 (Debian 12.4-1.pgdg100+1)
  -- Dumped by pg_dump version 12.6 (Debian 12.6-1.pgdg100+1)
  
  SET statement_timeout = 0;
  SET lock_timeout = 0;
  SET idle_in_transaction_session_timeout = 0;
  SET client_encoding = 'UTF8';
  SET standard_conforming_strings = on;
  SELECT pg_catalog.set_config('search_path', '', false);
  SET check_function_bodies = false;
  SET xmloption = content;
  SET client_min_messages = warning;
  SET row_security = off;
  
  
  
  --
  -- Name: public; Type: SCHEMA; Schema: -; Owner: -
  --
  DROP SCHEMA public CASCADE;
  CREATE SCHEMA public;
  
  COMMENT ON SCHEMA public IS 'standard public schema';
  
  
  --
  -- Name: discharge_measurement_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.discharge_measurement_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  SET default_tablespace = '';
  
  SET default_table_access_method = heap;
  
  --
  -- Name: discharge_measurement; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.discharge_measurement (
      id integer DEFAULT nextval('public.discharge_measurement_id_seq'::regclass) NOT NULL,
      operatorid integer NOT NULL,
      discharge_measurement_equipmentid integer NOT NULL,
      mpointid integer NOT NULL,
      date timestamp without time zone NOT NULL,
      q numeric(20,10) NOT NULL,
      h numeric(20,10) NOT NULL,
      width numeric(20,10) NOT NULL,
      area numeric(20,10) NOT NULL,
      wetted_perimeter numeric(20,10) NOT NULL,
      depth_max numeric(20,10) NOT NULL,
      velocity_max numeric(20,10) NOT NULL,
      velocity_average numeric(20,10) NOT NULL,
      temperature numeric(20,10) NOT NULL
  );
  
  
  --
  -- Name: COLUMN discharge_measurement.date; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.discharge_measurement.date IS 'Date of discharge calibration measurement (UTC)';
  
  
  --
  -- Name: COLUMN discharge_measurement.q; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.discharge_measurement.q IS 'Discharge at time of measurement [m³/s]';
  
  
  --
  -- Name: COLUMN discharge_measurement.h; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.discharge_measurement.h IS 'Water level at time of measurement [cm]';
  
  
  --
  -- Name: COLUMN discharge_measurement.width; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.discharge_measurement.width IS 'Width of water surface [m]';
  
  
  --
  -- Name: COLUMN discharge_measurement.area; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.discharge_measurement.area IS 'Area of cross-section [m²]';
  
  
  --
  -- Name: COLUMN discharge_measurement.wetted_perimeter; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.discharge_measurement.wetted_perimeter IS 'Wetted perimeter [m]';
  
  
  --
  -- Name: COLUMN discharge_measurement.depth_max; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.discharge_measurement.depth_max IS 'Maximum depth [m]';
  
  
  --
  -- Name: COLUMN discharge_measurement.velocity_max; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.discharge_measurement.velocity_max IS 'Maximum velocity [m/s]';
  
  
  --
  -- Name: COLUMN discharge_measurement.velocity_average; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.discharge_measurement.velocity_average IS 'velocity_ average [m/s]';
  
  
  --
  -- Name: COLUMN discharge_measurement.temperature; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.discharge_measurement.temperature IS 'Water temperature at time of measurement [°C]';
  
  
  --
  -- Name: discharge_measurement_equipment_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.discharge_measurement_equipment_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: discharge_measurement_equipment; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.discharge_measurement_equipment (
      id integer DEFAULT nextval('public.discharge_measurement_equipment_id_seq'::regclass) NOT NULL,
      description character varying(255) NOT NULL
  );
  
  
  --
  -- Name: COLUMN discharge_measurement_equipment.description; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.discharge_measurement_equipment.description IS 'Description of equipment of discharge calibration measurement';
  
  
  --
  -- Name: event_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.event_logs_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: event_logs; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.event_logs (
      id integer DEFAULT nextval('public.event_logs_id_seq'::regclass) NOT NULL,
      event_type character varying(50) NOT NULL,
      data text,
      created_at timestamp without time zone,
      user_id integer,
      operator_id integer
  );
  
  
  --
  -- Name: COLUMN event_logs.event_type; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.event_logs.event_type IS 'Identifier of event type';
  
  
  --
  -- Name: group_measurement_access_rules_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.group_measurement_access_rules_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: group_measurement_access_rules; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.group_measurement_access_rules (
      id integer DEFAULT nextval('public.group_measurement_access_rules_id_seq'::regclass) NOT NULL,
      measurement_access_rule_id integer,
      group_id integer,
      "interval" interval
  );
  
  
  --
  -- Name: group_permissions; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.group_permissions (
      permissionsid integer NOT NULL,
      groupsid integer NOT NULL
  );
  
  
  --
  -- Name: TABLE group_permissions; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON TABLE public.group_permissions IS 'Enabled permissions for groups';
  
  
  --
  -- Name: groups_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.groups_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: groups; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.groups (
      id integer DEFAULT nextval('public.groups_id_seq'::regclass) NOT NULL,
      name character varying(255) NOT NULL
  );
  
  
  --
  -- Name: COLUMN groups.id; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.groups.id IS 'Id of group';
  
  
  --
  -- Name: COLUMN groups.name; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.groups.name IS 'Unique name of group';
  
  
  --
  -- Name: hydro_observed_property_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.hydro_observed_property_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: hydro_observed_property; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.hydro_observed_property (
      id integer DEFAULT nextval('public.hydro_observed_property_id_seq'::regclass) NOT NULL,
      symbol character varying(32) NOT NULL,
      type smallint NOT NULL,
      description character varying(64) NOT NULL,
      unit character varying(12) NOT NULL
  );
  
  
  --
  -- Name: COLUMN hydro_observed_property.symbol; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydro_observed_property.symbol IS 'Abbreviation of observed property (e.g. “h_max_daily” for daily maximum of water level)';
  
  
  --
  -- Name: COLUMN hydro_observed_property.type; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydro_observed_property.type IS 'Real time: 0, processed: 1';
  
  
  --
  -- Name: COLUMN hydro_observed_property.description; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydro_observed_property.description IS 'Human readable description of observed property (e.g. “Daily maximum of water level”)';
  
  
  --
  -- Name: COLUMN hydro_observed_property.unit; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydro_observed_property.unit IS 'Unit of parameter, e.g. “cm”';
  
  
  --
  -- Name: hydro_result_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.hydro_result_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: hydro_result; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.hydro_result (
      id bigint DEFAULT nextval('public.hydro_result_id_seq'::regclass) NOT NULL,
      time_seriesid bigint NOT NULL,
      "time" timestamp without time zone NOT NULL,
      value numeric(20,10) NOT NULL,
      created_at timestamp without time zone NOT NULL,
      is_forecast boolean DEFAULT false NOT NULL
  );
  
  
  --
  -- Name: COLUMN hydro_result."time"; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydro_result."time" IS 'Phenomenon timestamp of measured property (UTC)';
  
  
  --
  -- Name: COLUMN hydro_result.value; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydro_result.value IS 'Value of the measured property, NULL for not available';
  
  
  --
  -- Name: hydro_time_series_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.hydro_time_series_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: hydro_time_series; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.hydro_time_series (
      id bigint DEFAULT nextval('public.hydro_time_series_id_seq'::regclass) NOT NULL,
      observed_propertyid integer NOT NULL,
      mpointid integer NOT NULL,
      phenomenon_time_begin timestamp without time zone,
      phenomenon_time_end timestamp without time zone,
      result_time timestamp without time zone NOT NULL
  );
  
  
  --
  -- Name: COLUMN hydro_time_series.id; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydro_time_series.id IS 'Identifier';
  
  
  --
  -- Name: COLUMN hydro_time_series.phenomenon_time_begin; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydro_time_series.phenomenon_time_begin IS 'Starting phenomenon time of time series (UTC)';
  
  
  --
  -- Name: COLUMN hydro_time_series.phenomenon_time_end; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydro_time_series.phenomenon_time_end IS 'End phenomenon time of time series (UTC)';
  
  
  --
  -- Name: COLUMN hydro_time_series.result_time; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydro_time_series.result_time IS 'Result time, when time series was processed (UTC)';
  
  
  --
  -- Name: hydropoint_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.hydropoint_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: hydropoint; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.hydropoint (
      id integer DEFAULT nextval('public.hydropoint_id_seq'::regclass) NOT NULL,
      station_classificationid integer,
      operatorid integer,
      bankid integer,
      eucd_riv character varying(64),
      eucd_wgst character varying(64) NOT NULL,
      ncd_wgst character varying(64) NOT NULL,
      vertical_reference character varying(32),
      long numeric(20,10),
      lat numeric(20,10),
      z numeric(20,10),
      maplong numeric(20,10),
      maplat numeric(20,10),
      country character varying(2) NOT NULL,
      name character varying(128) NOT NULL,
      location character varying(255),
      river_kilometer numeric(20,10),
      catchment_area numeric(20,10),
      gauge_zero numeric(20,10),
      start_time timestamp without time zone,
      end_time timestamp without time zone,
      utc_offset integer,
      river_basin character varying(64),
      is_active boolean DEFAULT true NOT NULL
  );
  
  
  --
  -- Name: COLUMN hydropoint.id; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.id IS 'Identifier of the water gauge station';
  
  
  --
  -- Name: COLUMN hydropoint.eucd_wgst; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.eucd_wgst IS 'International code of water gauge station (Link to DanubeGIS database). [country] & [NCD_WGST] & “_HYDRO”';
  
  
  --
  -- Name: COLUMN hydropoint.ncd_wgst; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.ncd_wgst IS 'National code of water gauge station';
  
  
  --
  -- Name: COLUMN hydropoint.vertical_reference; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.vertical_reference IS 'Reference Vertical Datum identifier, e.g. European Vertical Reference Frame 2007 (EVRF2007)';
  
  
  --
  -- Name: COLUMN hydropoint.long; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.long IS 'Coordinates of water gauge station: EPSG 4326 (WGS 84) Longitude [°]';
  
  
  --
  -- Name: COLUMN hydropoint.lat; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.lat IS 'Coordinates of water gauge station: EPSG 4326 (WGS 84) Latitude [°]';
  
  
  --
  -- Name: COLUMN hydropoint.z; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.z IS 'Coordinates of water gauge station: Height [m]';
  
  
  --
  -- Name: COLUMN hydropoint.maplong; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.maplong IS 'Longitude Coordinates of water gauge station for display on map';
  
  
  --
  -- Name: COLUMN hydropoint.maplat; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.maplat IS 'Lattude Coordinates of water gauge station for display on map';
  
  
  --
  -- Name: COLUMN hydropoint.country; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.country IS 'Country code of water gauge station ISO3166-1 ALPHA-2 (e.g. “DE”)';
  
  
  --
  -- Name: COLUMN hydropoint.name; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.name IS 'Locally used name of water gauge station';
  
  
  --
  -- Name: COLUMN hydropoint.location; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.location IS 'Closest commune or landmark';
  
  
  --
  -- Name: COLUMN hydropoint.river_kilometer; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.river_kilometer IS 'Location at river the water gauge station is located, distance from mouth';
  
  
  --
  -- Name: COLUMN hydropoint.catchment_area; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.catchment_area IS 'Drainage basin area of water gauge station [km²]';
  
  
  --
  -- Name: COLUMN hydropoint.gauge_zero; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.gauge_zero IS 'Gravity-related altitude of the zero level of the gauge above the sea level [m]';
  
  
  --
  -- Name: COLUMN hydropoint.start_time; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.start_time IS 'Starting time of time series measurements on this water gauge station (UTC)';
  
  
  --
  -- Name: COLUMN hydropoint.end_time; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.end_time IS 'Ending time of time series measurements on this water gauge station (UTC)';
  
  
  --
  -- Name: COLUMN hydropoint.utc_offset; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.utc_offset IS 'Time zone the water gauge station belongs to UTC+X [min], disregarding daylight-saving time.';
  
  
  --
  -- Name: COLUMN hydropoint.river_basin; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint.river_basin IS 'Name of river basin to which meteorological station belongs';
  
  
  --
  -- Name: hydropoint_observed_property; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.hydropoint_observed_property (
      observed_propertyid integer NOT NULL,
      mpointid integer NOT NULL,
      last_update timestamp without time zone,
      min_value numeric(20,10),
      min_value_time timestamp without time zone,
      max_value numeric(20,10),
      max_value_time timestamp without time zone
  );
  
  
  --
  -- Name: COLUMN hydropoint_observed_property.last_update; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint_observed_property.last_update IS 'Time of last update of this parameter at this water gauge station (UTC)';
  
  
  --
  -- Name: COLUMN hydropoint_observed_property.min_value; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint_observed_property.min_value IS 'Minimum value of parameter in time series measured at this water gauge station';
  
  
  --
  -- Name: COLUMN hydropoint_observed_property.min_value_time; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint_observed_property.min_value_time IS 'Time at which minimum value was measured (UTC)';
  
  
  --
  -- Name: COLUMN hydropoint_observed_property.max_value; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint_observed_property.max_value IS 'Maximum value of parameter in time series measured at this water gauge station';
  
  
  --
  -- Name: COLUMN hydropoint_observed_property.max_value_time; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydropoint_observed_property.max_value_time IS 'Time at which maximum value was measured (UTC)';
  
  
  --
  -- Name: hydrostation_classification_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.hydrostation_classification_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: hydrostation_classification; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.hydrostation_classification (
      id integer DEFAULT nextval('public.hydrostation_classification_id_seq'::regclass) NOT NULL,
      value character varying(255) NOT NULL
  );
  
  
  --
  -- Name: COLUMN hydrostation_classification.id; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydrostation_classification.id IS 'Identifier';
  
  
  --
  -- Name: COLUMN hydrostation_classification.value; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.hydrostation_classification.value IS 'String to describe current classification of water gauge station within hydrological network (e.g. “project station”, “basic-network station”)';
  
  
  --
  -- Name: measurement_access_rules_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.measurement_access_rules_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: measurement_access_rules; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.measurement_access_rules (
      id integer DEFAULT nextval('public.measurement_access_rules_id_seq'::regclass) NOT NULL,
      operator_id integer,
      monitoringpoint_selector text,
      observed_property_selector text
  );
  
  
  --
  -- Name: meteo_observed_property_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.meteo_observed_property_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: meteo_observed_property; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.meteo_observed_property (
      id integer DEFAULT nextval('public.meteo_observed_property_id_seq'::regclass) NOT NULL,
      symbol character varying(32) NOT NULL,
      type smallint NOT NULL,
      description character varying(64) NOT NULL,
      unit character varying(12) NOT NULL
  );
  
  
  --
  -- Name: COLUMN meteo_observed_property.symbol; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteo_observed_property.symbol IS 'Abbreviation of observed property (e.g. “P_total_daily” for daily total of precipitation)';
  
  
  --
  -- Name: COLUMN meteo_observed_property.type; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteo_observed_property.type IS 'Real time: 0, processed: 1';
  
  
  --
  -- Name: COLUMN meteo_observed_property.description; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteo_observed_property.description IS 'Human readable description of observed property (e.g. “Daily total of precipitation”)';
  
  
  --
  -- Name: COLUMN meteo_observed_property.unit; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteo_observed_property.unit IS 'Unit of parameter, e.g. “mm”';
  
  
  --
  -- Name: meteo_result_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.meteo_result_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: meteo_result; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.meteo_result (
      id bigint DEFAULT nextval('public.meteo_result_id_seq'::regclass) NOT NULL,
      time_seriesid bigint NOT NULL,
      "time" timestamp without time zone NOT NULL,
      value numeric(20,10) NOT NULL,
      created_at timestamp without time zone NOT NULL,
      is_forecast boolean DEFAULT false
  );
  
  
  --
  -- Name: COLUMN meteo_result."time"; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteo_result."time" IS 'Phenomenon timestamp of measured property (UTC)';
  
  
  --
  -- Name: COLUMN meteo_result.value; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteo_result.value IS 'Value of the measured property, NULL for not available';
  
  
  --
  -- Name: meteo_time_series_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.meteo_time_series_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: meteo_time_series; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.meteo_time_series (
      id bigint DEFAULT nextval('public.meteo_time_series_id_seq'::regclass) NOT NULL,
      mpointid integer NOT NULL,
      observed_propertyid integer NOT NULL,
      phenomenon_time_begin timestamp without time zone,
      phenomenon_time_end timestamp without time zone,
      result_time timestamp without time zone NOT NULL
  );
  
  
  --
  -- Name: COLUMN meteo_time_series.id; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteo_time_series.id IS 'Identifier';
  
  
  --
  -- Name: COLUMN meteo_time_series.phenomenon_time_begin; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteo_time_series.phenomenon_time_begin IS 'Starting phenomenon time of time series (UTC)';
  
  
  --
  -- Name: COLUMN meteo_time_series.phenomenon_time_end; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteo_time_series.phenomenon_time_end IS 'End phenomenon time of time series (UTC)';
  
  
  --
  -- Name: COLUMN meteo_time_series.result_time; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteo_time_series.result_time IS 'Result time, when time series was processed (UTC)';
  
  
  --
  -- Name: meteopoint_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.meteopoint_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: meteopoint; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.meteopoint (
      id integer DEFAULT nextval('public.meteopoint_id_seq'::regclass) NOT NULL,
      station_classificationid integer,
      operatorid integer,
      eucd_pst character varying(64) NOT NULL,
      ncd_pst character varying(64) NOT NULL,
      vertical_reference character varying(32),
      long numeric(20,10),
      lat numeric(20,10),
      z numeric(20,10),
      maplong numeric(20,10),
      maplat numeric(20,10),
      country character varying(2) NOT NULL,
      name character varying(128) NOT NULL,
      location character varying(255),
      altitude numeric(20,10),
      start_time timestamp without time zone,
      end_time timestamp without time zone,
      utc_offset integer,
      river_basin character varying(64),
      is_active boolean DEFAULT true NOT NULL
  );
  
  
  --
  -- Name: COLUMN meteopoint.id; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.id IS 'Identifier of the water gauge station';
  
  
  --
  -- Name: COLUMN meteopoint.eucd_pst; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.eucd_pst IS 'International code of meteorological station (Link to DanubeGIS database). [country] & [NCD_PST] & “_METEO”';
  
  
  --
  -- Name: COLUMN meteopoint.ncd_pst; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.ncd_pst IS 'National code of meteorological station';
  
  
  --
  -- Name: COLUMN meteopoint.vertical_reference; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.vertical_reference IS 'Reference Vertical Datum identifier, e.g. European Vertical Reference Frame 2007 (EVRF2007)';
  
  
  --
  -- Name: COLUMN meteopoint.long; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.long IS 'Coordinates of meteorological station: EPSG 4326 (WGS 84) Longitude [°]';
  
  
  --
  -- Name: COLUMN meteopoint.lat; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.lat IS 'Coordinates of meteorological station: EPSG 4326 (WGS 84) Latitude [°]';
  
  
  --
  -- Name: COLUMN meteopoint.z; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.z IS 'Coordinates of meteorological station: Height [m]';
  
  
  --
  -- Name: COLUMN meteopoint.maplong; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.maplong IS 'Longitude of meteorological station for display on map';
  
  
  --
  -- Name: COLUMN meteopoint.maplat; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.maplat IS 'Lattude of meteorological station for display on map';
  
  
  --
  -- Name: COLUMN meteopoint.country; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.country IS 'Country code of meteorological station ISO 3166-1 ALPHA-2 (e.g. “DE”)';
  
  
  --
  -- Name: COLUMN meteopoint.name; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.name IS 'Locally used name of meteorological station';
  
  
  --
  -- Name: COLUMN meteopoint.location; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.location IS 'Closest commune or landmark';
  
  
  --
  -- Name: COLUMN meteopoint.altitude; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.altitude IS 'Gravity-related altitude of the zero level of the gauge above the sea level [m]. Same as gauge_zero for water gauge stations.';
  
  
  --
  -- Name: COLUMN meteopoint.start_time; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.start_time IS 'Starting time of time series measurements on this meteorological station (UTC)';
  
  
  --
  -- Name: COLUMN meteopoint.end_time; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.end_time IS 'Ending time of time series measurements on this meteorological station (UTC)';
  
  
  --
  -- Name: COLUMN meteopoint.utc_offset; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.utc_offset IS 'Time zone the meteorological station belongs to UTC+X [min], disregarding daylight-saving time.';
  
  
  --
  -- Name: COLUMN meteopoint.river_basin; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint.river_basin IS 'Name of river basin to which meteorological station belongs';
  
  
  --
  -- Name: meteopoint_observed_property; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.meteopoint_observed_property (
      observed_propertyid integer NOT NULL,
      mpointid integer NOT NULL,
      last_update timestamp without time zone,
      min_value numeric(20,10),
      min_value_time timestamp without time zone,
      max_value numeric(20,10),
      max_value_time timestamp without time zone
  );
  
  
  --
  -- Name: COLUMN meteopoint_observed_property.last_update; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint_observed_property.last_update IS 'Time of last update of this parameter at this meteorological station (UTC)';
  
  
  --
  -- Name: COLUMN meteopoint_observed_property.min_value; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint_observed_property.min_value IS 'Minimum value of parameter in time series measured at this meteorological station';
  
  
  --
  -- Name: COLUMN meteopoint_observed_property.min_value_time; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint_observed_property.min_value_time IS 'Time at which minimum value was measured (UTC)';
  
  
  --
  -- Name: COLUMN meteopoint_observed_property.max_value; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint_observed_property.max_value IS 'Maximum value of parameter in time series measured at this meteorological station';
  
  
  --
  -- Name: COLUMN meteopoint_observed_property.max_value_time; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteopoint_observed_property.max_value_time IS 'Time at which maximum value was measured (UTC)';
  
  
  --
  -- Name: meteostation_classification_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.meteostation_classification_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: meteostation_classification; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.meteostation_classification (
      id integer DEFAULT nextval('public.meteostation_classification_id_seq'::regclass) NOT NULL,
      value character varying(255) NOT NULL
  );
  
  
  --
  -- Name: COLUMN meteostation_classification.id; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteostation_classification.id IS 'Identifier';
  
  
  --
  -- Name: COLUMN meteostation_classification.value; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.meteostation_classification.value IS 'String to describe current classification of meteorological station within meteorological network (e.g. “project station”, “basic-network station”)';
  
  
  --
  -- Name: operator_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.operator_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: operator; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.operator (
      id integer DEFAULT nextval('public.operator_id_seq'::regclass) NOT NULL,
      name character varying(255) NOT NULL,
      address character varying(255) NOT NULL,
      email character varying(255) NOT NULL,
      phone character varying(255) NOT NULL,
      url character varying(255),
      other_info text
  );
  
  
  --
  -- Name: COLUMN operator.name; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.operator.name IS 'Name of organization which operates water gauge station';
  
  
  --
  -- Name: COLUMN operator.address; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.operator.address IS 'Address of operating organization';
  
  
  --
  -- Name: COLUMN operator.email; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.operator.email IS 'Email address of operating organization';
  
  
  --
  -- Name: COLUMN operator.phone; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.operator.phone IS 'Phone number of operating organization';
  
  
  --
  -- Name: COLUMN operator.url; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.operator.url IS 'Website of operating organization';
  
  
  --
  -- Name: COLUMN operator.other_info; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.operator.other_info IS 'Information on the operator not fitting in above fields';
  
  
  --
  -- Name: operator_groups; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.operator_groups (
      groupsid integer NOT NULL,
      operatorid integer NOT NULL
  );
  
  
  --
  -- Name: TABLE operator_groups; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON TABLE public.operator_groups IS 'Connection table between operator and groups. Operators could have more than one groups, but groups should be unique in this table';
  
  
  --
  -- Name: operator_users; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.operator_users (
      usersid integer NOT NULL,
      operatorid integer NOT NULL
  );
  
  
  --
  -- Name: TABLE operator_users; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON TABLE public.operator_users IS 'Connection table between operator and users. Operators could have more than one users, but users should be unique in this table';
  
  
  --
  -- Name: permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.permissions_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: permissions; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.permissions (
      id integer DEFAULT nextval('public.permissions_id_seq'::regclass) NOT NULL,
      name character varying(255) NOT NULL
  );
  
  
  --
  -- Name: COLUMN permissions.id; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.permissions.id IS 'Permission id';
  
  
  --
  -- Name: COLUMN permissions.name; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.permissions.name IS 'Permission unique name';
  
  
  --
  -- Name: public_keys_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.public_keys_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: public_keys; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.public_keys (
      id integer DEFAULT nextval('public.public_keys_id_seq'::regclass) NOT NULL,
      usersid integer NOT NULL,
      public_key text NOT NULL,
      revoked boolean DEFAULT false NOT NULL,
      revoked_at timestamp without time zone
  );
  
  
  --
  -- Name: COLUMN public_keys.id; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.public_keys.id IS 'Internal id of public key';
  
  
  --
  -- Name: COLUMN public_keys.public_key; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.public_keys.public_key IS 'The public key';
  
  
  --
  -- Name: river; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.river (
      eucd_riv character varying(64) NOT NULL,
      cname character varying(255) NOT NULL
  );
  
  
  --
  -- Name: COLUMN river.eucd_riv; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.river.eucd_riv IS 'International code of river or canal to which the water gauge station belongs. Same as River.EUCD_RIV in DanubeGIS.';
  
  
  --
  -- Name: COLUMN river.cname; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.river.cname IS 'Human readable name of the water body, part of river, etc. the code refers to';
  
  
  --
  -- Name: riverbank_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.riverbank_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: riverbank; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.riverbank (
      id integer DEFAULT nextval('public.riverbank_id_seq'::regclass) NOT NULL,
      value character varying(255) NOT NULL
  );
  
  
  --
  -- Name: COLUMN riverbank.value; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.riverbank.value IS 'String to describe side of river “left” / ”right” / ”bridge” in downstream direction.';
  
  
  --
  -- Name: user_permissions; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.user_permissions (
      permissionsid integer NOT NULL,
      usersid integer NOT NULL
  );
  
  
  --
  -- Name: TABLE user_permissions; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON TABLE public.user_permissions IS 'Enabled permissions for users';
  
  
  --
  -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.users_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: users; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.users (
      id integer DEFAULT nextval('public.users_id_seq'::regclass) NOT NULL,
      name character varying(255),
      username character varying(255) NOT NULL,
      email character varying(255) NOT NULL,
      password character varying(255),
      loggedin_at timestamp without time zone,
      deleted_at timestamp without time zone
  );
  
  
  --
  -- Name: COLUMN users.name; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.users.name IS 'The name of the adminstration user';
  
  
  --
  -- Name: COLUMN users.username; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.users.username IS 'The username for login';
  
  
  --
  -- Name: COLUMN users.email; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.users.email IS 'E-mail address of admin user';
  
  
  --
  -- Name: COLUMN users.password; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.users.password IS 'Hashed password';
  
  
  --
  -- Name: COLUMN users.loggedin_at; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.users.loggedin_at IS 'Date and time of last login';
  
  
  --
  -- Name: COLUMN users.deleted_at; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON COLUMN public.users.deleted_at IS 'Mark deleted users with this field (soft-delete)';
  
  
  --
  -- Name: users_groups; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.users_groups (
      usersid integer NOT NULL,
      groupsid integer NOT NULL
  );
  
  
  --
  -- Name: TABLE users_groups; Type: COMMENT; Schema: public; Owner: -
  --
  
  COMMENT ON TABLE public.users_groups IS 'Users-groups assignment (many-to-many)';
  
  
  --
  -- Name: warning_level_group_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.warning_level_group_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: warning_level_groups; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.warning_level_groups (
      id integer DEFAULT nextval('public.warning_level_group_id_seq'::regclass) NOT NULL,
      name character varying(255) NOT NULL
  );
  
  
  --
  -- Name: warning_level_hydropoint; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.warning_level_hydropoint (
      mpointid integer NOT NULL,
      observed_propertyid integer NOT NULL,
      warning_levelid integer NOT NULL,
      value numeric(20,10) NOT NULL
  );
  
  
  --
  -- Name: warning_level_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.warning_level_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: warning_levels; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.warning_levels (
      id integer DEFAULT nextval('public.warning_level_id_seq'::regclass) NOT NULL,
      operatorid integer NOT NULL,
      warning_level_groupid integer NOT NULL,
      color character varying(6),
      short_description character varying(512),
      long_description text,
      is_inclusive boolean DEFAULT true NOT NULL
  );
  
  
  --
  -- Name: discharge_measurement_equipment discharge_measurement_equipment_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.discharge_measurement_equipment
      ADD CONSTRAINT discharge_measurement_equipment_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: discharge_measurement discharge_measurement_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.discharge_measurement
      ADD CONSTRAINT discharge_measurement_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: event_logs event_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.event_logs
      ADD CONSTRAINT event_logs_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: group_measurement_access_rules group_measurement_access_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.group_measurement_access_rules
      ADD CONSTRAINT group_measurement_access_rules_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: group_permissions group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.group_permissions
      ADD CONSTRAINT group_permissions_pkey PRIMARY KEY (permissionsid, groupsid);
  
  
  --
  -- Name: groups groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.groups
      ADD CONSTRAINT groups_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: hydro_observed_property hydro_observed_property_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydro_observed_property
      ADD CONSTRAINT hydro_observed_property_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: hydro_result hydro_result_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydro_result
      ADD CONSTRAINT hydro_result_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: hydro_time_series hydro_time_series_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydro_time_series
      ADD CONSTRAINT hydro_time_series_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: hydropoint hydropoint_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydropoint
      ADD CONSTRAINT hydropoint_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: hydrostation_classification hydrostation_classification_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydrostation_classification
      ADD CONSTRAINT hydrostation_classification_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: measurement_access_rules measurement_access_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.measurement_access_rules
      ADD CONSTRAINT measurement_access_rules_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: meteo_observed_property meteo_observed_property_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteo_observed_property
      ADD CONSTRAINT meteo_observed_property_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: meteo_result meteo_result_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteo_result
      ADD CONSTRAINT meteo_result_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: meteo_time_series meteo_time_series_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteo_time_series
      ADD CONSTRAINT meteo_time_series_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: meteopoint meteopoint_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteopoint
      ADD CONSTRAINT meteopoint_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: meteostation_classification meteostation_classification_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteostation_classification
      ADD CONSTRAINT meteostation_classification_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: operator_groups operator_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.operator_groups
      ADD CONSTRAINT operator_groups_pkey PRIMARY KEY (groupsid, operatorid);
  
  
  --
  -- Name: operator operator_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.operator
      ADD CONSTRAINT operator_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: operator_users operator_users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.operator_users
      ADD CONSTRAINT operator_users_pkey PRIMARY KEY (usersid, operatorid);
  
  
  --
  -- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.permissions
      ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: public_keys public_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.public_keys
      ADD CONSTRAINT public_keys_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: river river_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.river
      ADD CONSTRAINT river_pkey PRIMARY KEY (eucd_riv);
  
  
  --
  -- Name: riverbank riverbank_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.riverbank
      ADD CONSTRAINT riverbank_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: user_permissions user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.user_permissions
      ADD CONSTRAINT user_permissions_pkey PRIMARY KEY (permissionsid, usersid);
  
  
  --
  -- Name: users_groups users_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.users_groups
      ADD CONSTRAINT users_groups_pkey PRIMARY KEY (usersid, groupsid);
  
  
  --
  -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.users
      ADD CONSTRAINT users_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: warning_levels warning_level_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.warning_levels
      ADD CONSTRAINT warning_level_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: discharge_measurement_equipment_description_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX discharge_measurement_equipment_description_unique ON public.discharge_measurement_equipment USING btree (description);
  
  
  --
  -- Name: eucd_pst_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX eucd_pst_unique ON public.meteopoint USING btree (eucd_pst);
  
  
  --
  -- Name: eucd_wgst_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX eucd_wgst_unique ON public.hydropoint USING btree (eucd_wgst);
  
  
  --
  -- Name: groups_name_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX groups_name_unique ON public.groups USING btree (name);
  
  
  --
  -- Name: hydro_observed_property_symbol_type_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX hydro_observed_property_symbol_type_unique ON public.hydro_observed_property USING btree (symbol, type);
  
  
  --
  -- Name: hydro_time_series_mpoint_property_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX hydro_time_series_mpoint_property_unique ON public.hydro_time_series USING btree (mpointid, observed_propertyid);
  
  
  --
  -- Name: hydro_unique_time_value; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX hydro_unique_time_value ON public.hydro_result USING btree (time_seriesid, "time", value, is_forecast);
  
  
  --
  -- Name: hydrostation_classification_value_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX hydrostation_classification_value_unique ON public.hydrostation_classification USING btree (value);
  
  
  --
  -- Name: meteo_observed_property_symbol_type_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX meteo_observed_property_symbol_type_unique ON public.meteo_observed_property USING btree (symbol, type);
  
  
  --
  -- Name: meteo_time_series_mpoint_property_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX meteo_time_series_mpoint_property_unique ON public.meteo_time_series USING btree (mpointid, observed_propertyid);
  
  
  --
  -- Name: meteo_unique_time_value; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX meteo_unique_time_value ON public.meteo_result USING btree (time_seriesid, "time", value, is_forecast);
  
  
  --
  -- Name: meteostation_classification_value_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX meteostation_classification_value_unique ON public.meteostation_classification USING btree (value);
  
  
  --
  -- Name: ncd_pst_operator_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX ncd_pst_operator_unique ON public.meteopoint USING btree (ncd_pst, operatorid);
  
  
  --
  -- Name: ncd_wgst_operator_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX ncd_wgst_operator_unique ON public.hydropoint USING btree (ncd_wgst, operatorid);
  
  
  --
  -- Name: operator_name_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX operator_name_unique ON public.operator USING btree (name);
  
  
  --
  -- Name: operatorid_color_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX operatorid_color_unique ON public.warning_levels USING btree (operatorid, color);
  
  
  --
  -- Name: operatorid_short_description_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX operatorid_short_description_unique ON public.warning_levels USING btree (operatorid, short_description);
  
  
  --
  -- Name: permissions_name_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX permissions_name_unique ON public.permissions USING btree (name);
  
  
  --
  -- Name: river_cname_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX river_cname_unique ON public.river USING btree (cname);
  
  
  --
  -- Name: riverbank_value_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX riverbank_value_unique ON public.riverbank USING btree (value);
  
  
  --
  -- Name: users_username_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX users_username_unique ON public.users USING btree (username);
  
  
  --
  -- Name: warning_level_group_pkey; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX warning_level_group_pkey ON public.warning_level_groups USING btree (id);
  
  
  --
  -- Name: discharge_measurement discharge_measurement_discharge_measurement_equipmentid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.discharge_measurement
      ADD CONSTRAINT discharge_measurement_discharge_measurement_equipmentid_fkey FOREIGN KEY (discharge_measurement_equipmentid) REFERENCES public.discharge_measurement_equipment(id);
  
  
  --
  -- Name: discharge_measurement discharge_measurement_mpointid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.discharge_measurement
      ADD CONSTRAINT discharge_measurement_mpointid_fkey FOREIGN KEY (mpointid) REFERENCES public.hydropoint(id);
  
  
  --
  -- Name: discharge_measurement discharge_measurement_operatorid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.discharge_measurement
      ADD CONSTRAINT discharge_measurement_operatorid_fkey FOREIGN KEY (operatorid) REFERENCES public.operator(id);
  
  
  --
  -- Name: event_logs event_logs_operator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.event_logs
      ADD CONSTRAINT event_logs_operator_id_fkey FOREIGN KEY (operator_id) REFERENCES public.operator(id);
  
  
  --
  -- Name: event_logs event_logs_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.event_logs
      ADD CONSTRAINT event_logs_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);
  
  
  --
  -- Name: group_permissions group_permissions_groupsid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.group_permissions
      ADD CONSTRAINT group_permissions_groupsid_fkey FOREIGN KEY (groupsid) REFERENCES public.groups(id);
  
  
  --
  -- Name: group_permissions group_permissions_permissionsid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.group_permissions
      ADD CONSTRAINT group_permissions_permissionsid_fkey FOREIGN KEY (permissionsid) REFERENCES public.permissions(id);
  
  
  --
  -- Name: hydro_result hydro_result_time_seriesid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydro_result
      ADD CONSTRAINT hydro_result_time_seriesid_fkey FOREIGN KEY (time_seriesid) REFERENCES public.hydro_time_series(id);
  
  
  --
  -- Name: hydro_time_series hydro_time_series_mpointid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydro_time_series
      ADD CONSTRAINT hydro_time_series_mpointid_fkey FOREIGN KEY (mpointid) REFERENCES public.hydropoint(id);
  
  
  --
  -- Name: hydro_time_series hydro_time_series_observed_propertyid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydro_time_series
      ADD CONSTRAINT hydro_time_series_observed_propertyid_fkey FOREIGN KEY (observed_propertyid) REFERENCES public.hydro_observed_property(id);
  
  
  --
  -- Name: hydropoint hydropoint_bankid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydropoint
      ADD CONSTRAINT hydropoint_bankid_fkey FOREIGN KEY (bankid) REFERENCES public.riverbank(id);
  
  
  --
  -- Name: hydropoint hydropoint_eucd_riv_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydropoint
      ADD CONSTRAINT hydropoint_eucd_riv_fkey FOREIGN KEY (eucd_riv) REFERENCES public.river(eucd_riv);
  
  
  --
  -- Name: hydropoint_observed_property hydropoint_observed_property_mpointid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydropoint_observed_property
      ADD CONSTRAINT hydropoint_observed_property_mpointid_fkey FOREIGN KEY (mpointid) REFERENCES public.hydropoint(id);
  
  
  --
  -- Name: hydropoint_observed_property hydropoint_observed_property_observed_propertyid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydropoint_observed_property
      ADD CONSTRAINT hydropoint_observed_property_observed_propertyid_fkey FOREIGN KEY (observed_propertyid) REFERENCES public.hydro_observed_property(id);
  
  
  --
  -- Name: hydropoint hydropoint_operatorid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydropoint
      ADD CONSTRAINT hydropoint_operatorid_fkey FOREIGN KEY (operatorid) REFERENCES public.operator(id);
  
  
  --
  -- Name: hydropoint hydropoint_station_classificationid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.hydropoint
      ADD CONSTRAINT hydropoint_station_classificationid_fkey FOREIGN KEY (station_classificationid) REFERENCES public.hydrostation_classification(id);
  
  
  --
  -- Name: meteo_result meteo_result_time_seriesid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteo_result
      ADD CONSTRAINT meteo_result_time_seriesid_fkey FOREIGN KEY (time_seriesid) REFERENCES public.meteo_time_series(id);
  
  
  --
  -- Name: meteo_time_series meteo_time_series_mpointid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteo_time_series
      ADD CONSTRAINT meteo_time_series_mpointid_fkey FOREIGN KEY (mpointid) REFERENCES public.meteopoint(id);
  
  
  --
  -- Name: meteo_time_series meteo_time_series_observed_propertyid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteo_time_series
      ADD CONSTRAINT meteo_time_series_observed_propertyid_fkey FOREIGN KEY (observed_propertyid) REFERENCES public.meteo_observed_property(id);
  
  
  --
  -- Name: meteopoint_observed_property meteopoint_observed_property_mpointid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteopoint_observed_property
      ADD CONSTRAINT meteopoint_observed_property_mpointid_fkey FOREIGN KEY (mpointid) REFERENCES public.meteopoint(id);
  
  
  --
  -- Name: meteopoint_observed_property meteopoint_observed_property_observed_propertyid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteopoint_observed_property
      ADD CONSTRAINT meteopoint_observed_property_observed_propertyid_fkey FOREIGN KEY (observed_propertyid) REFERENCES public.meteo_observed_property(id);
  
  
  --
  -- Name: meteopoint meteopoint_operatorid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteopoint
      ADD CONSTRAINT meteopoint_operatorid_fkey FOREIGN KEY (operatorid) REFERENCES public.operator(id);
  
  
  --
  -- Name: meteopoint meteopoint_station_classificationid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.meteopoint
      ADD CONSTRAINT meteopoint_station_classificationid_fkey FOREIGN KEY (station_classificationid) REFERENCES public.meteostation_classification(id);
  
  
  --
  -- Name: operator_groups operator_groups_groupsid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.operator_groups
      ADD CONSTRAINT operator_groups_groupsid_fkey FOREIGN KEY (groupsid) REFERENCES public.groups(id);
  
  
  --
  -- Name: operator_groups operator_groups_operatorid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.operator_groups
      ADD CONSTRAINT operator_groups_operatorid_fkey FOREIGN KEY (operatorid) REFERENCES public.operator(id);
  
  
  --
  -- Name: operator_users operator_users_operatorid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.operator_users
      ADD CONSTRAINT operator_users_operatorid_fkey FOREIGN KEY (operatorid) REFERENCES public.operator(id);
  
  
  --
  -- Name: operator_users operator_users_usersid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.operator_users
      ADD CONSTRAINT operator_users_usersid_fkey FOREIGN KEY (usersid) REFERENCES public.users(id);
  
  
  --
  -- Name: public_keys public_keys_usersid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.public_keys
      ADD CONSTRAINT public_keys_usersid_fkey FOREIGN KEY (usersid) REFERENCES public.users(id);
  
  
  --
  -- Name: user_permissions user_permissions_permissionsid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.user_permissions
      ADD CONSTRAINT user_permissions_permissionsid_fkey FOREIGN KEY (permissionsid) REFERENCES public.permissions(id);
  
  
  --
  -- Name: user_permissions user_permissions_usersid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.user_permissions
      ADD CONSTRAINT user_permissions_usersid_fkey FOREIGN KEY (usersid) REFERENCES public.users(id);
  
  
  --
  -- Name: users_groups users_groups_groupsid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.users_groups
      ADD CONSTRAINT users_groups_groupsid_fkey FOREIGN KEY (groupsid) REFERENCES public.groups(id);
  
  
  --
  -- Name: users_groups users_groups_usersid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.users_groups
      ADD CONSTRAINT users_groups_usersid_fkey FOREIGN KEY (usersid) REFERENCES public.users(id);
  
  
  --
  -- Name: warning_level_hydropoint warning_level_hydropoint_mpointid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.warning_level_hydropoint
      ADD CONSTRAINT warning_level_hydropoint_mpointid_fkey FOREIGN KEY (mpointid) REFERENCES public.hydropoint(id);
  
  
  --
  -- Name: warning_level_hydropoint warning_level_hydropoint_observed_propertyid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.warning_level_hydropoint
      ADD CONSTRAINT warning_level_hydropoint_observed_propertyid_fkey FOREIGN KEY (observed_propertyid) REFERENCES public.hydro_observed_property(id);
  
  
  --
  -- Name: warning_level_hydropoint warning_level_hydropoint_warning_levelid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.warning_level_hydropoint
      ADD CONSTRAINT warning_level_hydropoint_warning_levelid_fkey FOREIGN KEY (warning_levelid) REFERENCES public.warning_levels(id);
  
  
  --
  -- Name: warning_levels warning_levels_operatorid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.warning_levels
      ADD CONSTRAINT warning_levels_operatorid_fkey FOREIGN KEY (operatorid) REFERENCES public.operator(id);
  
  
  --
  -- Name: warning_levels warning_levels_warning_level_groupid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.warning_levels
      ADD CONSTRAINT warning_levels_warning_level_groupid_fkey FOREIGN KEY (warning_level_groupid) REFERENCES public.warning_level_groups(id);
  
  
  --
  -- PostgreSQL database dump complete
  --
  
  