Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql.sql @ 1209:c12b5fbd33e8
schema: Added structures for HYKs "Hydraulische Kenngroessen"
flys-backend/trunk@2335 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 15 Jul 2011 09:36:23 +0000 |
| parents | 5f1506fc7636 |
| children | dd948530fd57 |
comparison
equal
deleted
inserted
replaced
| 1208:2b57edd94735 | 1209:c12b5fbd33e8 |
|---|---|
| 289 x NUMERIC NOT NULL, | 289 x NUMERIC NOT NULL, |
| 290 y NUMERIC NOT NULL, | 290 y NUMERIC NOT NULL, |
| 291 UNIQUE (cross_section_line_id, col_pos) | 291 UNIQUE (cross_section_line_id, col_pos) |
| 292 ); | 292 ); |
| 293 | 293 |
| 294 -- Hydraulische Kenngroessen | |
| 295 | |
| 296 CREATE SEQUENCE HYKS_ID_SEQ; | |
| 297 | |
| 298 CREATE TABLE hyks ( | |
| 299 id int PRIMARY KEY NOT NULL, | |
| 300 river_id int NOT NULL, | |
| 301 description VARCHAR(256) NOT NULL | |
| 302 ); | |
| 303 | |
| 304 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ; | |
| 305 | |
| 306 CREATE TABLE hyk_entries ( | |
| 307 id int PRIMARY KEY NOT NULL, | |
| 308 hyk_id int NOT NULL REFERENCES hyks(id), | |
| 309 km NUMERIC NOT NULL, | |
| 310 UNIQUE (hyk_id, km) | |
| 311 ); | |
| 312 | |
| 313 CREATE SEQUENCE HYK_FORMATIONS_ID_SEQ; | |
| 314 | |
| 315 CREATE TABLE hyk_formations ( | |
| 316 id int PRIMARY KEY NOT NULL, | |
| 317 formation_num int NOT NULL DEFAULT 0, | |
| 318 hyk_entry_id int NOT NULL REFERENCES hyk_entries(id), | |
| 319 top NUMERIC NOT NULL, | |
| 320 bottom NUMERIC NOT NULL, | |
| 321 UNIQUE (hyk_entry_id, formation_num) | |
| 322 ); | |
| 323 | |
| 324 CREATE SEQUENCE HYK_FLOW_ZONE_TYPES_ID_SEQ; | |
| 325 | |
| 326 CREATE TABLE hyk_flow_zone_types ( | |
| 327 id int PRIMARY KEY NOT NULL, | |
| 328 name VARCHAR(50) NOT NULL UNIQUE, | |
| 329 description VARCHAR(256) | |
| 330 ); | |
| 331 | |
| 332 CREATE SEQUENCE HYK_FLOW_ZONES_ID_SEQ; | |
| 333 | |
| 334 CREATE TABLE hyk_flow_zones ( | |
| 335 id int PRIMARY KEY NOT NULL, | |
| 336 formation_id int NOT NULL REFERENCES hyk_formations(id), | |
| 337 type_id int NOT NULL REFERENCES hyk_flow_zone_types(id), | |
| 338 a NUMERIC NOT NULL, | |
| 339 b NUMERIC NOT NULL, | |
| 340 CHECK (a <= b) | |
| 341 ); | |
| 342 | |
| 294 COMMIT; | 343 COMMIT; |