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 |