Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1215:6e393b614edf
The referencing column does not need to be wider than what it refereces.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 08 Dec 2016 15:23:55 +0100 |
| parents | 4ee336c65ab3 |
| children | 9dfb52db6a0f |
comparison
equal
deleted
inserted
replaced
| 1214:6e6134bf1d6d | 1215:6e393b614edf |
|---|---|
| 273 -- | 273 -- |
| 274 | 274 |
| 275 CREATE TABLE ortszuordnung ( | 275 CREATE TABLE ortszuordnung ( |
| 276 id serial PRIMARY KEY, | 276 id serial PRIMARY KEY, |
| 277 probe_id integer NOT NULL REFERENCES probe ON DELETE CASCADE, | 277 probe_id integer NOT NULL REFERENCES probe ON DELETE CASCADE, |
| 278 ort_id bigint NOT NULL REFERENCES stammdaten.ort, | 278 ort_id integer NOT NULL REFERENCES stammdaten.ort, |
| 279 ortszuordnung_typ character varying(1) REFERENCES stammdaten.ortszuordnung_typ, | 279 ortszuordnung_typ character varying(1) REFERENCES stammdaten.ortszuordnung_typ, |
| 280 ortszusatztext character varying(100), | 280 ortszusatztext character varying(100), |
| 281 letzte_aenderung timestamp without time zone DEFAULT now(), | 281 letzte_aenderung timestamp without time zone DEFAULT now(), |
| 282 tree_modified timestamp without time zone DEFAULT now(), | 282 tree_modified timestamp without time zone DEFAULT now(), |
| 283 EXCLUDE (probe_id WITH =) WHERE (ortszuordnung_typ = 'E') | 283 EXCLUDE (probe_id WITH =) WHERE (ortszuordnung_typ = 'E') |