annotate backend/doc/schema/postgresql-alter-wsts.sql @ 8978:b5600453bb8f
SINFO Calculations: do not produce result rows if some input data has missing values.
Also check for years of waterlevels in flow depth development calculation.
| author |
gernotbelger |
| date |
Thu, 05 Apr 2018 11:57:54 +0200 |
| parents |
3c11bf4d7778 |
| children |
|
| rev |
line source |
|
8967
|
1 BEGIN; |
|
|
2 |
|
|
3 |
|
|
4 --Add a column to specify S-INFO selection |
|
|
5 ALTER TABLE wsts ADD COLUMN sinfo_selection VARCHAR(1) CHECK((sinfo_selection IS NULL) OR (sinfo_selection IN ('W','Q'))); |
|
|
6 COMMENT ON COLUMN wsts.sinfo_selection IS 'Whether and how the WST series is selected within S-INFO calculation types ("W"=without-Q-group, "Q"=with-Q-group, NULL=not-selectable)' ; |
|
|
7 |
|
|
8 |
|
|
9 COMMIT; |
