Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-minfo.sql @ 7866:0c74b5f8de17
Precision and scale have to be set to represent integers with NUMBER; DOUBLE PRECISION is preferable for floating point (see issue1304).
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 13 May 2014 10:30:00 +0200 |
| parents | 082284c4e0ad |
| children | a88e308567a1 |
comparison
equal
deleted
inserted
replaced
| 7865:8d4a4c645e61 | 7866:0c74b5f8de17 |
|---|---|
| 148 | 148 |
| 149 | 149 |
| 150 CREATE SEQUENCE POROSITY_ID_SEQ; | 150 CREATE SEQUENCE POROSITY_ID_SEQ; |
| 151 | 151 |
| 152 CREATE TABLE porosity ( | 152 CREATE TABLE porosity ( |
| 153 id NUMBER NOT NULL, | 153 id NUMBER(38,0) NOT NULL, |
| 154 river_id NUMBER NOT NULL, | 154 river_id NUMBER(38,0) NOT NULL, |
| 155 depth_id NUMBER NOT NULL, | 155 depth_id NUMBER(38,0) NOT NULL, |
| 156 description VARCHAR(256), | 156 description VARCHAR(256), |
| 157 time_interval_id NUMBER NOT NULL, | 157 time_interval_id NUMBER(38,0) NOT NULL, |
| 158 PRIMARY KEY(id), | 158 PRIMARY KEY(id), |
| 159 CONSTRAINT fk_p_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, | 159 CONSTRAINT fk_p_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, |
| 160 CONSTRAINT fk_p_depth_id FOREIGN KEY (depth_id) REFERENCES depths(id), | 160 CONSTRAINT fk_p_depth_id FOREIGN KEY (depth_id) REFERENCES depths(id), |
| 161 CONSTRAINT fk_p_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) | 161 CONSTRAINT fk_p_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id) |
| 162 ); | 162 ); |
| 163 | 163 |
| 164 | 164 |
| 165 CREATE SEQUENCE POROSITY_VALUES_ID_SEQ; | 165 CREATE SEQUENCE POROSITY_VALUES_ID_SEQ; |
| 166 | 166 |
| 167 CREATE TABLE porosity_values ( | 167 CREATE TABLE porosity_values ( |
| 168 id NUMBER NOT NULL, | 168 id NUMBER(38,0) NOT NULL, |
| 169 porosity_id NUMBER NOT NULL, | 169 porosity_id NUMBER(38,0) NOT NULL, |
| 170 station NUMBER NOT NULL, | 170 station DOUBLE PRECISION NOT NULL, |
| 171 shore_offset NUMBER, | 171 shore_offset DOUBLE PRECISION, |
| 172 porosity NUMBER NOT NULL, | 172 porosity DOUBLE PRECISION NOT NULL, |
| 173 description VARCHAR(256), | 173 description VARCHAR(256), |
| 174 PRIMARY KEY(id), | 174 PRIMARY KEY(id), |
| 175 CONSTRAINT fk_pv_porosity_id FOREIGN KEY(porosity_id) REFERENCES porosity(id) ON DELETE CASCADE | 175 CONSTRAINT fk_pv_porosity_id FOREIGN KEY(porosity_id) REFERENCES porosity(id) ON DELETE CASCADE |
| 176 ); | 176 ); |
| 177 | 177 |