Mercurial > dive4elements > river
diff backend/doc/schema/postgresql-sinfo-uinfo.sql @ 9401:361de818f76e
Added color fields to the vegetation zone database table and importer, max days field changed from exclusive to inclusive
| author | mschaefer |
|---|---|
| date | Tue, 14 Aug 2018 14:02:26 +0200 |
| parents | 4c5eeaff554c |
| children | 69a7edd7d1e1 |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-sinfo-uinfo.sql Tue Aug 14 11:06:00 2018 +0200 +++ b/backend/doc/schema/postgresql-sinfo-uinfo.sql Tue Aug 14 14:02:26 2018 +0200 @@ -457,12 +457,18 @@ vegetation_id NUMERIC(9,0) NOT NULL CONSTRAINT cVegetationZoneVegetation REFERENCES vegetation(id) ON DELETE CASCADE, vegetation_type_id NUMERIC(9,0) NOT NULL CONSTRAINT cVegetationZoneVegetationType REFERENCES vegetation_type(id) ON DELETE CASCADE, min_overflow_days NUMERIC(3,0) NOT NULL, - max_overflow_days NUMERIC(3,0) NOT NULL + max_overflow_days NUMERIC(3,0) NOT NULL, + color_r NUMERIC(3,0) NOT NULL, + color_g NUMERIC(3,0) NOT NULL, + color_b NUMERIC(3,0) NOT NULL ); COMMENT ON TABLE vegetation_zone IS 'Vegetation zone of a river station' ; COMMENT ON COLUMN vegetation_zone.min_overflow_days IS 'Minimum number (inclusive) of overflow days in a year for the zone type' ; -COMMENT ON COLUMN vegetation_zone.max_overflow_days IS 'Maximum number (exclusive) of overflow days in a year for the zone type' ; +COMMENT ON COLUMN vegetation_zone.max_overflow_days IS 'Maximum number (inclusive) of overflow days in a year for the zone type' ; +COMMENT ON COLUMN vegetation_zone.color_r IS 'Red value (0-255) of the zone color' ; +COMMENT ON COLUMN vegetation_zone.color_g IS 'Green value (0-255) of the zone color' ; +COMMENT ON COLUMN vegetation_zone.color_b IS 'Blue value (0-255) of the zone color' ; CREATE SEQUENCE VEGETATION_ZONE_ID_SEQ ;