Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1006:599bd9462e62 schema-update
Removed duplicated netzbetreiber column. (mst_id already contains the
netzbetreiber)
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 08:52:13 +0200 |
| parents | e9116ec4eb40 |
| children | 6a313cb77fda |
comparison
equal
deleted
inserted
replaced
| 1005:e9116ec4eb40 | 1006:599bd9462e62 |
|---|---|
| 114 | 114 |
| 115 CREATE TABLE messprogramm ( | 115 CREATE TABLE messprogramm ( |
| 116 id serial PRIMARY KEY, | 116 id serial PRIMARY KEY, |
| 117 name character varying(256), | 117 name character varying(256), |
| 118 test boolean DEFAULT false NOT NULL, | 118 test boolean DEFAULT false NOT NULL, |
| 119 netzbetreiber_id character varying(2) NOT NULL | |
| 120 REFERENCES stammdaten.netz_betreiber, | |
| 121 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 119 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 122 labor_mst_id character varying(5) NOT NULL | 120 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 123 REFERENCES stammdaten.mess_stelle, | |
| 124 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, | 121 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, |
| 125 ba_id character varying(1), | 122 ba_id character varying(1), |
| 126 gem_id character varying(8), | 123 gem_id character varying(8), |
| 127 ort_id integer NOT NULL REFERENCES stammdaten.ort, | 124 ort_id integer NOT NULL REFERENCES stammdaten.ort, |
| 128 media_desk character varying(100), | 125 media_desk character varying(100), |
| 161 | 158 |
| 162 CREATE TABLE probe ( | 159 CREATE TABLE probe ( |
| 163 id serial PRIMARY KEY, | 160 id serial PRIMARY KEY, |
| 164 id_alt character varying(20) DEFAULT (('sss'::text || lpad(((nextval('land.probe_probe_id_seq'::regclass))::character varying)::text, 12, '0'::text)) || 'Y'::text) NOT NULL, | 161 id_alt character varying(20) DEFAULT (('sss'::text || lpad(((nextval('land.probe_probe_id_seq'::regclass))::character varying)::text, 12, '0'::text)) || 'Y'::text) NOT NULL, |
| 165 test boolean DEFAULT false NOT NULL, | 162 test boolean DEFAULT false NOT NULL, |
| 166 netzbetreiber_id character varying(2) REFERENCES stammdaten.netz_betreiber, | 163 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 167 mst_id character varying(5) NOT NULL | 164 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 168 REFERENCES stammdaten.mess_stelle, | |
| 169 labor_mst_id character varying(5) NOT NULL | |
| 170 REFERENCES stammdaten.mess_stelle, | |
| 171 hauptproben_nr character varying(20), | 165 hauptproben_nr character varying(20), |
| 172 datenbasis_id smallint REFERENCES stammdaten.datenbasis, | 166 datenbasis_id smallint REFERENCES stammdaten.datenbasis, |
| 173 ba_id character varying(1), | 167 ba_id character varying(1), |
| 174 probenart_id smallint NOT NULL REFERENCES stammdaten.probenart, | 168 probenart_id smallint NOT NULL REFERENCES stammdaten.probenart, |
| 175 media_desk character varying(100), | 169 media_desk character varying(100), |