comparison db_schema/stammdaten_schema.sql @ 965:ad69878b7280

Authorize status change only for matching user. Matching means belonging to the MessStelle respectively Netzbetreiber of the probe.
author Tom Gottfried <tom@intevation.de>
date Wed, 01 Jun 2016 15:25:08 +0200
parents 379480a94c81
children 69b954343acc
comparison
equal deleted inserted replaced
964:3c1b1631e474 965:ad69878b7280
138 ); 138 );
139 139
140 140
141 CREATE TABLE mess_stelle ( 141 CREATE TABLE mess_stelle (
142 id character varying(5) PRIMARY KEY, 142 id character varying(5) PRIMARY KEY,
143 netzbetreiber_id character varying(2), 143 netzbetreiber_id character varying(2) NOT NULL,
144 beschreibung character varying(300), 144 beschreibung character varying(300),
145 mess_stelle character varying(60), 145 mess_stelle character varying(60),
146 mst_typ character varying(1), 146 mst_typ character varying(1),
147 amtskennung character varying(6) 147 amtskennung character varying(6)
148 ); 148 );
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)