Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 9612:f8308db94634 | 9614:d889ffe2fb05 |
|---|---|
| 83 | 83 |
| 84 CREATE TABLE infrastructure ( | 84 CREATE TABLE infrastructure ( |
| 85 id NUMBER(9,0) PRIMARY KEY, | 85 id NUMBER(9,0) PRIMARY KEY, |
| 86 river_id NUMBER(38,0) NOT NULL CONSTRAINT cInfrastructureRivers REFERENCES rivers(id) ON DELETE CASCADE, | 86 river_id NUMBER(38,0) NOT NULL CONSTRAINT cInfrastructureRivers REFERENCES rivers(id) ON DELETE CASCADE, |
| 87 annotation_type_id NUMBER(38,0) NOT NULL CONSTRAINT cInfrastructureAnnotationType REFERENCES annotation_types(id), | 87 annotation_type_id NUMBER(38,0) NOT NULL CONSTRAINT cInfrastructureAnnotationType REFERENCES annotation_types(id), |
| 88 group_id NUMBER(38,0) NOT NULL CONSTRAINT cInfrastructureGroupAnnoType REFERENCES annotation_types(id), | |
| 88 year NUMBER(4,0) CHECK((year >= 1700) AND (year <= 2199)), | 89 year NUMBER(4,0) CHECK((year >= 1700) AND (year <= 2199)), |
| 89 dataprovider VARCHAR2(256), | 90 dataprovider VARCHAR2(256), |
| 90 evaluation_by VARCHAR2(256), | 91 evaluation_by VARCHAR2(256), |
| 91 kmrange_info VARCHAR2(32), | 92 kmrange_info VARCHAR2(32), |
| 92 filename VARCHAR2(256) NOT NULL, | 93 filename VARCHAR2(256) NOT NULL, |
| 93 notes VARCHAR2(256) | 94 notes VARCHAR2(256) |
| 94 ); | 95 ); |
| 95 COMMENT ON TABLE infrastructure IS 'Longitudinal section of infrastructures of a river and a type' ; | 96 COMMENT ON TABLE infrastructure IS 'Longitudinal section of infrastructures of a river and a type' ; |
| 97 COMMENT ON COLUMN infrastructure.group_id IS 'Reference to the infrastructure type group'; | |
| 96 COMMENT ON COLUMN infrastructure.year IS 'File header line info "Stand"' ; | 98 COMMENT ON COLUMN infrastructure.year IS 'File header line info "Stand"' ; |
| 97 COMMENT ON COLUMN infrastructure.dataprovider IS 'File header line info "Datenherkunft"' ; | 99 COMMENT ON COLUMN infrastructure.dataprovider IS 'File header line info "Datenherkunft"' ; |
| 98 COMMENT ON COLUMN infrastructure.evaluation_by IS 'File header line info "Auswerter"' ; | 100 COMMENT ON COLUMN infrastructure.evaluation_by IS 'File header line info "Auswerter"' ; |
| 99 COMMENT ON COLUMN infrastructure.kmrange_info IS 'File header line info "Strecke"' ; | 101 COMMENT ON COLUMN infrastructure.kmrange_info IS 'File header line info "Strecke"' ; |
| 100 COMMENT ON COLUMN infrastructure.filename IS 'Name without type extension of the imported file' ; | 102 COMMENT ON COLUMN infrastructure.filename IS 'Name without type extension of the imported file' ; |