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; |