Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-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 | f63b39799d2d |
comparison
equal
deleted
inserted
replaced
| 3952:5d8db3349b77 | 3953:fc32a4955087 |
|---|---|
| 82 id int NOT NULL, | 82 id int NOT NULL, |
| 83 bed_height_single_id int NOT NULL, | 83 bed_height_single_id int NOT NULL, |
| 84 station NUMERIC NOT NULL, | 84 station NUMERIC NOT NULL, |
| 85 height NUMERIC, | 85 height NUMERIC, |
| 86 uncertainty NUMERIC, | 86 uncertainty NUMERIC, |
| 87 data_gap NUMERIC NOT NULL, | 87 data_gap NUMERIC, |
| 88 sounding_width NUMERIC NOT NULL, | 88 sounding_width NUMERIC, |
| 89 width NUMERIC NOT NULL, | 89 width NUMERIC, |
| 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 |