Mercurial > lada > lada-server
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;