Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1007:6a313cb77fda schema-update
Renamed erzeuger to mst_id.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 08:53:39 +0200 |
| parents | 599bd9462e62 |
| children | 17e9d1b2d471 |
comparison
equal
deleted
inserted
replaced
| 1006:599bd9462e62 | 1007:6a313cb77fda |
|---|---|
| 191 -- Name: kommentar_p; Type: TABLE; Schema: land; Owner: -; Tablespace: | 191 -- Name: kommentar_p; Type: TABLE; Schema: land; Owner: -; Tablespace: |
| 192 -- | 192 -- |
| 193 | 193 |
| 194 CREATE TABLE kommentar_p ( | 194 CREATE TABLE kommentar_p ( |
| 195 id serial PRIMARY KEY, | 195 id serial PRIMARY KEY, |
| 196 erzeuger character varying(5) NOT NULL, | 196 mst_id character varying(5) NOT NULL, |
| 197 datum timestamp without time zone DEFAULT now(), | 197 datum timestamp without time zone DEFAULT now(), |
| 198 text character varying(1024), | 198 text character varying(1024), |
| 199 probe_id integer NOT NULL REFERENCES probe ON DELETE CASCADE | 199 probe_id integer NOT NULL REFERENCES probe ON DELETE CASCADE |
| 200 ); | 200 ); |
| 201 | 201 |
| 262 -- Name: kommentar_m; Type: TABLE; Schema: land; Owner: -; Tablespace: | 262 -- Name: kommentar_m; Type: TABLE; Schema: land; Owner: -; Tablespace: |
| 263 -- | 263 -- |
| 264 | 264 |
| 265 CREATE TABLE kommentar_m ( | 265 CREATE TABLE kommentar_m ( |
| 266 id serial PRIMARY KEY, | 266 id serial PRIMARY KEY, |
| 267 erzeuger character varying(5) NOT NULL, | 267 mst_id character varying(5) NOT NULL, |
| 268 datum timestamp without time zone DEFAULT now(), | 268 datum timestamp without time zone DEFAULT now(), |
| 269 text character varying(1024), | 269 text character varying(1024), |
| 270 messungs_id integer NOT NULL REFERENCES messung ON DELETE CASCADE | 270 messungs_id integer NOT NULL REFERENCES messung ON DELETE CASCADE |
| 271 ); | 271 ); |
| 272 | 272 |
| 297 -- Name: status_protokoll; Type: TABLE; Schema: land; Owner: -; Tablespace: | 297 -- Name: status_protokoll; Type: TABLE; Schema: land; Owner: -; Tablespace: |
| 298 -- | 298 -- |
| 299 | 299 |
| 300 CREATE TABLE status_protokoll ( | 300 CREATE TABLE status_protokoll ( |
| 301 id serial PRIMARY KEY, | 301 id serial PRIMARY KEY, |
| 302 erzeuger character varying(5) NOT NULL, | 302 mst_id character varying(5) NOT NULL, |
| 303 datum timestamp without time zone DEFAULT now(), | 303 datum timestamp without time zone DEFAULT now(), |
| 304 text character varying(1024), | 304 text character varying(1024), |
| 305 messungs_id integer NOT NULL REFERENCES messung ON DELETE CASCADE, | 305 messungs_id integer NOT NULL REFERENCES messung ON DELETE CASCADE, |
| 306 status_stufe integer NOT NULL REFERENCES stammdaten.status_stufe, | 306 status_stufe integer NOT NULL REFERENCES stammdaten.status_stufe, |
| 307 status_wert integer NOT NULL REFERENCES stammdaten.status_wert, | 307 status_wert integer NOT NULL REFERENCES stammdaten.status_wert, |