Mercurial > dive4elements > river
diff backend/doc/schema/oracle-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/oracle-sinfo-uinfo.sql Wed Oct 09 16:17:16 2019 +0200 +++ b/backend/doc/schema/oracle-sinfo-uinfo.sql Wed Oct 09 19:17:06 2019 +0200 @@ -85,6 +85,7 @@ id NUMBER(9,0) PRIMARY KEY, river_id NUMBER(38,0) NOT NULL CONSTRAINT cInfrastructureRivers REFERENCES rivers(id) ON DELETE CASCADE, annotation_type_id NUMBER(38,0) NOT NULL CONSTRAINT cInfrastructureAnnotationType REFERENCES annotation_types(id), + group_id NUMBER(38,0) NOT NULL CONSTRAINT cInfrastructureGroupAnnoType REFERENCES annotation_types(id), year NUMBER(4,0) CHECK((year >= 1700) AND (year <= 2199)), dataprovider VARCHAR2(256), evaluation_by VARCHAR2(256), @@ -93,6 +94,7 @@ notes VARCHAR2(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"' ;