Mercurial > dive4elements > river
changeset 8967:3c11bf4d7778
Add wsts column for S-INFO selection flag
author | mschaefer |
---|---|
date | Tue, 03 Apr 2018 08:30:02 +0200 |
parents | 5b23efe99e80 |
children | 66471a3b3db2 |
files | backend/doc/schema/postgresql-alter-wsts.sql |
diffstat | 1 files changed, 9 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/backend/doc/schema/postgresql-alter-wsts.sql Tue Apr 03 08:30:02 2018 +0200 @@ -0,0 +1,9 @@ +BEGIN; + + +--Add a column to specify S-INFO selection +ALTER TABLE wsts ADD COLUMN sinfo_selection VARCHAR(1) CHECK((sinfo_selection IS NULL) OR (sinfo_selection IN ('W','Q'))); +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)' ; + + +COMMIT;