Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-minfo.sql @ 3953:fc32a4955087
Towards fix for issue863 (gaps in bedheight data).
flys-backend/trunk@5610 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
---|---|
date | Thu, 27 Sep 2012 10:15:10 +0000 |
parents | 8f232119011e |
children | 504cd5801785 |
comparison
equal
deleted
inserted
replaced
3952:5d8db3349b77 | 3953:fc32a4955087 |
---|---|
82 id NUMBER(38,0) NOT NULL, | 82 id NUMBER(38,0) NOT NULL, |
83 bed_height_single_id NUMBER(38,0) NOT NULL, | 83 bed_height_single_id NUMBER(38,0) NOT NULL, |
84 station NUMBER(38,2) NOT NULL, | 84 station NUMBER(38,2) NOT NULL, |
85 height NUMBER(38,2), | 85 height NUMBER(38,2), |
86 uncertainty NUMBER(38,2), | 86 uncertainty NUMBER(38,2), |
87 data_gap NUMBER(38,2) NOT NULL, | 87 data_gap NUMBER(38,2), |
88 sounding_width NUMBER(38,2) NOT NULL, | 88 sounding_width NUMBER(38,2), |
89 width NUMBER(38,2) NOT NULL, | 89 width NUMBER(38,2), |
90 PRIMARY KEY(id), | 90 PRIMARY KEY(id), |
91 CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) | 91 CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) |
92 ); | 92 ); |
93 | 93 |
94 | 94 |