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