Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1194:289edf060550
Removed table de_vg and added verwaltungsgrenze.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Tue, 29 Nov 2016 15:57:09 +0100 |
| parents | 1bc8ab13e1f7 |
| children | 9dda1237c756 |
comparison
equal
deleted
inserted
replaced
| 1193:00323d9e642c | 1194:289edf060550 |
|---|---|
| 165 ); | 165 ); |
| 166 | 166 |
| 167 CREATE TABLE verwaltungsgrenze ( | 167 CREATE TABLE verwaltungsgrenze ( |
| 168 id serial PRIMARY KEY, | 168 id serial PRIMARY KEY, |
| 169 gem_id character varying(8) NOT NULL, | 169 gem_id character varying(8) NOT NULL, |
| 170 shape public.geometry(MultiPolygon) | 170 shape public.geometry(MultiPolygon, 4326) |
| 171 ); | 171 ); |
| 172 | 172 |
| 173 CREATE TABLE netz_betreiber ( | 173 CREATE TABLE netz_betreiber ( |
| 174 id character varying(2) PRIMARY KEY, | 174 id character varying(2) PRIMARY KEY, |
| 175 netzbetreiber character varying(50), | 175 netzbetreiber character varying(50), |
| 233 bezeichnung character varying(120) NOT NULL, | 233 bezeichnung character varying(120) NOT NULL, |
| 234 letzte_aenderung timestamp without time zone, | 234 letzte_aenderung timestamp without time zone, |
| 235 UNIQUE(datensatz_erzeuger_id, netzbetreiber_id) | 235 UNIQUE(datensatz_erzeuger_id, netzbetreiber_id) |
| 236 ); | 236 ); |
| 237 CREATE TRIGGER letzte_aenderung_datensatz_erzeuger BEFORE UPDATE ON datensatz_erzeuger FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); | 237 CREATE TRIGGER letzte_aenderung_datensatz_erzeuger BEFORE UPDATE ON datensatz_erzeuger FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); |
| 238 | |
| 239 CREATE TABLE de_vg ( | |
| 240 id serial PRIMARY KEY, | |
| 241 use double precision, | |
| 242 rs character varying(12), | |
| 243 gf double precision, | |
| 244 rau_rs character varying(12), | |
| 245 gen character varying(50), | |
| 246 des character varying(75), | |
| 247 isn double precision, | |
| 248 bemerk character varying(75), | |
| 249 nambild character varying(16), | |
| 250 ags character varying(12), | |
| 251 rs_alt character varying(20), | |
| 252 wirksamkei date, | |
| 253 debkg_id character varying(16), | |
| 254 length numeric, | |
| 255 shape_area numeric, | |
| 256 geom public.geometry(MultiPolygon,4326) | |
| 257 ); | |
| 258 | 238 |
| 259 | 239 |
| 260 CREATE TABLE deskriptor_umwelt ( | 240 CREATE TABLE deskriptor_umwelt ( |
| 261 id serial PRIMARY KEY, | 241 id serial PRIMARY KEY, |
| 262 s00 integer NOT NULL, | 242 s00 integer NOT NULL, |