Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-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 |
comparison
equal
deleted
inserted
replaced
| 9400:8e100593aec3 | 9401:361de818f76e |
|---|---|
| 459 CREATE TABLE vegetation_zone ( | 459 CREATE TABLE vegetation_zone ( |
| 460 id NUMBER(9,0) PRIMARY KEY, | 460 id NUMBER(9,0) PRIMARY KEY, |
| 461 vegetation_id NUMBER(9,0) NOT NULL CONSTRAINT cVegetationZoneVegetation REFERENCES vegetation(id) ON DELETE CASCADE, | 461 vegetation_id NUMBER(9,0) NOT NULL CONSTRAINT cVegetationZoneVegetation REFERENCES vegetation(id) ON DELETE CASCADE, |
| 462 vegetation_type_id NUMBER(9,0) NOT NULL CONSTRAINT cVegetationZoneVegetationType REFERENCES vegetation_type(id) ON DELETE CASCADE, | 462 vegetation_type_id NUMBER(9,0) NOT NULL CONSTRAINT cVegetationZoneVegetationType REFERENCES vegetation_type(id) ON DELETE CASCADE, |
| 463 min_overflow_days NUMBER(3,0) NOT NULL, | 463 min_overflow_days NUMBER(3,0) NOT NULL, |
| 464 max_overflow_days NUMBER(3,0) NOT NULL | 464 max_overflow_days NUMBER(3,0) NOT NULL, |
| 465 color_r NUMBER(3,0) NOT NULL, | |
| 466 color_g NUMBER(3,0) NOT NULL, | |
| 467 color_b NUMBER(3,0) NOT NULL | |
| 465 ); | 468 ); |
| 466 | 469 |
| 467 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' ; |
| 468 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' ; |
| 469 COMMENT ON COLUMN vegetation_zone.max_overflow_days IS 'Maximum number (exclusive) 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' ; |
| 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' ; | |
| 475 COMMENT ON COLUMN vegetation_zone.color_b IS 'Blue value (0-255) of the zone color' ; | |
| 470 | 476 |
| 471 CREATE SEQUENCE VEGETATION_ZONE_ID_SEQ ; | 477 CREATE SEQUENCE VEGETATION_ZONE_ID_SEQ ; |