Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 2818:25ed1f18fcc4
Improved the MIFNO DB schema for morphological width and added model classes.
flys-backend/trunk@4235 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Fri, 13 Apr 2012 12:33:26 +0000 |
| parents | 8979f2294af9 |
| children | 0c2567626754 |
comparison
equal
deleted
inserted
replaced
| 2817:8979f2294af9 | 2818:25ed1f18fcc4 |
|---|---|
| 140 density NUMBER(38,2) NOT NULL, | 140 density NUMBER(38,2) NOT NULL, |
| 141 description VARCHAR(256), | 141 description VARCHAR(256), |
| 142 PRIMARY KEY(id), | 142 PRIMARY KEY(id), |
| 143 CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id) | 143 CONSTRAINT fk_sdv_sediment_density_id FOREIGN KEY(sediment_density_id) REFERENCES sediment_density(id) |
| 144 ); | 144 ); |
| 145 | |
| 146 | |
| 147 CREATE SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ; | |
| 148 | |
| 149 CREATE TABLE morphologic_width ( | |
| 150 id NUMBER(38,0) NOT NULL, | |
| 151 river_id NUMBER(38,0) NOT NULL, | |
| 152 unit_id NUMBER(38,0) NOT NULL, | |
| 153 PRIMARY KEY(id), | |
| 154 CONSTRAINT fk_mw_river_id FOREIGN KEY(river_id) REFERENCES rivers(id), | |
| 155 CONSTRAINT fk_mw_unit_id FOREIGN KEY(unit_id) REFERENCES units(id) | |
| 156 ); | |
| 157 | |
| 158 | |
| 159 CREATE SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ; | |
| 160 | |
| 161 CREATE TABLE morphologic_width_values ( | |
| 162 id NUMBER(38,0) NOT NULL, | |
| 163 morphologic_width_id NUMBER(38,0) NOT NULL, | |
| 164 station NUMBER(38,3) NOT NULL, | |
| 165 width NUMBER(38,3) NOT NULL, | |
| 166 PRIMARY KEY(id), | |
| 167 CONSTRAINT fk_mwv_morphologic_width_id FOREIGN KEY (morphologic_width_id) REFERENCES morphologic_width(id) | |
| 168 ); |