Difference between revisions of "Appendix 5: Database objects/CGMS12old"

From Agri4castWiki
Jump to: navigation, search
(comment field added)
(comment header typo)
Line 45: Line 45:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|CROP_NO (crop number) || NOT NULL || NUMBER(4) || - ||
 
|CROP_NO (crop number) || NOT NULL || NUMBER(4) || - ||
Line 93: Line 93:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| RUNID (identification number of run)||NOT NULL||NUMBER(8)|| - ||
 
| RUNID (identification number of run)||NOT NULL||NUMBER(8)|| - ||
Line 142: Line 142:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8) || - ||
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8) || - ||
Line 192: Line 192:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||-||NUMBER(10,0)|| - ||
 
| CROP_NO (crop number)||-||NUMBER(10,0)|| - ||
Line 222: Line 222:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
Line 323: Line 323:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8) || - ||
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8) || - ||
Line 347: Line 347:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| REG_MAP_ID (region mapping id)||NOT NULL||NUMBER                || - ||
 
| REG_MAP_ID (region mapping id)||NOT NULL||NUMBER                || - ||
Line 393: Line 393:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| REG_MAP_ID (agro-environmental region id)||NOT NULL||NUMBER(10)|| - ||
 
| REG_MAP_ID (agro-environmental region id)||NOT NULL||NUMBER(10)|| - ||
Line 447: Line 447:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| REG_MAP_ID (region mapping id)||-||NUMBER(10,0)        || - ||
 
| REG_MAP_ID (region mapping id)||-||NUMBER(10,0)        || - ||
Line 483: Line 483:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| DT_MUTATION||-||DATE      || - ||
 
| DT_MUTATION||-||DATE      || - ||
Line 696: Line 696:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO* (crop number)||-||NUMBER(10,0)|| - ||
 
| CROP_NO* (crop number)||-||NUMBER(10,0)|| - ||
Line 771: Line 771:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|CROPGROUP_NO (group where crop belongs to) || NOT NULL || NUMBER(2) || - ||
 
|CROPGROUP_NO (group where crop belongs to) || NOT NULL || NUMBER(2) || - ||
Line 790: Line 790:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|CROP_NO || NOT NULL || NUMBER(8) || - ||
 
|CROP_NO || NOT NULL || NUMBER(8) || - ||
Line 820: Line 820:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 844: Line 844:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 905: Line 905:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| YEAR||NOT NULL||NUMBER(4)|| - ||
 
| YEAR||NOT NULL||NUMBER(4)|| - ||
Line 938: Line 938:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| DAY||-||DATE||
 
| DAY||-||DATE||
Line 977: Line 977:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| DAY||-||DATE||
 
| DAY||-||DATE||
Line 1,001: Line 1,001:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|GRID_NO (grid number) || NOT NULL || NUMBER || - ||
 
|GRID_NO (grid number) || NOT NULL || NUMBER || - ||
Line 1,038: Line 1,038:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8) || - ||
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8) || - ||
Line 1,060: Line 1,060:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| RUN_ID||NOT NULL||NUMBER|| - ||
 
| RUN_ID||NOT NULL||NUMBER|| - ||
Line 1,083: Line 1,083:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
Line 1,117: Line 1,117:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|GRID_NO (OPE grid no) || NOT NULL || NUMBER(38,0) || - ||
 
|GRID_NO (OPE grid no) || NOT NULL || NUMBER(38,0) || - ||
Line 1,222: Line 1,222:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 1,281: Line 1,281:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8) || - ||
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8) || - ||
Line 1,314: Line 1,314:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number, equal to CROP_NO in CROP table)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number, equal to CROP_NO in CROP table)||NOT NULL||NUMBER(4)|| - ||
Line 1,336: Line 1,336:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
Line 1,360: Line 1,360:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
Line 1,384: Line 1,384:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
Line 1,410: Line 1,410:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
Line 1,434: Line 1,434:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
Line 1,454: Line 1,454:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
Line 1,476: Line 1,476:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 1,535: Line 1,535:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 1,720: Line 1,720:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 1,905: Line 1,905:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| SESSION_ID ||-||VARCHAR2(30 BYTE) ||
 
| SESSION_ID ||-||VARCHAR2(30 BYTE) ||
Line 1,933: Line 1,933:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| RUN_ID (unique identifier)||NOT NULL||NUMBER|| - ||
 
| RUN_ID (unique identifier)||NOT NULL||NUMBER|| - ||
Line 1,953: Line 1,953:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| RUN_ID||NOT NULL||NUMBER|| - ||
 
| RUN_ID||NOT NULL||NUMBER|| - ||
Line 1,981: Line 1,981:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| RUN_ID (unique identifier)||NOT NULL||NUMBER|| - ||
 
| RUN_ID (unique identifier)||NOT NULL||NUMBER|| - ||
Line 2,033: Line 2,033:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| RUN_ID||NOT NULL||NUMBER|| - ||
 
| RUN_ID||NOT NULL||NUMBER|| - ||
Line 2,081: Line 2,081:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| RUN_ID||NOT NULL||NUMBER|| - ||
 
| RUN_ID||NOT NULL||NUMBER|| - ||
Line 2,103: Line 2,103:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| RUN_ID||NOT NULL||NUMBER|| - ||
 
| RUN_ID||NOT NULL||NUMBER|| - ||
Line 2,137: Line 2,137:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 2,195: Line 2,195:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|PARAMETER_CODE (character code of crop parameter) || NOT NULL || VARCHAR2(20) || - ||
 
|PARAMETER_CODE (character code of crop parameter) || NOT NULL || VARCHAR2(20) || - ||
Line 2,217: Line 2,217:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER (station number)||NOT NULL||NUMBER(7)|| - ||
 
| STATION_NUMBER (station number)||NOT NULL||NUMBER(7)|| - ||
Line 2,241: Line 2,241:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
Line 2,273: Line 2,273:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER||NOT NULL||NUMBER(7,0)|| - ||
 
| STATION_NUMBER||NOT NULL||NUMBER(7,0)|| - ||
Line 2,296: Line 2,296:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| REG_MAP_ID (unique id for region)||NOT NULL||NUMBER|| - ||
 
| REG_MAP_ID (unique id for region)||NOT NULL||NUMBER|| - ||
Line 2,331: Line 2,331:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| REG_MAP_ID (region mapping id)||NOT NULL||NUMBER                || - ||
 
| REG_MAP_ID (region mapping id)||NOT NULL||NUMBER                || - ||
Line 2,385: Line 2,385:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CLASS (rooting depth class)||NOT NULL||NUMBER(5)|| - ||
 
| CLASS (rooting depth class)||NOT NULL||NUMBER(5)|| - ||
Line 2,405: Line 2,405:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| RUN_ID||NOT NULL||NUMBER|| - ||
 
| RUN_ID||NOT NULL||NUMBER|| - ||
Line 2,435: Line 2,435:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| YEAR||NOT NULL||NUMBER(4)|| - ||
 
| YEAR||NOT NULL||NUMBER(4)|| - ||
Line 2,489: Line 2,489:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 2,511: Line 2,511:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| MEMBER_NO* (member number)||NOT NULL||NUMBER(2)|| - ||
 
| MEMBER_NO* (member number)||NOT NULL||NUMBER(2)|| - ||
Line 2,570: Line 2,570:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 2,626: Line 2,626:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 2,682: Line 2,682:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| MEMBER_NO* (member number)||NOT NULL||NUMBER(2)|| - ||
 
| MEMBER_NO* (member number)||NOT NULL||NUMBER(2)|| - ||
Line 2,739: Line 2,739:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 2,793: Line 2,793:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 2,975: Line 2,975:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 3,031: Line 3,031:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 3,213: Line 3,213:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 3,395: Line 3,395:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 3,449: Line 3,449:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 3,631: Line 3,631:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| IFUNRN (infiltration rate depends on storm size. 0=no, 1 = yes)||-||NUMBER(1)|| - ||
 
| IFUNRN (infiltration rate depends on storm size. 0=no, 1 = yes)||-||NUMBER(1)|| - ||
Line 3,652: Line 3,652:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| SMU_NO (soil mapping unit number)||NOT NULL||NUMBER(8)|| - ||
 
| SMU_NO (soil mapping unit number)||NOT NULL||NUMBER(8)|| - ||
Line 3,674: Line 3,674:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|SMU_NO (soil mapping unit number) || NOT NULL || NUMBER(8) || - ||
 
|SMU_NO (soil mapping unit number) || NOT NULL || NUMBER(8) || - ||
Line 3,696: Line 3,696:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|SMU_NO (soil mapping unit number) || NOT NULL || NUMBER(8) || - ||
 
|SMU_NO (soil mapping unit number) || NOT NULL || NUMBER(8) || - ||
Line 3,717: Line 3,717:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|SOIL_GROUP_NO (soil physical group number) || NOT NULL || NUMBER(3) || - ||
 
|SOIL_GROUP_NO (soil physical group number) || NOT NULL || NUMBER(3) || - ||
Line 3,741: Line 3,741:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|STU_NO (soil typologic unit number) || NOT NULL|| NUMBER(8) || - ||
 
|STU_NO (soil typologic unit number) || NOT NULL|| NUMBER(8) || - ||
Line 3,787: Line 3,787:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STAT_CROP_NO||NOT NULL||NUMBER(4)|| - ||
 
| STAT_CROP_NO||NOT NULL||NUMBER(4)|| - ||
Line 3,815: Line 3,815:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STAT_CROP_NO (statistic crop number)||NOT NULL||NUMBER(4)|| - ||
 
| STAT_CROP_NO (statistic crop number)||NOT NULL||NUMBER(4)|| - ||
Line 3,843: Line 3,843:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
Line 3,913: Line 3,913:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
Line 3,965: Line 3,965:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| LATITUDE||NOT NULL||NUMBER|| - ||
 
| LATITUDE||NOT NULL||NUMBER|| - ||
Line 4,001: Line 4,001:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STU_NO||NOT NULL||NUMBER(8)|| - ||
 
| STU_NO||NOT NULL||NUMBER(8)|| - ||
Line 4,025: Line 4,025:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|CROPGROUP_NO (group where crop belongs to) || NOT NULL || NUMBER(2) || - ||
 
|CROPGROUP_NO (group where crop belongs to) || NOT NULL || NUMBER(2) || - ||
Line 4,045: Line 4,045:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| WMO_NO (station number)||-||NUMBER(7)|| - ||
 
| WMO_NO (station number)||-||NUMBER(7)|| - ||
Line 4,076: Line 4,076:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NAME (dummy name)||NOT NULL||VARCHAR2|| - ||
 
| STATION_NAME (dummy name)||NOT NULL||VARCHAR2|| - ||
Line 4,114: Line 4,114:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|CROP_NO (crop number) || NOT NULL || NUMBER(38,0) || - ||
 
|CROP_NO (crop number) || NOT NULL || NUMBER(38,0) || - ||
Line 4,170: Line 4,170:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|SNAME (name of variable) || NOT NULL || VARCHAR2(30) || - ||
 
|SNAME (name of variable) || NOT NULL || VARCHAR2(30) || - ||
Line 4,189: Line 4,189:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| TABLE_NAME||NOT NULL||VARCHAR2(31)|| - ||
 
| TABLE_NAME||NOT NULL||VARCHAR2(31)|| - ||
Line 4,209: Line 4,209:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| TASK_ID||NOT NULL||NUMBER(8)|| - ||
 
| TASK_ID||NOT NULL||NUMBER(8)|| - ||
Line 4,243: Line 4,243:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
 
| CROP_NO (crop number)||NOT NULL||NUMBER(4)|| - ||
Line 4,270: Line 4,270:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| REQUEST_ID||NOT NULL||NUMBER|| - ||
 
| REQUEST_ID||NOT NULL||NUMBER|| - ||
Line 4,301: Line 4,301:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|GRID_NO (grid number) || NOT NULL || NUMBER || - ||
 
|GRID_NO (grid number) || NOT NULL || NUMBER || - ||
Line 4,389: Line 4,389:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|REG_MAP_ID (administrative region id) || NOT NULL || NUMBER || - ||
 
|REG_MAP_ID (administrative region id) || NOT NULL || NUMBER || - ||
Line 4,481: Line 4,481:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|REG_MAP_ID (agri-environmental region id) || NOT NULL || NUMBER || - ||
 
|REG_MAP_ID (agri-environmental region id) || NOT NULL || NUMBER || - ||
Line 4,574: Line 4,574:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|REG_MAP_ID (agro-environmental region id) || NOT NULL || NUMBER(10,0) || - ||
 
|REG_MAP_ID (agro-environmental region id) || NOT NULL || NUMBER(10,0) || - ||
Line 4,673: Line 4,673:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|GRID_NO (grid number) || NOT NULL || NUMBER || - ||
 
|GRID_NO (grid number) || NOT NULL || NUMBER || - ||
Line 4,726: Line 4,726:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|GRID_NO (grid number) || NOT NULL || NUMBER || - ||
 
|GRID_NO (grid number) || NOT NULL || NUMBER || - ||
Line 4,771: Line 4,771:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|REG_MAP_ID (administrative region id) || NOT NULL || NUMBER(10,0) || - ||
 
|REG_MAP_ID (administrative region id) || NOT NULL || NUMBER(10,0) || - ||
Line 4,869: Line 4,869:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| REG_MAP_ID (agro-environmental region id)||NOT NULL||NUMBER(10)|| - ||
 
| REG_MAP_ID (agro-environmental region id)||NOT NULL||NUMBER(10)|| - ||
Line 4,956: Line 4,956:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| REG_MAP_ID (agri-environmental region id)||NOT NULL||NUMBER(10)|| - ||
 
| REG_MAP_ID (agri-environmental region id)||NOT NULL||NUMBER(10)|| - ||
Line 5,131: Line 5,131:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
Line 5,182: Line 5,182:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
Line 5,211: Line 5,211:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
 
| GRID_NO (grid number)||NOT NULL||NUMBER(8)|| - ||
Line 5,384: Line 5,384:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| REG_MAP_ID (administrative region id)||NOT NULL||NUMBER(10,0)|| - ||
 
| REG_MAP_ID (administrative region id)||NOT NULL||NUMBER(10,0)|| - ||
Line 5,414: Line 5,414:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| REG_MAP_ID (administrative region id)||NOT NULL||NUMBER(10)|| - ||
 
| REG_MAP_ID (administrative region id)||NOT NULL||NUMBER(10)|| - ||
Line 5,501: Line 5,501:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| REG_MAP_ID (administrative region id)||NOT NULL||NUMBER(10)|| - ||
 
| REG_MAP_ID (administrative region id)||NOT NULL||NUMBER(10)|| - ||
Line 5,677: Line 5,677:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER (station number)||NOT NULL||NUMBER(7)|| - ||
 
| STATION_NUMBER (station number)||NOT NULL||NUMBER(7)|| - ||
Line 5,761: Line 5,761:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| YEAR (historic year)||NOT NULL||NUMBER(4,0)|| - ||
 
| YEAR (historic year)||NOT NULL||NUMBER(4,0)|| - ||
Line 5,783: Line 5,783:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|STATION_NUMBER (station number) || NOT NULL || NUMBER(7,0) || - ||
 
|STATION_NUMBER (station number) || NOT NULL || NUMBER(7,0) || - ||
Line 5,811: Line 5,811:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
Line 5,835: Line 5,835:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
 
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
Line 5,915: Line 5,915:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER (station number)||NOT NULL||NUMBER(7)|| - ||
 
| STATION_NUMBER (station number)||NOT NULL||NUMBER(7)|| - ||
Line 6,002: Line 6,002:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER||NOT NULL||NUMBER(7,0)|| - ||
 
| STATION_NUMBER||NOT NULL||NUMBER(7,0)|| - ||
Line 6,042: Line 6,042:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| STATION_NUMBER||NOT NULL||NUMBER(7,0)|| - ||
 
| STATION_NUMBER||NOT NULL||NUMBER(7,0)|| - ||
Line 6,184: Line 6,184:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
| WMO_NO||-||NUMBER(5)|| - ||
 
| WMO_NO||-||NUMBER(5)|| - ||
Line 6,224: Line 6,224:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|GRID_NO (grid number) || NOT NULL || NUMBER(38,0) || - ||
 
|GRID_NO (grid number) || NOT NULL || NUMBER(38,0) || - ||
Line 6,264: Line 6,264:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|WMO_NO (station number) || NOT NULL || NUMBER(38,0) || - ||
 
|WMO_NO (station number) || NOT NULL || NUMBER(38,0) || - ||
Line 6,304: Line 6,304:
  
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|DAY (day in month (1-31)) || - || NUMBER || - ||
 
|DAY (day in month (1-31)) || - || NUMBER || - ||
Line 6,326: Line 6,326:
 
|
 
|
 
{|class="wikitable"
 
{|class="wikitable"
!Attribute !! Contraint !! Type !! Unit || comment
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8,0) || - ||
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8,0) || - ||

Revision as of 14:26, 7 March 2016



AEZ


AGGREGATION_AREAS

  • Description: cultivated areas per region used for spatial aggregation of crop indicators
  • Use: used for weighting during aggregating crop indicators towards regional crop indicators
  • Type: Permanent table
  • Remarks: none


CGMS_SYSLOG

  • Description: logging of run options.
  • Use: output table containing information on the run executed
  • Type: Permanent table
  • Remarks: none


CMETEO_ADMIN

  • Description: synonym to oracle package
  • Use:
  • Type: synonym on mrsman.cmeteo_admin
  • Remarks: none


CMETEO_AEZ_GRID_LANDCOVERS

  • Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
  • Use: input for cmeteo with standardized attribute names
  • Type: view on LINK_ AEZ_GRID_LANDCOVER
  • Remarks: user defined, derived from GIS


CMETEO_AGGREGATION_AREAS

  • Description: cultivated areas per region used for spatial aggregation of crop indicators
  • Use: input for cmeteo, converting names of columns for use in cmeteo package
  • Type: view on tables AGGREGATION_AREAS and REGION
  • Remarks: none


CMETEO_CROPS

  • Description: description of crops. Crop name, number, associated crop group and general month.
  • Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
  • Type: synonym on table mrsman.cmeteo_crops
  • Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.


CMETEO_GRID_LANDCOVER_AREAS

  • Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
  • Use: input for cmeteo with standardized attribute names
  • Type: synonym on view CMETEO_AEZ_GRID_LANDCOVERS
  • Remarks: none


CMETEO_GRID_WEATHER

  • Description: weather indicators per grid
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: synonym on view CMETEO_WEATHER_OBS_GRID


CMETEO_LANDCOVERS

  • List of landcovers or crops to be evaluated in CMETEO
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: synonym on FORALL.CMETEO_LAND_COVERS_EU / CROP_LANDCOVER


CMETEO_PROCESS

  • Description: synonym to oracle package
  • Use:
  • Type: synonym on mrsman.cmeteo_process
  • Remarks: none


CMETEO_REGION_GRID_LANDCOVERS

  • Description: landcover areas for each intersection of grid and administartive region (only level 3).
  • Use: input for cmeteo with standardized attribute names
  • Type: view on LINK_REGION_GRID_LANDCOVER
  • Remarks: user defined, derived from GIS


CMETEO_REGION_MAPPINGS

  • Description: regions and their relations (mappings)
  • Use: input for cmeteo
  • Type: synonym on table REGION_MAPPINGS
  • Remark: none


CMETEO_REGION_WEATHER

  • Description: weather indicators per region
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: synonym on view CMETEO_WEATHER_OBS_AEZ
  • Remark: none


CMETEO_REGIONS

  • Description:
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: synonym on mrsman.cmeteo_regions
  • Remark: none


CMETEO_REJECTED_WEATHER

  • Description: rejected weather
  • Use: log table for cmeteo
  • Type: synonym on mrsman.cmeteo_rejected_weather
  • Remark: none


CMETEO_WEATHER_OBS_AEZ

  • Description: weather indicators per agri-environmental region
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: view on WEATHER_OBS_AEZ


CMETEO_WEATHER_OBS_GRID

  • Description: weather indicators per grid
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: view on table WEATHER_OBS_GRID


CMETEO_WEATHER_OBS_REGION

  • Description: weather indicators per region
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: view on WEATHER_OBS_REGION


CROP

  • Description: description of crops. Crop name, number, associated crop group and general month.
  • Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
  • Type: view on from forall.crop_landcover (subset of FORALL.CROP_LANDCOVER table).
  • Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.


CROP_CALENDAR

  • Description: where and when crops are grown. crop, crop variety and growing season per grid.
  • Use: determines which crops are simulated for a grid, and simulation period
  • Type: Permanent table
  • Remarks: user defined, one of the ‘driving’ tables of the system ||


CROP_GROUP

  • Description: description of crop groups
  • Use: input table for the crop group number and name where crop belongs to
  • Type: synonym on permanent table FORALL.CROP_GROUP
  • Remarks: none


CROP_LANDCOVER

  • List of crop and landcovers
  • Use: source for various views & synonyms
  • Type: synonym & table


CROP_PARAMETER_VALUE

  • Description: values of crop parameters. Crop characteristics as understood by WOFOST and LINGRA
  • Use: input table for the crop simulation process
  • Type: Permanent table
  • Remarks: In case of single parameters PARAMETER_XVALUE gives the value. In case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE.


CROP_YIELD

  • Description:
  • Use: used as interface between the CGMS12EU database and the viewers
  • Type: view on table SIMYIELD_EMU
  • Remarks:


DATA_FOR_YIELD_FORECAST

  • Description: Indicator values per indicator, for each combination of administrative region (nuts_code), year, decade and statistical crop (stat_crop_no).
  • Use: table for storing the indicators values that can be used for regression and scenario-analysis (see Yield Forecasting).
  • Type: Permanent table.
  • Remarks: The table is filled and regularly updated with indicator values from table SIMYIELD_REGION. The table contains the same data as stored in SIMYIELD_REGION, but in a different structure. This way also new indicators can be added without having to change the structure.


DATE_GENERATOR

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: synonym on forall.date_generator
  • Remarks: none


DATES_75_15

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: synonym on forall.dates_75_15
  • Remarks: none


DAY_DECADEYEAR

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: synonym on FORALL.DAY_DECADEYEAR
  • Remarks: none



GRID_<MODEL>

  • Description: latitude, longitude and altitude of A regular ECMWF grid before downscaling.
  • Use: input for downscaling.
  • Type: Permanent table
  • Remarks: Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name. The calculation resolution of ECMWF models changes over time and/or forecast depth. In that case different derived elevation models are used stored in separate altitude Attributes with a reference to the ECMWF calculation resolution.



EMU

  • Description: the intersection of the soil map and the grid
  • Use: input/reference table for the crop simulation process
  • Type: Permanent table
  • Remarks: user defined, derived from GIS, provides the link to the GIS


FOREYIELD_HIS_REGION

  • Description: End of season forecast
  • Use: to store forecast results from the CST operational batch mode.
  • Type: Permanent table
  • Remarks: Not used by the user interface and regular batch mode of the CST that stores the forecast in table FORECASTED_NUTS_YIELD.


GRID

  • Description: The grid is used for two purposes. Firstly it is used to describe the area for which the meteorological data is assumed to be homogeneous. Secondly, a so-called ‘crop-calendar’ is associated with each grid square that defines certain crop specific parameters, and defines if a crop has to be simulated for this grid. The parameters describe the growing season for a crop in a grid square, and make it possible to take geographic differences in the growing season into account.
  • Use: input/reference table for both level 1 and level 2
  • Type: permanent table
  • Remarks: user defined, derived from GIS, provides the link to the GIS



GRID_SEA_DOWN_ALGORITHMS

  • Description: grid specific downscaling equations per OPE grid cell.
  • Use: Downscaling SEA model data.
  • Type: Permanent table
  • Remarks: A similar table exists for the ERA model data. That table is called CGMS_GRID_METH_C.



GRID_YIELD

  • Description:
  • Use: used as interface between the CGMS12EU database and the viewers
  • Type: view on table SIMYIELD_GRID
  • Remarks:


INITIAL_SOIL_WATER

  • Description: contains the initial soil moisture content per grid, stu_no, crop_no and calendar year
  • Use: input for level 2
  • Type: Permanent table
  • Remarks: user defined


JSOW

  • Description: Long term average sowing data per crop for calculating 'rainfall around sowing'.
  • Use: Input table for calculating one of the Crop Simulation indicators.
  • Type: Permanent table, provided by JRC.
  • Remark: Even if the table CROP_CALENDAR specifies fixed sowing per crop per year, the JSOW table is used to calculate 'rainfall around sowing'.


LINK_AEZ_GRID_LANDCOVER

  • Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
  • Use: input for cmeteo
  • Type: Permanent table
  • Remarks: user defined, derived from GIS


LINK_EMU_REGION

  • Description: intersection of grid, administrative regions and soil mapping units, and their area.
  • Use: input/reference table for the crop simulation process
  • Type: Permanent table
  • Remarks:


LINK_EMU_REGION_LANDCOVER

  • Description: intersection of grid, administrative regions and soil mapping units, and the cropping area per crop or landcover type.
  • Use: input/reference table for the crop simulation process
  • Type: Permanent table
  • Remarks:


LINK_REGION_GRID_LANDCOVER

  • Description: landcover areas for each intersection of grid and NUTS region (only level 3).
  • Use: input for cmeteo
  • Type: Permanent table
  • Remarks: user defined, derived from GIS


LINK_STATION_GRID

  • Description:
  • Use:
  • Type: Permanent table
  • Remarks:


LINK_STATION_REGION

  • Description:
  • Use:
  • Type: Permanent table
  • Remarks:


LTA_CROP_YIELDS

  • Description:
  • Use: interface between the CGMS12EU database and the LTA_YIELD package
  • Type: view on table SIMYIELD_EMU_LTA
  • Remarks:


LTA_GRID_YIELDS

  • Description:
  • Use: interface between the CGMS12EU database and the LTA_YIELD package
  • Type: view on table SIMYIELD_GRID_LTA
  • Remarks:


LTA_NUTS_YIELDS


LTA_YIELD_REGIONS

  • Description: synonym to oracle package
  • Use: table for LTA_YIELD package
  • Type: synonym on mrsman.lta_yield_regions
  • Remarks: none


LTA_YIELD

  • Description: synonym to oracle package
  • Use: link to LTA_YIELD package
  • Type: synonym on mrsman.lta_yield
  • Remarks: none


MODEL_EXCL_YEARS

  • Description: By default the years for which no statistical observations are available. But also outliers could be excluded.
  • Use: Output of level 3.
  • Type: permanent table.
  • Remarks: To be able to (re)derive the regression models, the excluded years need to be known.


MODEL_INCL_INDICATORS

  • Description: Indicators that are included in the regression model.
  • Use: Output of level 3.
  • Type: permanent table.
  • Remarks: To be able to (re)derive the regression models, the included indicators need to be known.


MODEL_REGR_INDICATIFS

  • Description: The table stores the models:
  • Use: Output and input of level 3. In operational mode, this table is used to retrieve the models for calculating the forcasted yield.
  • Type: permanent table.
  • Remarks:


MODEL_SCEN_INDICATIFS

  • Description:
  • Use:
  • Type: permanent table.
  • Remarks:


MODEL_SCEN_SIM_YEARS

  • Description:
  • Use:
  • Type: permanent table.
  • Remarks:


MODEL_SETTINGS

  • Description:
  • Use:
  • Type: permanent table.
  • Remarks:


MONTHDAYTODECADE

  • Description: synonym to oracle package
  • Use: Conversion of day and month to a decade (dutch: 10-daagse periode)
  • Type: synonym on forall.monthday2decade
  • Remarks:
Both month and day must be numeric: month {1..12}, day {1..31}.
No check is performed on valid COMBINATIONS of month and day
If one or both parameters seem invalid then a null-value will be returned


NUTS_YIELD

  • Description:
  • Use: used as interface between the CGMS12EU database and the viewers
  • Type: view on table SIMYIELD_REGION
  • Remarks:

PARAMETER_DESCRIPTION

  • Description: describes the use and the type of parameter in crop_parameter_value and variety_parameter_value tables
  • Use: used during system initialisation to correctly interpret the parameter tables
  • Type: permanent table
  • Remarks: do not change this table


RAIN_OBS_STATION

  • Description: contains the station based 6-hourly rainfall data
  • Use: input level 1
  • Type: permanent table
  • Remarks: none


RAIN_OBS_STATION_INFO

  • Description: table for storing specific metadata for 6-hourly rainfall data (flags)
  • Use: meta data
  • Type: permanent table
  • Remarks: none


RAIN_OBS_STATION_RAW

  • Description: temporary storage before inserting data into RAIN_OBS_STATION(_INFO)
  • Use: input level 1
  • Type: permanent table
  • Remarks: none


REGION

  • Description: Administrative regions
  • Use: input for monitoring extreme weather events
  • Type: Synonym on view FORALL.REGIONS_EUR12EU which references the FORALL tables REGION_DESCRIPTIONS and REGION_MAPPINGS


REGION_MAPPINGS

  • Description: regions and their relations (mappings)
  • Use: used by many object to find relation between regions of different levels.
  • Type: synonyms on forall.region_mappings_eur
  • Remarks: none


REGLISTS

  • Description: synonym to oracle package
  • Use: link to REGLISTS
  • Type: synonym on forall.reglists
  • Remarks: none


ROOTING_DEPTH

  • Description: the rooting depth classes and associated rooting depth limits
  • Use: reference table used in crop simulation
  • Type: permanent table
  • Remarks: part of the soil model, can be changed or extended if necessary


RUN

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:


SIMULATION_LOG

  • Description: contains information about simulation
  • Use: reference table
  • Type: permanent table
  • Remarks: none


SIMULATION_UNIT

  • Description: contains the unique combinations of grid number and soil typologic unit for each crop to be simulated.
  • Use: lookup table used during crop simulation
  • Type: permanent table
  • Remarks: the content of this table is based on the intersection of soil map and climatic grid, excluding intersections (STU's) that are unsuitable for crop growth.


SIMYIELD_<MODEL>_EMU

  • Description: results of the crop simulation per emu. Level 2 output based on forecast weather
  • Use: output table for the crop simulation process
  • Type: Permanent table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_EMU

  • Description: results of the crop simulation per emu. Level 2 output based on weather observations
  • Use: output table for the crop simulation process
  • Type: Permanent table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_EMU_LTA

  • Description: Long term average results of the crop simulation per emu. Level 2 output based on weather observations.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_<MODEL>_GRID

  • Description: results of the crop simulation per grid. Level 2 output, based on forecast weather.
  • Use: output table for the crop simulation process
  • Type: Permanent table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_GRID

  • Description: results of the crop simulation per grid. Level 2 output, based observed weather.
  • Use: output table for the crop simulation process
  • Type: Permanent table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_GRID_LTA

  • Description: Long term average results of the crop simulation per grid. Level 2 output based on weather observations.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_HIS_EMU_LTA

  • Description: Long term average results of the crop simulation per emu. Level 2 output based on forecast weather.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_HIS_GRID_LTA

  • Description: Long term average results of the crop simulation per grid. Level 2 output based on forecast weather.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_HIS_REGION_LTA

  • Description: Long term average results of the crop simulation per administrative region. Level 2 output based on forecast weather.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_REGION

  • Description: results of the crop simulation per administrative region. Level 2 output
  • Use: output table for the crop simulation process
  • Type: Permanent table
  • Remarks: This table contains aggregated simulation results for all CROP_NO's in STAT_CROP.


SIMYIELD_REGION_LTA

  • Description: Long term average results of the crop simulation per administrative region. Level 2 output based on weather observations.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SITE

  • Description: Contains some soil model parameters on a system wide basis
  • Use: input table for the crop simulation process
  • Type: permanent table
  • Remarks: supplied by the user, but rarely changed

SMU_SUITABILITY

  • Description: a derived table containing the sum of the suitable area for a SMU for a particular crop _ group
  • Use: used during the aggregation from the simulation unit results to the emu results (to derive the simulation_unit table)
  • Type: permanent table
  • Remarks: this table needs to be recalculated whenever the simulation_unit table changes


SOIL_ASSOCIATION_COMPOSITION

  • Description: described the percentage area for each STU in each SMU. It is assumed that it therefore also describes the percentage area for each STU in each EMU.
  • Use: used to calculate the weighing factor to be applied to the SIMULATION_UNIT results
  • Type: permanent table
  • Remarks: derived from the soil map


SOIL_MAPPING_UNIT

  • Description: listing of unique soil mapping units and related countries
  • Use: used by the crop growth model
  • Type: permanent table
  • Remarks: user defined, derived from the soil map

* not filled/used

SOIL_PHYSICAL_GROUP

  • Description: contains the physical parameters describing the soil groups used by the crop growth model. Mainly describes the soil water model.
  • Use: used by the crop growth model
  • Type: permanent table
  • Remarks: user defined, derived from the soil map


SOIL_TYPOLOGIC_UNIT

  • Description: the rooting depth ( rd ) and soil physical group ( spg ) combination associated with every stu
  • Use: used by the crop growth model
  • Type: permanent table
  • Remarks: user defined, derived from the soil map


STAT_CROP

  • Description:
  • Use:
  • Type: Permanent table
  • Remarks:


STAT_REGION

  • Description: official observed cultivated area and yield
  • Use: to derive regression models in Yield Forecasting module
  • Type: Permanent table
  • Remarks: none


STATION

  • Description: the weather stations and weather station characteristics to be used by the system ||
  • Use: used by all of the level 1 steps (additional weather, availability, grid weather)
  • Type: permanent table
  • Remarks: when changing this table, Reference_Weather and Supit_Constants may have to be updated


STATIONS_PER_GRID

  • Description: the stations used for the grid weather interpolation of the historic year.
  • Use: output table for the level 1 grid weather calculation
  • Type: permanent table
  • Remarks: contains both information produced by historical interpolation and current year interpolation.


STATION_REFERENCE_COEFFICIENTS

  • Description: contains calculated regression constants for selected weather stations covering a large part of Europe
  • Use: is used by view SUPIT_REFERENCE_STATIONS
  • Type: permanent table
  • Remarks: none


STU_LAYER

  • Description:
  • Use:
  • Type: Permanent table
  • Remarks:


SUITABILITY

  • Description: the suitable STUs for each crop _ group
  • Use: used to derive the simulation_unit table
  • Type: Permanent table
  • Remarks: user defined, derived from the soil map


SUPIT_CONSTANTS

  • Description: the regression constants per weather station used for the estimation of global radiation for the station
  • Use: support table program SupitConstant; results are copied to table STATION
  • Type: permanent table
  • Remarks: populated by program SupitConstant (recalculate this table when new stations are added to the weather_station table or when table new supit_reference_stations is updated table)

SUPIT_REFERENCE_STATIONS

  • Description: contains calculated regression constants for selected weather stations covering a large part of Europe.
  • Use: used by SupitConstants to derive the regression constants for all weather stations (and listed in the weather_station table).
  • Type: view on table station_reference_coefficients
  • Remarks: not normally changed by the user but supplied by the JRC


SYE

  • Description: table for storing temporary results during Crop_Simulation. When the calculation is finshed, all records are inserted into SIMYIELD_EMU overwriting old results.
  • Use: temporary output table for the calculation of crop indicators.
  • Type: Permanent table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.


SYSCON

  • Description: contains system parameters
  • Use: upon system initialisation
  • Type: permanent table
  • Remarks: user defined

SYSTABLES

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:


TASKS

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:


VARIETY_PARAMETER_VALUE

  • Description: values of variety parameters. Crop characteristics as understood by WOFOST and LINGRA
  • Use: input table for the crop simulation process
  • Type: permanent table
  • Remarks: user defined. To express the deviation of a variety from the main crop parameters (stored in CROP_PARAMETER_VALUE table). In case of single parameters PARAMETER_XVALUE gives the value. In case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE.


VIEWER_REQUESTS

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:



WEATHER_HIS_GRID_LTA

  • Description: long term average forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: Long term average is only available for the HIS model (see forecasted weather).


WEATHER_HIS_REGION_LTA

  • Description: long term average forecasted weather per day and administrative region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: Long term average is only available for the HIS model (see forecasted weather).


WEATHER_HIS_AEZ_LTA

  • Description: long term average forecasted weather per day and agri-environmental region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: Long term average is only available for the HIS model (see forecasted weather).



WEATHER_<MODEL>_AEZ

  • Description: forecasted weather per day and agro-environmental region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS) to get the table name. ERA, MON and SEA are not available for agro-environmental regions



WEATHER_<MODEL>_GRID

  • Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: input for crop simulation.
  • Type: Permanent table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.



WEATHER_<MODEL>_GRID_RAW

  • Description: forecasted weather per day and grid point in WGS84 geographic coordinate system.
  • Use: input for downscalling procedure (output to WEATHER_<MODEL>_GRID).
  • Type: Permanent table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.



WEATHER_<MODEL>_REGION

  • Description: forecasted weather per day and administrative region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS) to get the table name. MON and SEA are not available for administrative regions



WEATHER_OBS_AEZ

  • Description: interpolated weather data per grid per agro-environmental egion
  • Use: input for monitoring extreme weather events
  • Type: Permanent table


WEATHER_OBS_AEZ_LTA

  • Description: long term average interpolated weather data per agri-environmental region per day
  • Use: Monitoring extreme weather events
  • Type: Permanent table


WEATHER_OBS_GRID

  • Description: interpolated weather data per grid per day
  • Use: output for level 1, input for level 2
  • Type: Permanent table


WEATHER_OBS_GRID_INFO

  • Description:
  • Use:
  • Type: Permanent table


WEATHER_OBS_GRID_LTA

  • Description: long term average interpolated weather data per grid cell per day
  • Use: Monitoring extreme weather events
  • Type: Permanent table


WEATHER_OBS_GRID_LTA_MISS

  • Description: long term average number of grid cells per country.
  • Use: input for check on WEATHER_OBS_GRID table (see section Check on missing grid weather).
  • Type: permanent table
  • Remarks: filled with procedure lta_missing_grid_weather.sql


WEATHER_OBS_REGION

  • Description: interpolated weather data per grid per administrative region
  • Use: input for monitoring extreme weather events
  • Type: Permanent table


WEATHER_OBS_REGION_LTA

  • Description: long term average interpolated weather data per administrative region per day
  • Use: Monitoring extreme weather events
  • Type: Permanent table


WEATHER_OBS_STATION

  • Description: contains the station based daily meteorological data
  • Use: input for level 1
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_AVAIL

  • Description: available weather stations for interpolation per station and per year.
  • Use: output of the weather data availability calculation, used by the grid weather interpolation
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_CALCULATED

  • Description: daily weather derived from other variables. Calculated/estimated potential evaporation and global radiation per station.
  • Use: output table for additional weather calculation, input for grid weather
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_ERRAIN

  • Description: contains deleted wrongly rain records of the station based daily meteorological data
  • Use: archive reasons
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_ERRORS

  • Description: contains deleted wrongly weather records of the station based daily meteorological data
  • Use: archive reasons
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_INFO

  • Description: table for storing specific metadata on daily weather data (flags)
  • Use: meta data
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_LTA

  • Description: contains the long term average weather data per station per day
  • Use: substitute data in case of missing data during level 1 processing
  • Type: permanent table
  • Remarks: filled by software tool ReferenceWeather


WEATHER_OBS_STATION_RAW

  • Description: temporary storage before inserting data into WEATHER_OBS_STATION(_INFO)
  • Use: input level 1
  • Type: permanent table
  • Remarks: none


WEATHER_STATION

  • Description:
  • Use: interface between the CGMS12EU database and the SupitConstants software
  • Type: view on table STATION
  • Remarks:


WOG

  • Description: table for storing temporary results during interpolation of grid weather as part of the Weather Monitoring module. When the calculation is finshed, all records are inserted into WEATHER_OBS_GRID.
  • Use: temporary output table for the calculation of weather indicators. Output for level 1, input for level 2
  • Type: Permanent table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.


WOGC

  • Description: table for storing temporary results during calculation of advanced parameters. When the calculation is finshed, all records are inserted into WEATHER_OBS_STATION_CALCULATED, overwriting old results.
  • Use: temporary output table for the calculation of advanced parameters.
  • Type: Permanent table
  • Remarks: The table is created by cgms.exe each time the advanced parameters are calculated.


DAY_DECADE

  • Description: link between and decade, for mapping purposes
  • Use: sytem table used in level 2
  • Type: synonym on view FORALL.DAY_DECADE (based on DATE_GENERATOR)


STATIONS_PER_GRID_CURRENTYEAR

  • Description: the stations used for the grid weather interpolation of the current year.
  • Use: output table for the level 1 grid weather calculation
  • Type: permanent table
  • Remarks: will contain the information produced by current run for every day