Mercurial > gemma
comparison schema/gemma.sql @ 4461:7128741faeb9
Changed fa data to accept "position" as strings, not a 2char "position_code"
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Mon, 23 Sep 2019 12:59:48 +0200 |
parents | ce884af9f42f |
children | f7b57136c800 d2eac69ba86b |
comparison
equal
deleted
inserted
replaced
4460:ace7c8d6290d | 4461:7128741faeb9 |
---|---|
702 -- | 702 -- |
703 -- Fairway availability | 703 -- Fairway availability |
704 -- | 704 -- |
705 CREATE TABLE fairway_availability ( | 705 CREATE TABLE fairway_availability ( |
706 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, | 706 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, |
707 position_code char(2) REFERENCES position_codes, | 707 position varchar, |
708 bottleneck_id varchar NOT NULL, | 708 bottleneck_id varchar NOT NULL, |
709 surdat date NOT NULL, | 709 surdat date NOT NULL, |
710 UNIQUE (bottleneck_id, surdat), | 710 UNIQUE (bottleneck_id, surdat), |
711 -- additional_data xml -- Currently not relevant for GEMMA | 711 -- additional_data xml -- Currently not relevant for GEMMA |
712 critical boolean, | 712 critical boolean, |