Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-sinfo-uinfo.sql @ 9502:69a7edd7d1e1
Comment changed for vegetation_zone.max_overflow_days
| author | mschaefer |
|---|---|
| date | Fri, 28 Sep 2018 10:02:28 +0200 |
| parents | 361de818f76e |
| children | 056483975a9c |
comparison
equal
deleted
inserted
replaced
| 9501:cb3dabb77857 | 9502:69a7edd7d1e1 |
|---|---|
| 467 color_b NUMBER(3,0) NOT NULL | 467 color_b NUMBER(3,0) NOT NULL |
| 468 ); | 468 ); |
| 469 | 469 |
| 470 COMMENT ON TABLE vegetation_zone IS 'Vegetation zone of a river station' ; | 470 COMMENT ON TABLE vegetation_zone IS 'Vegetation zone of a river station' ; |
| 471 COMMENT ON COLUMN vegetation_zone.min_overflow_days IS 'Minimum number (inclusive) of overflow days in a year for the zone type' ; | 471 COMMENT ON COLUMN vegetation_zone.min_overflow_days IS 'Minimum number (inclusive) of overflow days in a year for the zone type' ; |
| 472 COMMENT ON COLUMN vegetation_zone.max_overflow_days IS 'Maximum number (inclusive) of overflow days in a year for the zone type' ; | 472 COMMENT ON COLUMN vegetation_zone.max_overflow_days IS 'Maximum number (exclusive) of overflow days in a year for the zone type' ; |
| 473 COMMENT ON COLUMN vegetation_zone.color_r IS 'Red value (0-255) of the zone color' ; | 473 COMMENT ON COLUMN vegetation_zone.color_r IS 'Red value (0-255) of the zone color' ; |
| 474 COMMENT ON COLUMN vegetation_zone.color_g IS 'Green value (0-255) of the zone color' ; | 474 COMMENT ON COLUMN vegetation_zone.color_g IS 'Green value (0-255) of the zone color' ; |
| 475 COMMENT ON COLUMN vegetation_zone.color_b IS 'Blue value (0-255) of the zone color' ; | 475 COMMENT ON COLUMN vegetation_zone.color_b IS 'Blue value (0-255) of the zone color' ; |
| 476 | 476 |
| 477 CREATE SEQUENCE VEGETATION_ZONE_ID_SEQ ; | 477 CREATE SEQUENCE VEGETATION_ZONE_ID_SEQ ; |