Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 2809:f283212966e8
Finished work on MINFO bed heights (single).
flys-backend/trunk@4221 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 12 Apr 2012 10:42:46 +0000 |
| parents | 5ac1db5156be |
| children | 04eeb45df27b |
comparison
equal
deleted
inserted
replaced
| 2808:b57c95094b68 | 2809:f283212966e8 |
|---|---|
| 33 | 33 |
| 34 CREATE SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; | 34 CREATE SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; |
| 35 | 35 |
| 36 CREATE TABLE bed_height_single ( | 36 CREATE TABLE bed_height_single ( |
| 37 id NUMBER(38,0) NOT NULL, | 37 id NUMBER(38,0) NOT NULL, |
| 38 river_id NUMBER(38,0) NOT NULL, | |
| 38 year NUMBER(38,0) NOT NULL, | 39 year NUMBER(38,0) NOT NULL, |
| 39 sounding_width NUMBER(38,0) NOT NULL, | 40 sounding_width NUMBER(38,0) NOT NULL, |
| 40 type_id NUMBER(38,0) NOT NULL, | 41 type_id NUMBER(38,0) NOT NULL, |
| 41 location_system_id NUMBER(38,0) NOT NULL, | 42 location_system_id NUMBER(38,0) NOT NULL, |
| 42 cur_elevation_model_id NUMBER(38,0) NOT NULL, | 43 cur_elevation_model_id NUMBER(38,0) NOT NULL, |
| 43 old_elevation_model_id NUMBER(38,0), | 44 old_elevation_model_id NUMBER(38,0), |
| 44 range_id NUMBER(38,0) NOT NULL, | 45 range_id NUMBER(38,0) NOT NULL, |
| 45 evaluation_by VARCHAR(255), | 46 evaluation_by VARCHAR(255), |
| 46 description VARCHAR(255), | 47 description VARCHAR(255), |
| 47 PRIMARY KEY(id), | 48 PRIMARY KEY(id), |
| 49 CONSTRAINT fk_bed_single_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), | |
| 48 CONSTRAINT fk_type FOREIGN KEY (type_id) REFERENCES bed_height_type(id), | 50 CONSTRAINT fk_type FOREIGN KEY (type_id) REFERENCES bed_height_type(id), |
| 49 CONSTRAINT fk_location_system FOREIGN KEY (location_system_id) REFERENCES location_system(id), | 51 CONSTRAINT fk_location_system FOREIGN KEY (location_system_id) REFERENCES location_system(id), |
| 50 CONSTRAINT fk_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) REFERENCES elevation_model(id), | 52 CONSTRAINT fk_cur_elevation_model FOREIGN KEY (cur_elevation_model_id) REFERENCES elevation_model(id), |
| 51 CONSTRAINT fk_old_elevation_model FOREIGN KEY (old_elevation_model_id) REFERENCES elevation_model(id), | 53 CONSTRAINT fk_old_elevation_model FOREIGN KEY (old_elevation_model_id) REFERENCES elevation_model(id), |
| 52 CONSTRAINT fk_range FOREIGN KEY (range_id) REFERENCES ranges(id) | 54 CONSTRAINT fk_range FOREIGN KEY (range_id) REFERENCES ranges(id) |