Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 2819:0c2567626754
Tiny schema modification specific to MINFO morphological width values; added importer classes.
flys-backend/trunk@4236 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Fri, 13 Apr 2012 12:53:29 +0000 |
| parents | 25ed1f18fcc4 |
| children | 13b3fcaa1b34 |
comparison
equal
deleted
inserted
replaced
| 2818:25ed1f18fcc4 | 2819:0c2567626754 |
|---|---|
| 161 CREATE TABLE morphologic_width_values ( | 161 CREATE TABLE morphologic_width_values ( |
| 162 id NUMBER(38,0) NOT NULL, | 162 id NUMBER(38,0) NOT NULL, |
| 163 morphologic_width_id NUMBER(38,0) NOT NULL, | 163 morphologic_width_id NUMBER(38,0) NOT NULL, |
| 164 station NUMBER(38,3) NOT NULL, | 164 station NUMBER(38,3) NOT NULL, |
| 165 width NUMBER(38,3) NOT NULL, | 165 width NUMBER(38,3) NOT NULL, |
| 166 description VARCHAR(256), | |
| 166 PRIMARY KEY(id), | 167 PRIMARY KEY(id), |
| 167 CONSTRAINT fk_mwv_morphologic_width_id FOREIGN KEY (morphologic_width_id) REFERENCES morphologic_width(id) | 168 CONSTRAINT fk_mwv_morphologic_width_id FOREIGN KEY (morphologic_width_id) REFERENCES morphologic_width(id) |
| 168 ); | 169 ); |