Mercurial > lada > lada-server
view db_schema/stammdaten_data_ort_typ.sql @ 1290:14876c62f692
Push down refreshing of persisted objects deeper into the stack.
There are more places besides creation of Probe objects where it is
useful to return within the response what has been really written to
the database (including modifications by the database itself) instead
of merely the request data, e.g. creation of Ort objects, which
includes database generated ort_ids.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 08 Feb 2017 18:02:05 +0100 |
| parents | a4c7057cbaed |
| children | 3ac30d816c9a |
line wrap: on
line source
\set ON_ERROR_STOP on -- -- PostgreSQL database dump -- -- Dumped from database version 9.5.1 -- Dumped by pg_dump version 9.5.0 -- Started on 2016-03-31 11:38:13 SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; SET search_path = stammdaten, pg_catalog; -- -- TOC entry 4706 (class 0 OID 535799) -- Dependencies: 272 -- Data for Name: ort_typ; Type: TABLE DATA; Schema: stammdaten; Owner: lada -- COPY ort_typ (id, ort_typ, code) FROM stdin; 1 dynamischer Messpunkt (nicht vordefiniert) DYN 2 vordefinierter Messpunkt GP 3 REI-Messpunkit REI 4 Verwaltungseinheit VE 5 Staat ST 6 Fluss FL 7 See SEE 8 Wasserwerk WW 9 Kläranlage KA 10 Deponie DEP 11 Müllverbrennungsanlage MVA 12 Messstation MST 13 KTA KTA \.