Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5783:153456f84602
add missing constraints to Oracle Schema (issue426) and some cosmetics
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 22 Apr 2013 13:00:13 +0200 |
| parents | b5553164fabf |
| children |
comparison
equal
deleted
inserted
replaced
| 5782:5ad389bc20f0 | 5783:153456f84602 |
|---|---|
| 123 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 123 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
| 124 name VARCHAR(64), | 124 name VARCHAR(64), |
| 125 range_id INT REFERENCES ranges(id), | 125 range_id INT REFERENCES ranges(id), |
| 126 time_interval_id INT REFERENCES time_intervals(id), | 126 time_interval_id INT REFERENCES time_intervals(id), |
| 127 projection VARCHAR(32), | 127 projection VARCHAR(32), |
| 128 srid int NOT NULL, | 128 srid int NOT NULL, |
| 129 elevation_state VARCHAR(32), | 129 elevation_state VARCHAR(32), |
| 130 format VARCHAR(32), | 130 format VARCHAR(32), |
| 131 border_break BOOLEAN NOT NULL DEFAULT FALSE, | 131 border_break BOOLEAN NOT NULL DEFAULT FALSE, |
| 132 resolution VARCHAR(16), | 132 resolution VARCHAR(16), |
| 133 description VARCHAR(256), | 133 description VARCHAR(256), |