diff backend/doc/schema/postgresql-sinfo-uinfo.sql @ 9614:d889ffe2fb05

Nachtrag Pos. 20: rename type/part to group/type, group added in Infrastructure class
author mschaefer
date Wed, 09 Oct 2019 19:17:06 +0200
parents 056483975a9c
children 9b8ba3b83a15
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-sinfo-uinfo.sql	Wed Oct 09 16:17:16 2019 +0200
+++ b/backend/doc/schema/postgresql-sinfo-uinfo.sql	Wed Oct 09 19:17:06 2019 +0200
@@ -81,6 +81,7 @@
     id  NUMERIC(9,0) PRIMARY KEY,
     river_id  integer NOT NULL CONSTRAINT cInfrastructureRivers REFERENCES rivers(id) ON DELETE CASCADE,
     annotation_type_id  integer NOT NULL CONSTRAINT cInfrastructureAnnotationType REFERENCES annotation_types(id),
+    group_id  integer NOT NULL CONSTRAINT cInfrastructureGroupAnnoType REFERENCES annotation_types(id),
     year  NUMERIC(4,0) CHECK((year >= 1700) AND (year <= 2199)),
     dataprovider  VARCHAR(256),
     evaluation_by  VARCHAR(256),
@@ -89,6 +90,7 @@
     notes  VARCHAR(256)
 );
 COMMENT ON TABLE infrastructure IS 'Longitudinal section of infrastructures of a river and a type' ;
+COMMENT ON COLUMN infrastructure.group_id IS 'Reference to the infrastructure type group';
 COMMENT ON COLUMN infrastructure.year IS 'File header line info "Stand"' ;
 COMMENT ON COLUMN infrastructure.dataprovider IS 'File header line info "Datenherkunft"' ;
 COMMENT ON COLUMN infrastructure.evaluation_by IS 'File header line info "Auswerter"' ;

http://dive4elements.wald.intevation.org