# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1525678198 -7200
# Node ID 535e57373a93891b746afd557d9f3536e58f91f7
# Parent  830287983657cae2ccb8ffa6774748a665de2751
Fix and comments on depth references.

diff -r 830287983657 -r 535e57373a93 wamos.sql
--- a/wamos.sql	Fri May 04 19:12:37 2018 +0200
+++ b/wamos.sql	Mon May 07 09:29:58 2018 +0200
@@ -72,8 +72,14 @@
        );
 
 CREATE TABLE depth_references (
-       depth_reference char(3) PRIMARY KEY
-       -- Possible codes? char(3) ok?
+       depth_reference varchar(4) PRIMARY KEY
+       -- See col. AB and AI RIS-Index Encoding Guide
+       -- XXX: We need a way to distinguish between geodetic (eg. col. AP
+       -- RIS-Index) and other references (e.g. col. AB and AI):
+       -- _ multi-column FK with a boolean column (geodetic/non-geodetic;
+       --   i.e. absolut/not absolut) and DEFAULTs and CHECKs at the FK side.
+       -- _ Do not mixup things with different meanings in one table at all
+       --   (which would mean a model differing a bit from RIS-Index ideas)
        );
 
 CREATE TABLE bottlenecks (