Mercurial > gemma
changeset 67:d218aa96170f
Tweak ER-diagramm.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 25 May 2018 21:56:22 +0200 |
parents | 21df0e95db4a |
children | 7a91106668b8 |
files | wamos.sql |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/wamos.sql Fri May 25 21:54:27 2018 +0200 +++ b/wamos.sql Fri May 25 21:56:22 2018 +0200 @@ -160,10 +160,10 @@ CREATE TABLE wamos.fairway_availability ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, + position varchar REFERENCES spot_marks, bottleneck_id varchar NOT NULL REFERENCES bottlenecks, surdat date NOT NULL, UNIQUE (bottleneck_id, surdat), - position varchar REFERENCES spot_marks, -- additional_data xml -- Currently not relevant for WAMOS critical boolean, date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,