Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1129:48c0132dbc85
Adapt definition to LAF and validate uniqueness of idAlt.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 01 Nov 2016 12:47:25 +0100 |
| parents | 70b51893f15b |
| children | 84ff77bba9b0 |
comparison
equal
deleted
inserted
replaced
| 1128:830a47aeb15d | 1129:48c0132dbc85 |
|---|---|
| 190 -- Name: probe; Type: TABLE; Schema: land; Owner: -; Tablespace: | 190 -- Name: probe; Type: TABLE; Schema: land; Owner: -; Tablespace: |
| 191 -- | 191 -- |
| 192 | 192 |
| 193 CREATE TABLE probe ( | 193 CREATE TABLE probe ( |
| 194 id serial PRIMARY KEY, | 194 id serial PRIMARY KEY, |
| 195 id_alt character varying(20) UNIQUE NOT NULL | 195 id_alt character varying(16) UNIQUE NOT NULL |
| 196 DEFAULT 'sss' | 196 DEFAULT 'sss' |
| 197 || lpad(nextval('land.probe_probe_id_seq')::varchar, 12, '0') | 197 || lpad(nextval('land.probe_probe_id_seq')::varchar, 12, '0') |
| 198 || 'Y', | 198 || 'Y', |
| 199 test boolean DEFAULT false NOT NULL, | 199 test boolean DEFAULT false NOT NULL, |
| 200 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 200 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |