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