# HG changeset patch # User Tom Gottfried # Date 1454693523 -3600 # Node ID 6cefa14688328575dc8333a907140d76a1235767 # Parent 66069d69d6ee38963ec3f2230fa2b7069a0cc264 Use inline primary key definitions and remove autogenerated comments. diff -r 66069d69d6ee -r 6cefa1468832 db_schema/stammdaten_schema.sql --- a/db_schema/stammdaten_schema.sql Fri Feb 05 17:03:31 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Fri Feb 05 18:32:03 2016 +0100 @@ -77,30 +77,6 @@ $$; -CREATE TABLE auth ( - id integer NOT NULL, - ldap_group character varying(40) NOT NULL, - netzbetreiber_id character varying(2), - mst_id character varying(5), - labor_mst_id character varying(5), - funktion_id smallint -); - - --- --- Name: auth_funktion; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE auth_funktion ( - id smallint NOT NULL, - funktion character varying(40) -); - - --- --- Name: auth_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE auth_id_seq START WITH 1 INCREMENT BY 1 @@ -108,48 +84,24 @@ NO MAXVALUE CACHE 1; - --- --- Name: auth_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE auth ( + id integer PRIMARY KEY DEFAULT nextval('auth_id_seq'::regclass), + ldap_group character varying(40) NOT NULL, + netzbetreiber_id character varying(2), + mst_id character varying(5), + labor_mst_id character varying(5), + funktion_id smallint +); ALTER SEQUENCE auth_id_seq OWNED BY auth.id; --- --- Name: auth_id_seq1; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - -CREATE SEQUENCE auth_id_seq1 - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: auth_id_seq1; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- - -ALTER SEQUENCE auth_id_seq1 OWNED BY auth.id; - - --- --- Name: auth_lst_umw; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE auth_lst_umw ( - id integer NOT NULL, - lst_id character varying(5), - umw_id character varying(3) +CREATE TABLE auth_funktion ( + id smallint PRIMARY KEY, + funktion character varying(40) ); --- --- Name: auth_lst_umw_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE auth_lst_umw_id_seq START WITH 1 INCREMENT BY 1 @@ -157,29 +109,15 @@ NO MAXVALUE CACHE 1; - --- --- Name: auth_lst_umw_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE auth_lst_umw ( + id integer PRIMARY KEY DEFAULT nextval('auth_lst_umw_id_seq'::regclass), + lst_id character varying(5), + umw_id character varying(3) +); ALTER SEQUENCE auth_lst_umw_id_seq OWNED BY auth_lst_umw.id; --- --- Name: datenbasis; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE datenbasis ( - id integer NOT NULL, - beschreibung character varying(30), - datenbasis character varying(6) -); - - --- --- Name: datenbasis_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE datenbasis_id_seq START WITH 1 INCREMENT BY 1 @@ -187,32 +125,15 @@ NO MAXVALUE CACHE 1; - --- --- Name: datenbasis_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE datenbasis ( + id integer PRIMARY KEY DEFAULT nextval('datenbasis_id_seq'::regclass), + beschreibung character varying(30), + datenbasis character varying(6) +); ALTER SEQUENCE datenbasis_id_seq OWNED BY datenbasis.id; --- --- Name: datensatz_erzeuger; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE datensatz_erzeuger ( - id integer NOT NULL, - netzbetreiber_id character varying(2), - da_erzeuger_id character varying(2), - mst_id character varying(5), - bezeichnung character varying(120), - letzte_aenderung timestamp without time zone -); - - --- --- Name: datensatz_erzeuger_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE datensatz_erzeuger_id_seq START WITH 1 INCREMENT BY 1 @@ -220,20 +141,28 @@ NO MAXVALUE CACHE 1; - --- --- Name: datensatz_erzeuger_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE datensatz_erzeuger ( + id integer PRIMARY KEY + DEFAULT nextval('datensatz_erzeuger_id_seq'::regclass), + netzbetreiber_id character varying(2), + da_erzeuger_id character varying(2), + mst_id character varying(5), + bezeichnung character varying(120), + letzte_aenderung timestamp without time zone +); ALTER SEQUENCE datensatz_erzeuger_id_seq OWNED BY datensatz_erzeuger.id; --- --- Name: de_vg; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- +CREATE SEQUENCE de_vg_id_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; CREATE TABLE de_vg ( - id integer NOT NULL, + id integer PRIMARY KEY DEFAULT nextval('de_vg_id_seq'::regclass), use double precision, rs character varying(12), gf double precision, @@ -252,32 +181,11 @@ geom public.geometry(MultiPolygon,4326) ); - --- --- Name: de_vg_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - -CREATE SEQUENCE de_vg_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: de_vg_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- - ALTER SEQUENCE de_vg_id_seq OWNED BY de_vg.id; --- --- Name: deskriptor_umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE deskriptor_umwelt ( - id integer NOT NULL, + id integer PRIMARY KEY, s00 integer NOT NULL, s01 integer NOT NULL, s02 integer, @@ -295,12 +203,15 @@ ); --- --- Name: deskriptoren; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- +CREATE SEQUENCE deskriptoren_id_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; CREATE TABLE deskriptoren ( - id integer NOT NULL, + id integer PRIMARY KEY DEFAULT nextval('deskriptoren_id_seq'::regclass), vorgaenger integer, ebene smallint, s_xx integer, @@ -309,41 +220,9 @@ bedeutung character varying(300) ); - --- --- Name: deskriptoren_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - -CREATE SEQUENCE deskriptoren_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: deskriptoren_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- - ALTER SEQUENCE deskriptoren_id_seq OWNED BY deskriptoren.id; --- --- Name: favorite; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE favorite ( - id integer NOT NULL, - user_id integer NOT NULL, - query_id integer NOT NULL -); - - --- --- Name: favorite_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE favorite_id_seq START WITH 1 INCREMENT BY 1 @@ -351,32 +230,15 @@ NO MAXVALUE CACHE 1; - --- --- Name: favorite_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE favorite ( + id integer PRIMARY KEY DEFAULT nextval('favorite_id_seq'::regclass), + user_id integer NOT NULL, + query_id integer NOT NULL +); ALTER SEQUENCE favorite_id_seq OWNED BY favorite.id; --- --- Name: filter; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE filter ( - id integer NOT NULL, - query_id integer NOT NULL, - data_index character varying(50) NOT NULL, - type character varying(10) NOT NULL, - label character varying(50) NOT NULL, - multiselect boolean -); - - --- --- Name: filter_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE filter_id_seq START WITH 1 INCREMENT BY 1 @@ -384,31 +246,18 @@ NO MAXVALUE CACHE 1; - --- --- Name: filter_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE filter ( + id integer PRIMARY KEY DEFAULT nextval('filter_id_seq'::regclass), + query_id integer NOT NULL, + data_index character varying(50) NOT NULL, + type character varying(10) NOT NULL, + label character varying(50) NOT NULL, + multiselect boolean +); ALTER SEQUENCE filter_id_seq OWNED BY filter.id; --- --- Name: filter_value; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE filter_value ( - id integer NOT NULL, - query_id integer NOT NULL, - user_id integer NOT NULL, - filter_id integer NOT NULL, - value text -); - - --- --- Name: filter_value_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE filter_value_id_seq START WITH 1 INCREMENT BY 1 @@ -416,29 +265,17 @@ NO MAXVALUE CACHE 1; - --- --- Name: filter_value_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE filter_value ( + id integer PRIMARY KEY DEFAULT nextval('filter_value_id_seq'::regclass), + query_id integer NOT NULL, + user_id integer NOT NULL, + filter_id integer NOT NULL, + value text +); ALTER SEQUENCE filter_value_id_seq OWNED BY filter_value.id; --- --- Name: koordinaten_art; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE koordinaten_art ( - id integer NOT NULL, - koordinatenart character varying(50), - idf_geo_key character varying(1) -); - - --- --- Name: koordinaten_art_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE koordinaten_art_id_seq START WITH 1 INCREMENT BY 1 @@ -446,28 +283,15 @@ NO MAXVALUE CACHE 1; - --- --- Name: koordinaten_art_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE koordinaten_art ( + id integer PRIMARY KEY DEFAULT nextval('koordinaten_art_id_seq'::regclass), + koordinatenart character varying(50), + idf_geo_key character varying(1) +); ALTER SEQUENCE koordinaten_art_id_seq OWNED BY koordinaten_art.id; --- --- Name: lada_user; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE lada_user ( - id integer NOT NULL, - name character varying(80) NOT NULL -); - - --- --- Name: lada_user_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE lada_user_id_seq START WITH 1 INCREMENT BY 1 @@ -475,31 +299,14 @@ NO MAXVALUE CACHE 1; - --- --- Name: lada_user_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE lada_user ( + id integer PRIMARY KEY DEFAULT nextval('lada_user_id_seq'::regclass), + name character varying(80) NOT NULL +); ALTER SEQUENCE lada_user_id_seq OWNED BY lada_user.id; --- --- Name: mess_einheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE mess_einheit ( - id integer NOT NULL, - beschreibung character varying(50), - einheit character varying(12), - eudf_messeinheit_id character varying(8), - umrechnungs_faktor_eudf bigint -); - - --- --- Name: mess_einheit_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE mess_einheit_id_seq START WITH 1 INCREMENT BY 1 @@ -507,31 +314,26 @@ NO MAXVALUE CACHE 1; - --- --- Name: mess_einheit_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE mess_einheit ( + id integer PRIMARY KEY DEFAULT nextval('mess_einheit_id_seq'::regclass), + beschreibung character varying(50), + einheit character varying(12), + eudf_messeinheit_id character varying(8), + umrechnungs_faktor_eudf bigint +); ALTER SEQUENCE mess_einheit_id_seq OWNED BY mess_einheit.id; --- --- Name: mess_methode; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE mess_methode ( - id character varying(2) NOT NULL, + id character varying(2) PRIMARY KEY, beschreibung character varying(300), messmethode character varying(50) ); --- --- Name: mess_stelle; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE mess_stelle ( - id character varying(5) NOT NULL, + id character varying(5) PRIMARY KEY, netzbetreiber_id character varying(2), beschreibung character varying(300), mess_stelle character varying(60), @@ -540,12 +342,16 @@ ); --- --- Name: messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- + +CREATE SEQUENCE messgroesse_id_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; CREATE TABLE messgroesse ( - id integer NOT NULL, + id integer PRIMARY KEY DEFAULT nextval('messgroesse_id_seq'::regclass), beschreibung character varying(300), messgroesse character varying(50) NOT NULL, default_farbe character varying(9), @@ -555,41 +361,9 @@ kennung_bvl character varying(7) ); - --- --- Name: messgroesse_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - -CREATE SEQUENCE messgroesse_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: messgroesse_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- - ALTER SEQUENCE messgroesse_id_seq OWNED BY messgroesse.id; --- --- Name: messgroessen_gruppe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE messgroessen_gruppe ( - id integer NOT NULL, - bezeichnung character varying(80), - ist_leitnuklidgruppe character(1) DEFAULT NULL::bpchar -); - - --- --- Name: messgroessen_gruppe_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE messgroessen_gruppe_id_seq START WITH 1 INCREMENT BY 1 @@ -597,31 +371,16 @@ NO MAXVALUE CACHE 1; - --- --- Name: messgroessen_gruppe_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE messgroessen_gruppe ( + id integer PRIMARY KEY + DEFAULT nextval('messgroessen_gruppe_id_seq'::regclass), + bezeichnung character varying(80), + ist_leitnuklidgruppe character(1) DEFAULT NULL::bpchar +); ALTER SEQUENCE messgroessen_gruppe_id_seq OWNED BY messgroessen_gruppe.id; --- --- Name: messprogramm_kategorie; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE messprogramm_kategorie ( - id integer NOT NULL, - netzbetreiber_id character varying(2), - mpl_id character varying(3), - bezeichnung character varying(120), - letzte_aenderung timestamp without time zone -); - - --- --- Name: messprogramm_kategorie_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE messprogramm_kategorie_id_seq START WITH 1 INCREMENT BY 1 @@ -629,17 +388,18 @@ NO MAXVALUE CACHE 1; - --- --- Name: messprogramm_kategorie_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE messprogramm_kategorie ( + id integer PRIMARY KEY + DEFAULT nextval('messprogramm_kategorie_id_seq'::regclass), + netzbetreiber_id character varying(2), + mpl_id character varying(3), + bezeichnung character varying(120), + letzte_aenderung timestamp without time zone +); -ALTER SEQUENCE messprogramm_kategorie_id_seq OWNED BY messprogramm_kategorie.id; - +ALTER SEQUENCE messprogramm_kategorie_id_seq + OWNED BY messprogramm_kategorie.id; --- --- Name: mg_grp; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- CREATE TABLE mg_grp ( messgroessengruppe_id integer NOT NULL, @@ -647,20 +407,12 @@ ); --- --- Name: mmt_messgroesse_grp; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE mmt_messgroesse_grp ( messgroessengruppe_id integer NOT NULL, mmt_id character varying(2) NOT NULL ); --- --- Name: mmt_messgroesse; Type: VIEW; Schema: stammdaten; Owner: - --- - CREATE VIEW mmt_messgroesse AS SELECT mmt_messgroesse_grp.mmt_id, mg_grp.messgroesse_id @@ -669,12 +421,8 @@ WHERE (mg_grp.messgroessengruppe_id = mmt_messgroesse_grp.messgroessengruppe_id); --- --- Name: netz_betreiber; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE netz_betreiber ( - id character varying(2) NOT NULL, + id character varying(2) PRIMARY KEY, netzbetreiber character varying(50), idf_netzbetreiber character varying(1), is_bmn boolean DEFAULT false, @@ -684,12 +432,15 @@ ); --- --- Name: ort; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- +CREATE SEQUENCE ort_id_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; CREATE TABLE ort ( - id integer NOT NULL, + id integer PRIMARY KEY DEFAULT nextval('ort_id_seq'::regclass), netzbetreiber_id character varying(2), ort_id character varying(10), langtext character varying(100), @@ -718,63 +469,21 @@ oz_id integer ); - --- --- Name: ort_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - -CREATE SEQUENCE ort_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: ort_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- - ALTER SEQUENCE ort_id_seq OWNED BY ort.id; --- --- Name: ort_typ; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE ort_typ ( - id smallint NOT NULL, + id smallint PRIMARY KEY, ort_typ character varying(60) ); --- --- Name: ortszuordnung_typ; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE ortszuordnung_typ ( - id character(1) NOT NULL, + id character(1) PRIMARY KEY, ortstyp character varying(60) ); --- --- Name: pflicht_messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE pflicht_messgroesse ( - id integer NOT NULL, - messgroesse_id integer, - mmt_id character varying(2), - umw_id character varying(3), - datenbasis_id smallint NOT NULL -); - - --- --- Name: pflicht_messgroesse_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE pflicht_messgroesse_id_seq START WITH 1 INCREMENT BY 1 @@ -782,20 +491,20 @@ NO MAXVALUE CACHE 1; - --- --- Name: pflicht_messgroesse_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE pflicht_messgroesse ( + id integer PRIMARY KEY + DEFAULT nextval('pflicht_messgroesse_id_seq'::regclass), + messgroesse_id integer, + mmt_id character varying(2), + umw_id character varying(3), + datenbasis_id smallint NOT NULL +); ALTER SEQUENCE pflicht_messgroesse_id_seq OWNED BY pflicht_messgroesse.id; --- --- Name: proben_zusatz; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE proben_zusatz ( - id character varying(3) NOT NULL, + id character varying(3) PRIMARY KEY, meh_id integer, beschreibung character varying(50) NOT NULL, zusatzwert character varying(7) NOT NULL, @@ -803,22 +512,6 @@ ); --- --- Name: probenart; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE probenart ( - id integer NOT NULL, - beschreibung character varying(30), - probenart character varying(5) NOT NULL, - probenart_eudf_id character varying(1) NOT NULL -); - - --- --- Name: probenart_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE probenart_id_seq START WITH 1 INCREMENT BY 1 @@ -826,20 +519,25 @@ NO MAXVALUE CACHE 1; - --- --- Name: probenart_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE probenart ( + id integer PRIMARY KEY DEFAULT nextval('probenart_id_seq'::regclass), + beschreibung character varying(30), + probenart character varying(5) NOT NULL, + probenart_eudf_id character varying(1) NOT NULL +); ALTER SEQUENCE probenart_id_seq OWNED BY probenart.id; --- --- Name: probenehmer; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- +CREATE SEQUENCE probenehmer_id_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; CREATE TABLE probenehmer ( - id integer NOT NULL, + id integer PRIMARY KEY DEFAULT nextval('probenehmer_id_seq'::regclass), netzbetreiber_id character varying(2), prn_id character varying(9), bearbeiter character varying(25), @@ -856,43 +554,9 @@ letzte_aenderung timestamp without time zone ); - --- --- Name: probenehmer_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - -CREATE SEQUENCE probenehmer_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: probenehmer_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- - ALTER SEQUENCE probenehmer_id_seq OWNED BY probenehmer.id; --- --- Name: query; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - -CREATE TABLE query ( - id integer NOT NULL, - name character varying(80) NOT NULL, - type character varying(30) NOT NULL, - sql character varying(1500) NOT NULL, - description character varying(100) -); - - --- --- Name: query_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - CREATE SEQUENCE query_id_seq START WITH 1 INCREMENT BY 1 @@ -900,20 +564,26 @@ NO MAXVALUE CACHE 1; - --- --- Name: query_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- +CREATE TABLE query ( + id integer PRIMARY KEY DEFAULT nextval('query_id_seq'::regclass), + name character varying(80) NOT NULL, + type character varying(30) NOT NULL, + sql character varying(1500) NOT NULL, + description character varying(100) +); ALTER SEQUENCE query_id_seq OWNED BY query.id; --- --- Name: result; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- +CREATE SEQUENCE result_id_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; CREATE TABLE result ( - id integer NOT NULL, + id integer PRIMARY KEY DEFAULT nextval('result_id_seq'::regclass), query_id integer NOT NULL, data_index character varying(50) NOT NULL, header character varying(50) NOT NULL, @@ -922,29 +592,9 @@ index integer ); - --- --- Name: result_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - -CREATE SEQUENCE result_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: result_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- - ALTER SEQUENCE result_id_seq OWNED BY result.id; --- --- Name: s_00_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_00_view AS SELECT deskriptoren.s_xx AS s00, @@ -955,9 +605,6 @@ WHERE (deskriptoren.ebene = 0); --- --- Name: s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_01_view AS SELECT d1.s_xx AS s01, @@ -970,9 +617,6 @@ WHERE (d1.ebene = 1); --- --- Name: s_02_s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_02_s_01_view AS SELECT d1.s_xx AS s01, @@ -982,9 +626,6 @@ WHERE (d2.ebene = 2); --- --- Name: s_02_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_02_view AS SELECT DISTINCT deskriptoren.s_xx AS s00, @@ -995,9 +636,6 @@ WHERE (deskriptoren.ebene = 2); --- --- Name: s_03_s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_03_s_01_view AS SELECT d1.s_xx AS s01, @@ -1007,9 +645,6 @@ WHERE ((d2.ebene = 3) AND (d1.ebene = 1)); --- --- Name: s_03_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_03_view AS SELECT d1.s_xx AS s03, @@ -1031,9 +666,6 @@ WHERE ((d1.ebene = 3) AND (d2.ebene = 1)); --- --- Name: s_04_s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_04_s_01_view AS SELECT DISTINCT d1.s_xx AS s01, @@ -1043,9 +675,6 @@ WHERE (d2.ebene = 4); --- --- Name: s_04_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_04_view AS SELECT DISTINCT deskriptoren.s_xx AS s04, @@ -1056,9 +685,6 @@ WHERE (deskriptoren.ebene = 4); --- --- Name: s_05_s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_05_s_01_view AS SELECT d1.s_xx AS s01, @@ -1068,9 +694,6 @@ WHERE (d2.ebene = 5); --- --- Name: s_05_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_05_view AS SELECT DISTINCT deskriptoren.s_xx AS s05, @@ -1081,9 +704,6 @@ WHERE (deskriptoren.ebene = 5); --- --- Name: s_06_s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_06_s_01_view AS SELECT d1.s_xx AS s01, @@ -1093,9 +713,6 @@ WHERE (d2.ebene = 6); --- --- Name: s_06_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_06_view AS SELECT DISTINCT deskriptoren.s_xx AS s06, @@ -1106,9 +723,6 @@ WHERE (deskriptoren.ebene = 6); --- --- Name: s_07_s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_07_s_01_view AS SELECT d1.s_xx AS s01, @@ -1118,9 +732,6 @@ WHERE (d2.ebene = 7); --- --- Name: s_07_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_07_view AS SELECT DISTINCT deskriptoren.s_xx AS s07, @@ -1131,9 +742,6 @@ WHERE (deskriptoren.ebene = 7); --- --- Name: s_08_s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_08_s_01_view AS SELECT d1.s_xx AS s01, @@ -1143,9 +751,6 @@ WHERE (d2.ebene = 8); --- --- Name: s_08_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_08_view AS SELECT DISTINCT deskriptoren.s_xx AS s08, @@ -1156,9 +761,6 @@ WHERE (deskriptoren.ebene = 8); --- --- Name: s_09_s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_09_s_01_view AS SELECT d1.s_xx AS s01, @@ -1168,9 +770,6 @@ WHERE (d2.ebene = 9); --- --- Name: s_09_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_09_view AS SELECT DISTINCT deskriptoren.s_xx AS s09, @@ -1181,9 +780,6 @@ WHERE (deskriptoren.ebene = 9); --- --- Name: s_10_s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_10_s_01_view AS SELECT d1.s_xx AS s01, @@ -1193,9 +789,6 @@ WHERE (d2.ebene = 10); --- --- Name: s_10_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_10_view AS SELECT DISTINCT deskriptoren.s_xx AS s10, @@ -1206,9 +799,6 @@ WHERE (deskriptoren.ebene = 10); --- --- Name: s_11_s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_11_s_01_view AS SELECT d1.s_xx AS s01, @@ -1218,9 +808,6 @@ WHERE (d2.ebene = 11); --- --- Name: s_11_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_11_view AS SELECT DISTINCT deskriptoren.s_xx AS s11, @@ -1231,9 +818,6 @@ WHERE (deskriptoren.ebene = 11); --- --- Name: s_12_s_01_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_12_s_01_view AS SELECT d1.s_xx AS s01, @@ -1243,9 +827,6 @@ WHERE (d2.ebene = 12); --- --- Name: s_12_view; Type: VIEW; Schema: stammdaten; Owner: - --- CREATE VIEW s_12_view AS SELECT DISTINCT deskriptoren.s_xx AS s12, @@ -1256,12 +837,16 @@ WHERE (deskriptoren.ebene = 12); --- --- Name: staat; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- + +CREATE SEQUENCE staat_id_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; CREATE TABLE staat ( - id integer NOT NULL, + id integer PRIMARY KEY DEFAULT nextval('staat_id_seq'::regclass), staat character varying(50) NOT NULL, hkl_id smallint NOT NULL, staat_iso character varying(2) NOT NULL, @@ -1272,86 +857,42 @@ kda_id integer ); - --- --- Name: staat_id_seq; Type: SEQUENCE; Schema: stammdaten; Owner: - --- - -CREATE SEQUENCE staat_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - --- --- Name: staat_id_seq; Type: SEQUENCE OWNED BY; Schema: stammdaten; Owner: - --- - ALTER SEQUENCE staat_id_seq OWNED BY staat.id; --- --- Name: status_kombi; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE status_kombi ( - id integer NOT NULL, + id integer PRIMARY KEY, stufe_id integer, wert_id integer ); - --- --- Name: status_reihenfolge; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE status_reihenfolge ( - id integer NOT NULL, + id integer PRIMARY KEY, von_id integer, zu_id integer ); - --- --- Name: status_stufe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE status_stufe ( - id integer NOT NULL, + id integer PRIMARY KEY, stufe character varying(50) ); - --- --- Name: status_wert; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE status_wert ( - id integer NOT NULL, + id integer PRIMARY KEY, wert character varying(50) ); --- --- Name: umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE umwelt ( - id character varying(3) NOT NULL, + id character varying(3) PRIMARY KEY, beschreibung character varying(300), umwelt_bereich character varying(80) NOT NULL, meh_id integer ); --- --- Name: verwaltungseinheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE TABLE verwaltungseinheit ( - id character varying(8) NOT NULL, + id character varying(8) PRIMARY KEY, bundesland character varying(8) NOT NULL, kda_id integer, kreis character varying(8), @@ -1369,9 +910,7 @@ latitude double precision ); --- --- Name status_erreichbar; Type: VIEW; Schema: stammdaten; Owner: -; --- + CREATE VIEW status_erreichbar AS ( SELECT DISTINCT k.wert_id, j.wert_id AS cur_wert, @@ -1387,778 +926,208 @@ ); --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY auth ALTER COLUMN id SET DEFAULT nextval('auth_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY datenbasis ALTER COLUMN id SET DEFAULT nextval('datenbasis_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY datensatz_erzeuger ALTER COLUMN id SET DEFAULT nextval('datensatz_erzeuger_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY de_vg ALTER COLUMN id SET DEFAULT nextval('de_vg_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY deskriptoren ALTER COLUMN id SET DEFAULT nextval('deskriptoren_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY favorite ALTER COLUMN id SET DEFAULT nextval('favorite_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY filter ALTER COLUMN id SET DEFAULT nextval('filter_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY filter_value ALTER COLUMN id SET DEFAULT nextval('filter_value_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY koordinaten_art ALTER COLUMN id SET DEFAULT nextval('koordinaten_art_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY lada_user ALTER COLUMN id SET DEFAULT nextval('lada_user_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY mess_einheit ALTER COLUMN id SET DEFAULT nextval('mess_einheit_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY messgroesse ALTER COLUMN id SET DEFAULT nextval('messgroesse_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY messgroessen_gruppe ALTER COLUMN id SET DEFAULT nextval('messgroessen_gruppe_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY messprogramm_kategorie ALTER COLUMN id SET DEFAULT nextval('messprogramm_kategorie_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY ort ALTER COLUMN id SET DEFAULT nextval('ort_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY pflicht_messgroesse ALTER COLUMN id SET DEFAULT nextval('pflicht_messgroesse_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY probenart ALTER COLUMN id SET DEFAULT nextval('probenart_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY probenehmer ALTER COLUMN id SET DEFAULT nextval('probenehmer_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY query ALTER COLUMN id SET DEFAULT nextval('query_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY result ALTER COLUMN id SET DEFAULT nextval('result_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: stammdaten; Owner: - --- - -ALTER TABLE ONLY staat ALTER COLUMN id SET DEFAULT nextval('staat_id_seq'::regclass); - - --- --- Name: auth_lst_umw_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY auth_lst_umw - ADD CONSTRAINT auth_lst_umw_pkey PRIMARY KEY (id); - - --- --- Name: auth_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY auth - ADD CONSTRAINT auth_pkey PRIMARY KEY (id); - - --- --- Name: auth_role_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY auth_funktion - ADD CONSTRAINT auth_role_pkey PRIMARY KEY (id); - - --- --- Name: datenbasis_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY datenbasis - ADD CONSTRAINT datenbasis_pkey PRIMARY KEY (id); - - --- --- Name: datensatz_erzeuger_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY datensatz_erzeuger - ADD CONSTRAINT datensatz_erzeuger_pkey PRIMARY KEY (id); - - --- --- Name: de_vg_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY de_vg - ADD CONSTRAINT de_vg_pkey PRIMARY KEY (id); - - --- --- Name: deskriptor_umwelt_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY deskriptor_umwelt - ADD CONSTRAINT deskriptor_umwelt_pkey PRIMARY KEY (id); - - --- --- Name: favorite_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY favorite - ADD CONSTRAINT favorite_pkey PRIMARY KEY (id); - - --- --- Name: filter_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY filter - ADD CONSTRAINT filter_pkey PRIMARY KEY (id); - - --- --- Name: filter_value_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY filter_value - ADD CONSTRAINT filter_value_pkey PRIMARY KEY (id); - - --- --- Name: koordinaten_art_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY koordinaten_art - ADD CONSTRAINT koordinaten_art_pkey PRIMARY KEY (id); - - --- --- Name: lada_user_name_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- ALTER TABLE ONLY lada_user ADD CONSTRAINT lada_user_name_key UNIQUE (name); --- --- Name: lada_user_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY lada_user - ADD CONSTRAINT lada_user_pkey PRIMARY KEY (id); - - --- --- Name: mess_einheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY mess_einheit - ADD CONSTRAINT mess_einheit_pkey PRIMARY KEY (id); - - --- --- Name: mess_methode_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY mess_methode - ADD CONSTRAINT mess_methode_pkey PRIMARY KEY (id); - - --- --- Name: mess_stelle_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY mess_stelle - ADD CONSTRAINT mess_stelle_pkey PRIMARY KEY (id); - - --- --- Name: messgroesse_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY messgroesse - ADD CONSTRAINT messgroesse_pkey PRIMARY KEY (id); - - --- --- Name: messgroessen_gruppe_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY messgroessen_gruppe - ADD CONSTRAINT messgroessen_gruppe_pkey PRIMARY KEY (id); - - --- --- Name: messprogramm_kategorie_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY messprogramm_kategorie - ADD CONSTRAINT messprogramm_kategorie_pkey PRIMARY KEY (id); - - --- --- Name: mg_grp_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - ALTER TABLE ONLY mg_grp ADD CONSTRAINT mg_grp_pkey PRIMARY KEY (messgroessengruppe_id, messgroesse_id); --- --- Name: mmt_messgroesse_grp_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - ALTER TABLE ONLY mmt_messgroesse_grp ADD CONSTRAINT mmt_messgroesse_grp_pkey PRIMARY KEY (messgroessengruppe_id, mmt_id); --- --- Name: netz_betreiber_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY netz_betreiber - ADD CONSTRAINT netz_betreiber_pkey PRIMARY KEY (id); - - --- --- Name: ort_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY ort - ADD CONSTRAINT ort_pkey PRIMARY KEY (id); - - --- --- Name: ort_typ_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY ort_typ - ADD CONSTRAINT ort_typ_pkey PRIMARY KEY (id); - - --- --- Name: ortszuordnung_typ_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY ortszuordnung_typ - ADD CONSTRAINT ortszuordnung_typ_pkey PRIMARY KEY (id); - - --- --- Name: pflicht_messgroesse_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY pflicht_messgroesse - ADD CONSTRAINT pflicht_messgroesse_pkey PRIMARY KEY (id); - - --- --- Name: pk_deskriptoren; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY deskriptoren - ADD CONSTRAINT pk_deskriptoren PRIMARY KEY (id); - - --- --- Name: proben_zusatz_eudf_keyword_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - ALTER TABLE ONLY proben_zusatz ADD CONSTRAINT proben_zusatz_eudf_keyword_key UNIQUE (eudf_keyword); --- --- Name: proben_zusatz_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY proben_zusatz - ADD CONSTRAINT proben_zusatz_pkey PRIMARY KEY (id); - - --- --- Name: probenart_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY probenart - ADD CONSTRAINT probenart_pkey PRIMARY KEY (id); - - --- --- Name: probenehmer_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY probenehmer - ADD CONSTRAINT probenehmer_pkey PRIMARY KEY (id); - - --- --- Name: query_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY query - ADD CONSTRAINT query_pkey PRIMARY KEY (id); - - --- --- Name: result_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY result - ADD CONSTRAINT result_pkey PRIMARY KEY (id); - - --- --- Name: staat_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY staat - ADD CONSTRAINT staat_pkey PRIMARY KEY (id); - - --- --- Name: status_kombi_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY status_kombi - ADD CONSTRAINT status_kombi_pkey PRIMARY KEY (id); - - --- --- Name: status_reihenfolge_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY status_reihenfolge - ADD CONSTRAINT status_reihenfolge_pkey PRIMARY KEY (id); - - --- --- Name: status_stufe_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY status_stufe - ADD CONSTRAINT status_stufe_pkey PRIMARY KEY (id); - - --- --- Name: status_wert_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY status_wert - ADD CONSTRAINT status_wert_pkey PRIMARY KEY (id); - - --- --- Name: umwelt_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY umwelt - ADD CONSTRAINT umwelt_pkey PRIMARY KEY (id); - - --- --- Name: umwelt_umwelt_bereich_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - ALTER TABLE ONLY umwelt ADD CONSTRAINT umwelt_umwelt_bereich_key UNIQUE (umwelt_bereich); --- --- Name: verwaltungseinheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: --- - -ALTER TABLE ONLY verwaltungseinheit - ADD CONSTRAINT verwaltungseinheit_pkey PRIMARY KEY (id); - - --- --- Name: de_vg_geom_gist; Type: INDEX; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE INDEX de_vg_geom_gist ON de_vg USING gist (geom); --- --- Name: fts_stauts_kooin10001; Type: INDEX; Schema: stammdaten; Owner: -; Tablespace: --- - CREATE INDEX fts_stauts_kooin10001 ON staat USING btree (kda_id); --- --- Name: auth_funktion_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY auth ADD CONSTRAINT auth_funktion_fkey FOREIGN KEY (funktion_id) REFERENCES auth_funktion(id); --- --- Name: auth_labor_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY auth ADD CONSTRAINT auth_labor_fkey FOREIGN KEY (labor_mst_id) REFERENCES mess_stelle(id); --- --- Name: auth_lst_umw_lst_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY auth_lst_umw ADD CONSTRAINT auth_lst_umw_lst_fkey FOREIGN KEY (lst_id) REFERENCES mess_stelle(id); --- --- Name: auth_lst_umw_umw_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY auth_lst_umw ADD CONSTRAINT auth_lst_umw_umw_fkey FOREIGN KEY (umw_id) REFERENCES umwelt(id); --- --- Name: auth_mst_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY auth ADD CONSTRAINT auth_mst_id_fkey FOREIGN KEY (mst_id) REFERENCES mess_stelle(id); --- --- Name: auth_netzbetreiber_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY auth ADD CONSTRAINT auth_netzbetreiber_id_fkey FOREIGN KEY (netzbetreiber_id) REFERENCES netz_betreiber(id); --- --- Name: datensatz_erzeuger_mst_id_fkey1; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY datensatz_erzeuger ADD CONSTRAINT datensatz_erzeuger_mst_id_fkey1 FOREIGN KEY (mst_id) REFERENCES mess_stelle(id); --- --- Name: datensatz_erzeuger_netzbetreiber_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY datensatz_erzeuger ADD CONSTRAINT datensatz_erzeuger_netzbetreiber_id_fkey FOREIGN KEY (netzbetreiber_id) REFERENCES netz_betreiber(id); --- --- Name: favorite_query_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY favorite ADD CONSTRAINT favorite_query_id_fkey FOREIGN KEY (query_id) REFERENCES query(id); --- --- Name: favorite_user_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY favorite ADD CONSTRAINT favorite_user_id_fkey FOREIGN KEY (user_id) REFERENCES lada_user(id); --- --- Name: filter_query_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY filter ADD CONSTRAINT filter_query_id_fkey FOREIGN KEY (query_id) REFERENCES query(id); --- --- Name: filter_value_filter_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY filter_value ADD CONSTRAINT filter_value_filter_id_fkey FOREIGN KEY (filter_id) REFERENCES filter(id); --- --- Name: filter_value_query_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY filter_value ADD CONSTRAINT filter_value_query_id_fkey FOREIGN KEY (query_id) REFERENCES query(id); --- --- Name: filter_value_user_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY filter_value ADD CONSTRAINT filter_value_user_id_fkey FOREIGN KEY (user_id) REFERENCES lada_user(id); --- --- Name: fk_deskriptoren_vorgaenger; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY deskriptoren ADD CONSTRAINT fk_deskriptoren_vorgaenger FOREIGN KEY (vorgaenger) REFERENCES deskriptoren(id); --- --- Name: messprogramm_kategorie_netzbetreiber_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY messprogramm_kategorie ADD CONSTRAINT messprogramm_kategorie_netzbetreiber_id_fkey FOREIGN KEY (netzbetreiber_id) REFERENCES netz_betreiber(id); --- --- Name: ort_anlage_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY ort ADD CONSTRAINT ort_anlage_fkey FOREIGN KEY (anlage_id) REFERENCES ort(id); --- --- Name: ort_gem_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY ort ADD CONSTRAINT ort_gem_id_fkey FOREIGN KEY (gem_id) REFERENCES verwaltungseinheit(id); --- --- Name: ort_kda_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY ort ADD CONSTRAINT ort_kda_id_fkey FOREIGN KEY (kda_id) REFERENCES koordinaten_art(id); --- --- Name: ort_netzbetreiber_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY ort ADD CONSTRAINT ort_netzbetreiber_id_fkey FOREIGN KEY (netzbetreiber_id) REFERENCES netz_betreiber(id); --- --- Name: ort_ort_typ_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY ort ADD CONSTRAINT ort_ort_typ_fkey FOREIGN KEY (ort_typ) REFERENCES ort_typ(id); --- --- Name: ort_oz_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY ort ADD CONSTRAINT ort_oz_fkey FOREIGN KEY (oz_id) REFERENCES ort(id); --- --- Name: ort_staat_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY ort ADD CONSTRAINT ort_staat_id_fkey FOREIGN KEY (staat_id) REFERENCES staat(id); --- --- Name: pflicht_messgroesse_datenbasis_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY pflicht_messgroesse ADD CONSTRAINT pflicht_messgroesse_datenbasis_id_fkey FOREIGN KEY (datenbasis_id) REFERENCES datenbasis(id); --- --- Name: pflicht_messgroesse_mmt_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY pflicht_messgroesse ADD CONSTRAINT pflicht_messgroesse_mmt_id_fkey FOREIGN KEY (mmt_id) REFERENCES mess_methode(id); --- --- Name: pflicht_messgroesse_umw_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY pflicht_messgroesse ADD CONSTRAINT pflicht_messgroesse_umw_id_fkey FOREIGN KEY (umw_id) REFERENCES umwelt(id); --- --- Name: proben_zusatz_meh_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY proben_zusatz ADD CONSTRAINT proben_zusatz_meh_id_fkey FOREIGN KEY (meh_id) REFERENCES mess_einheit(id); --- --- Name: probenehmer_netzbetreiber_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY probenehmer ADD CONSTRAINT probenehmer_netzbetreiber_id_fkey FOREIGN KEY (netzbetreiber_id) REFERENCES netz_betreiber(id); --- --- Name: result_query_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY result ADD CONSTRAINT result_query_id_fkey FOREIGN KEY (query_id) REFERENCES query(id); --- --- Name: staat_kda_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY staat ADD CONSTRAINT staat_kda_id_fkey FOREIGN KEY (kda_id) REFERENCES koordinaten_art(id); --- --- Name: status_kombi_stufe_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY status_kombi ADD CONSTRAINT status_kombi_stufe_id_fkey FOREIGN KEY (stufe_id) REFERENCES status_stufe(id); --- --- Name: status_kombi_wert_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY status_kombi ADD CONSTRAINT status_kombi_wert_id_fkey FOREIGN KEY (wert_id) REFERENCES status_wert(id); --- --- Name: status_reihenfolge_von_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY status_reihenfolge ADD CONSTRAINT status_reihenfolge_von_id_fkey FOREIGN KEY (von_id) REFERENCES status_kombi(id); --- --- Name: status_reihenfolge_zu_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY status_reihenfolge ADD CONSTRAINT status_reihenfolge_zu_id_fkey FOREIGN KEY (zu_id) REFERENCES status_kombi(id); --- --- Name: umwelt_meh_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY umwelt ADD CONSTRAINT umwelt_meh_id_fkey FOREIGN KEY (meh_id) REFERENCES mess_einheit(id); --- --- Name: verwaltungseinheit_kda_id_fkey; Type: FK CONSTRAINT; Schema: stammdaten; Owner: - --- ALTER TABLE ONLY verwaltungseinheit ADD CONSTRAINT verwaltungseinheit_kda_id_fkey FOREIGN KEY (kda_id) REFERENCES koordinaten_art(id);