Mercurial > lada > lada-server
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 ); |