Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 914:54e83373bfae
We need a wider range to allow arbitrary input formated +-9.99e+-99
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 08 Apr 2016 17:17:06 +0200 |
| parents | 56c9fb1d37c8 |
| children | 34c04b0557ac 9121d99a471e |
comparison
equal
deleted
inserted
replaced
| 913:adc0a47b7b9d | 914:54e83373bfae |
|---|---|
| 300 CREATE TABLE messwert ( | 300 CREATE TABLE messwert ( |
| 301 id integer DEFAULT nextval('messwert_id_seq'::regclass) NOT NULL, | 301 id integer DEFAULT nextval('messwert_id_seq'::regclass) NOT NULL, |
| 302 messungs_id integer NOT NULL, | 302 messungs_id integer NOT NULL, |
| 303 messgroesse_id integer NOT NULL, | 303 messgroesse_id integer NOT NULL, |
| 304 messwert_nwg character varying(1), | 304 messwert_nwg character varying(1), |
| 305 messwert real NOT NULL, | 305 messwert double precision NOT NULL, |
| 306 messfehler real, | 306 messfehler real, |
| 307 nwg_zu_messwert real, | 307 nwg_zu_messwert double precision, |
| 308 meh_id smallint NOT NULL, | 308 meh_id smallint NOT NULL, |
| 309 grenzwertueberschreitung boolean DEFAULT false, | 309 grenzwertueberschreitung boolean DEFAULT false, |
| 310 letzte_aenderung timestamp without time zone DEFAULT now() | 310 letzte_aenderung timestamp without time zone DEFAULT now() |
| 311 ); | 311 ); |
| 312 | 312 |
| 493 | 493 |
| 494 CREATE TABLE zusatz_wert ( | 494 CREATE TABLE zusatz_wert ( |
| 495 id integer DEFAULT nextval('zusatz_wert_id_seq'::regclass) NOT NULL, | 495 id integer DEFAULT nextval('zusatz_wert_id_seq'::regclass) NOT NULL, |
| 496 probe_id integer NOT NULL, | 496 probe_id integer NOT NULL, |
| 497 pzs_id character varying(3) NOT NULL, | 497 pzs_id character varying(3) NOT NULL, |
| 498 messwert_pzs real, | 498 messwert_pzs double precision, |
| 499 messfehler real, | 499 messfehler real, |
| 500 letzte_aenderung timestamp without time zone DEFAULT now(), | 500 letzte_aenderung timestamp without time zone DEFAULT now(), |
| 501 nwg_zu_messwert real | 501 nwg_zu_messwert double precision |
| 502 ); | 502 ); |
| 503 | 503 |
| 504 | 504 |
| 505 SET search_path = land, pg_catalog; | 505 SET search_path = land, pg_catalog; |
| 506 | 506 |