Mercurial > dive4elements > river
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"' ;