Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-sinfo-uinfo.sql @ 9512:5c1e66a3c878
Zusammenführen
author | gernotbelger |
---|---|
date | Mon, 01 Oct 2018 12:57:10 +0200 |
parents | 056483975a9c |
children | d889ffe2fb05 |
comparison
equal
deleted
inserted
replaced
9511:73819a194bfd | 9512:5c1e66a3c878 |
---|---|
462 color_g NUMERIC(3,0) NOT NULL, | 462 color_g NUMERIC(3,0) NOT NULL, |
463 color_b NUMERIC(3,0) NOT NULL | 463 color_b NUMERIC(3,0) NOT NULL |
464 ); | 464 ); |
465 | 465 |
466 COMMENT ON TABLE vegetation_zone IS 'Vegetation zone of a river station' ; | 466 COMMENT ON TABLE vegetation_zone IS 'Vegetation zone of a river station' ; |
467 COMMENT ON COLUMN vegetation_zone.min_overflow_days IS 'Minimum number (inclusive) of overflow days in a year for the zone type' ; | 467 COMMENT ON COLUMN vegetation_zone.min_overflow_days IS 'Minimum number (exclusive) of overflow days in a year for the zone type' ; |
468 COMMENT ON COLUMN vegetation_zone.max_overflow_days IS 'Maximum number (exclusive) of overflow days in a year for the zone type' ; | 468 COMMENT ON COLUMN vegetation_zone.max_overflow_days IS 'Maximum number (inclusive) of overflow days in a year for the zone type' ; |
469 COMMENT ON COLUMN vegetation_zone.color_r IS 'Red value (0-255) of the zone color' ; | 469 COMMENT ON COLUMN vegetation_zone.color_r IS 'Red value (0-255) of the zone color' ; |
470 COMMENT ON COLUMN vegetation_zone.color_g IS 'Green value (0-255) of the zone color' ; | 470 COMMENT ON COLUMN vegetation_zone.color_g IS 'Green value (0-255) of the zone color' ; |
471 COMMENT ON COLUMN vegetation_zone.color_b IS 'Blue value (0-255) of the zone color' ; | 471 COMMENT ON COLUMN vegetation_zone.color_b IS 'Blue value (0-255) of the zone color' ; |
472 | 472 |
473 CREATE SEQUENCE VEGETATION_ZONE_ID_SEQ ; | 473 CREATE SEQUENCE VEGETATION_ZONE_ID_SEQ ; |