Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 901:56c9fb1d37c8
probe and messprogramm always need a mst_id and labor_mst_id.
Otherwise no owner can be determined.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 23 Mar 2016 18:52:09 +0100 |
| parents | 26d57ae6dd2f |
| children | 54e83373bfae |
comparison
equal
deleted
inserted
replaced
| 900:26d57ae6dd2f | 901:56c9fb1d37c8 |
|---|---|
| 362 | 362 |
| 363 CREATE TABLE probe ( | 363 CREATE TABLE probe ( |
| 364 id integer PRIMARY KEY DEFAULT nextval('probe_id_seq'::regclass), | 364 id integer PRIMARY KEY DEFAULT nextval('probe_id_seq'::regclass), |
| 365 test boolean DEFAULT false NOT NULL, | 365 test boolean DEFAULT false NOT NULL, |
| 366 netzbetreiber_id character varying(2) REFERENCES stammdaten.netz_betreiber, | 366 netzbetreiber_id character varying(2) REFERENCES stammdaten.netz_betreiber, |
| 367 mst_id character varying(5) REFERENCES stammdaten.mess_stelle, | 367 mst_id character varying(5) NOT NULL |
| 368 labor_mst_id character varying(5) REFERENCES stammdaten.mess_stelle, | 368 REFERENCES stammdaten.mess_stelle, |
| 369 labor_mst_id character varying(5) NOT NULL | |
| 370 REFERENCES stammdaten.mess_stelle, | |
| 369 hauptproben_nr character varying(20), | 371 hauptproben_nr character varying(20), |
| 370 datenbasis_id smallint REFERENCES stammdaten.datenbasis, | 372 datenbasis_id smallint REFERENCES stammdaten.datenbasis, |
| 371 ba_id character varying(1), | 373 ba_id character varying(1), |
| 372 probenart_id smallint NOT NULL REFERENCES stammdaten.probenart, | 374 probenart_id smallint NOT NULL REFERENCES stammdaten.probenart, |
| 373 media_desk character varying(100), | 375 media_desk character varying(100), |
| 541 name character varying(256), | 543 name character varying(256), |
| 542 test boolean DEFAULT false NOT NULL, | 544 test boolean DEFAULT false NOT NULL, |
| 543 netzbetreiber_id character varying(2) NOT NULL | 545 netzbetreiber_id character varying(2) NOT NULL |
| 544 REFERENCES stammdaten.netz_betreiber, | 546 REFERENCES stammdaten.netz_betreiber, |
| 545 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 547 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 546 labor_mst_id character varying(5) REFERENCES stammdaten.mess_stelle, | 548 labor_mst_id character varying(5) NOT NULL |
| 549 REFERENCES stammdaten.mess_stelle, | |
| 547 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, | 550 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, |
| 548 ba_id character varying(1), | 551 ba_id character varying(1), |
| 549 gem_id character varying(8), | 552 gem_id character varying(8), |
| 550 ort_id integer REFERENCES stammdaten.ort, | 553 ort_id integer REFERENCES stammdaten.ort, |
| 551 media_desk character varying(100), | 554 media_desk character varying(100), |