diff db_schema/lada_schema.sql @ 1005:e9116ec4eb40 schema-update

Moved comments to the end of the file.
author Raimund Renkert <raimund.renkert@intevation.de>
date Fri, 01 Jul 2016 19:53:56 +0200
parents c0ff3965c266
children 599bd9462e62
line wrap: on
line diff
--- a/db_schema/lada_schema.sql	Fri Jul 01 19:51:41 2016 +0200
+++ b/db_schema/lada_schema.sql	Fri Jul 01 19:53:56 2016 +0200
@@ -142,13 +142,6 @@
 
 
 --
--- Name: COLUMN messprogramm.media_desk; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN messprogramm.media_desk IS 'dekodierte Medienbezeichnung (aus media_desk abgeleitet)';
-
-
---
 -- Name: messprogramm_mmt; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
@@ -250,83 +243,6 @@
 
 
 --
--- Name: COLUMN ortszuordnung.ortszuordnung_typ; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN ortszuordnung.ortszuordnung_typ IS 'E = Entnahmeport, U = Ursprungsort, Z = Ortszusatz';
-
-
---
--- Name: COLUMN probe.id; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN probe.id IS 'interner Probenschlüssel';
-
-
---
--- Name: COLUMN probe.test; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN probe.test IS 'Ist Testdatensatz?';
-
-
---
--- Name: COLUMN probe.mst_id; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN probe.mst_id IS 'ID für Messstelle';
-
-
---
--- Name: COLUMN probe.labor_mst_id; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN probe.labor_mst_id IS '-- ID für Messlabor';
-
-
---
--- Name: COLUMN probe.hauptproben_nr; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN probe.hauptproben_nr IS 'externer Probensclüssel';
-
-
---
--- Name: COLUMN probe.ba_id; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN probe.ba_id IS 'ID der Betriebsart (normal/Routine oder Störfall/intensiv)';
-
-
---
--- Name: COLUMN probe.probenart_id; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN probe.probenart_id IS 'ID der Probenart(Einzel-, Sammel-, Misch- ...Probe)';
-
-
---
--- Name: COLUMN probe.media_desk; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN probe.media_desk IS 'Mediencodierung (Deskriptoren oder ADV-Codierung)';
-
-
---
--- Name: COLUMN probe.media; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN probe.media IS 'dekodierte Medienbezeichnung (aus media_desk abgeleitet)';
-
-
---
--- Name: COLUMN probe.umw_id; Type: COMMENT; Schema: land; Owner: -
---
-
-COMMENT ON COLUMN probe.umw_id IS 'ID für Umweltbereich';
-
-
---
 -- Name: messung; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
@@ -452,4 +368,88 @@
 CREATE INDEX kommentar_messungs_id_idx ON kommentar_m USING btree (messungs_id);
 
 
+--
+-- Name: COLUMN ortszuordnung.ortszuordnung_typ; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN ortszuordnung.ortszuordnung_typ IS 'E = Entnahmeport, U = Ursprungsort, Z = Ortszusatz';
+
+
+--
+-- Name: COLUMN probe.id; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN probe.id IS 'interner Probenschlüssel';
+
+
+--
+-- Name: COLUMN probe.test; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN probe.test IS 'Ist Testdatensatz?';
+
+
+--
+-- Name: COLUMN probe.mst_id; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN probe.mst_id IS 'ID für Messstelle';
+
+
+--
+-- Name: COLUMN probe.labor_mst_id; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN probe.labor_mst_id IS '-- ID für Messlabor';
+
+
+--
+-- Name: COLUMN probe.hauptproben_nr; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN probe.hauptproben_nr IS 'externer Probensclüssel';
+
+
+--
+-- Name: COLUMN probe.ba_id; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN probe.ba_id IS 'ID der Betriebsart (normal/Routine oder Störfall/intensiv)';
+
+
+--
+-- Name: COLUMN probe.probenart_id; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN probe.probenart_id IS 'ID der Probenart(Einzel-, Sammel-, Misch- ...Probe)';
+
+
+--
+-- Name: COLUMN probe.media_desk; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN probe.media_desk IS 'Mediencodierung (Deskriptoren oder ADV-Codierung)';
+
+
+--
+-- Name: COLUMN probe.media; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN probe.media IS 'dekodierte Medienbezeichnung (aus media_desk abgeleitet)';
+
+
+--
+-- Name: COLUMN probe.umw_id; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN probe.umw_id IS 'ID für Umweltbereich';
+
+
+--
+-- Name: COLUMN messprogramm.media_desk; Type: COMMENT; Schema: land; Owner: -
+--
+
+COMMENT ON COLUMN messprogramm.media_desk IS 'dekodierte Medienbezeichnung (aus media_desk abgeleitet)';
+
+
 COMMIT;
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)