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

From Agri4castWiki
Jump to: navigation, search
(WEATHER_OBS_STATION_INFO)
(san2das)
Line 1: Line 1:
 
 
{{expert}}
 
{{expert}}
 
__NOTOC__
 
__NOTOC__
Line 19: Line 18:
 
{{TocRow|#CROP_AGGREGATIONS|1.1 CROP_AGGREGATIONS}}
 
{{TocRow|#CROP_AGGREGATIONS|1.1 CROP_AGGREGATIONS}}
 
{{TocRow|#CROP_CALENDARS|1.2 CROP_CALENDARS}}
 
{{TocRow|#CROP_CALENDARS|1.2 CROP_CALENDARS}}
{{TocRow|#CROP_CALENDARS_OLD|1.3 CROP_CALENDARS_OLD}}
+
{{TocRow|#CROP_PARAMETRIZATIONS|1.3 CROP_PARAMETRIZATIONS}}
{{TocRow|#CROP_PARAMETRIZATIONS|1.4 CROP_PARAMETRIZATIONS}}
+
{{TocRow|#CROP_PARAMETRIZATION_PARAMETER|1.4 CROP_PARAMETRIZATION_PARAMETER}}
{{TocRow|#CROP_PARAMETRIZATION_PARAMETER|1.5 CROP_PARAMETRIZATION_PARAMETER}}
+
{{TocRow|#CROP_REGIMES|1.5 CROP_REGIMES}}
{{TocRow|#CROP_REGIMES|1.6 CROP_REGIMES}}
+
{{TocRow|#CROP_SPATIALIZATIONS|1.6 CROP_SPATIALIZATIONS}}
{{TocRow|#CROP_SPATIALIZATIONS|1.7 CROP_SPATIALIZATIONS}}
+
{{TocRow|#CROP_SUITABILITY_RULES|1.7 CROP_SUITABILITY_RULES}}
{{TocRow|#CROP_SUITABILITY_RULES|1.8 CROP_SUITABILITY_RULES}}
+
{{TocRow|#CROP_VARIETIES|1.8 CROP_VARIETIES}}
{{TocRow|#CROP_VARIETIES|1.9 CROP_VARIETIES}}
+
{{TocRow|#CROP_VARIETY_PARAMETERS|1.9 CROP_VARIETY_PARAMETERS}}
{{TocRow|#CROP_VARIETY_PARAMETERS|1.10 CROP_VARIETY_PARAMETERS}}
+
{{TocRow|#CROP_VARIETY_REGIMES|1.10 CROP_VARIETY_REGIMES}}
{{TocRow|#CROP_VARIETY_PARAMETERS_OLD|1.11 CROP_VARIETY_PARAMETERS_OLD}}
 
{{TocRow|#CROP_VARIETY_REGIMES|1.12 CROP_VARIETY_REGIMES}}
 
 
}}
 
}}
  
Line 47: Line 44:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 73: Line 70:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDGRID || False || NUMBER ||  ||  
|-
 
| YEAR || NOT NULL || NUMBER(22, 4) || - || calendar year
 
|-
 
| START_PERIOD || NOT NULL || VARCHAR2(20) ||  ||
 
|-
 
| END_PERIOD || NOT NULL || VARCHAR2(20) ||  ||
 
|-
 
| EMERGENCE ||  || DATE ||  ||
 
|-
 
| SOWING ||  || DATE ||  ||
 
|-
 
| HARVESTING ||  || DATE ||  ||
 
|-
 
| MATURITY ||  || DATE ||  ||
 
|-
 
| DURATION ||  || NUMBER(22) ||  ||
 
|-
 
| START_DOY ||  || NUMBER(22) ||  ||
 
|-
 
|}
 
<nowiki>*</nowiki> possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).<br>
 
<nowiki>**</nowiki> possible values: HARVEST, MATURITY, EARLIEST (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).
 
|}
 
<!-- end -->
 
 
 
 
 
 
 
<!-- start -->
 
=== CROP_CALENDARS_OLD ===
 
* Description:
 
* Use:
 
* Type: ''Table''
 
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
|-
 
|
 
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) || ||  
+
| YEAR || False || NUMBER || - || calendar year
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| START_PERIOD || False || VARCHAR2 ||  ||  
 
|-
 
|-
| START_PERIOD || NOT NULL || VARCHAR2(20) ||  ||  
+
| END_PERIOD || False || VARCHAR2 ||  ||  
 
|-
 
|-
| END_PERIOD || NOT NULL || VARCHAR2(20) ||  ||  
+
| EMERGENCE || True || DATE ||  ||  
 
|-
 
|-
| EMERGENCE || || DATE ||  ||  
+
| SOWING || True || DATE ||  ||  
 
|-
 
|-
| SOWING || || DATE ||  ||  
+
| HARVESTING || True || DATE ||  ||  
 
|-
 
|-
| HARVESTING || || DATE ||  ||  
+
| MATURITY || True || DATE ||  ||  
 
|-
 
|-
| MATURITY || || DATE ||  ||  
+
| DURATION || True || NUMBER ||  ||  
 
|-
 
|-
| DURATION ||  || NUMBER(22) ||  ||
+
| START_DOY || True || NUMBER ||  ||  
|-
 
| START_DOY || || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
 
+
&lt;nowiki>*&lt;/nowiki> possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).&lt;br>
 +
&lt;nowiki>**&lt;/nowiki> possible values: HARVEST, MATURITY, EARLIEST (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 158: Line 113:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| ACTIVE_PARAMETRIZATION || NOT NULL || VARCHAR2(1) ||  ||  
+
| ACTIVE_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 190: Line 145:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 218: Line 173:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_REGIME || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_REGIME || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 2) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| SOWING_REGIME || NOT NULL || VARCHAR2(30) ||  ||  
+
| SOWING_REGIME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| REGIME_DETAIL || NOT NULL || VARCHAR2(30) ||  ||  
+
| REGIME_DETAIL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DETAIL_VALUE || NOT NULL || VARCHAR2(30) ||  ||  
+
| DETAIL_VALUE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DETAIL_DIMENSION || NOT NULL || VARCHAR2(60) ||  ||  
+
| DETAIL_DIMENSION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTION || || VARCHAR2(256) ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 252: Line 207:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDVARIETY || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 278: Line 233:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||  
 
|-
 
|-
| VALUEC || || VARCHAR2(30) ||  ||  
+
| VALUEC || True || VARCHAR2 ||  ||  
 
|-
 
|-
| VALUEN_MIN || || NUMBER(22) ||  ||  
+
| VALUEN_MIN || True || NUMBER ||  ||  
 
|-
 
|-
| VALUEN_MAX || || NUMBER(22) ||  ||  
+
| VALUEN_MAX || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 308: Line 263:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDVARIETY || False || NUMBER ||  ||  
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  ||  
+
| VARIETY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 334: Line 289:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDVARIETY || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 350: Line 305:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETY_PARAMETERS_OLD ===
+
=== CROP_VARIETY_REGIMES ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 362: Line 317:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDVARIETY || False || NUMBER ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| DECADE || False || NUMBER ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 377: Line 332:
  
  
<!-- start -->
+
== GLOBAL-datasets ==
=== CROP_VARIETY_REGIMES ===
+
{{TocTable|content=
* Description:
+
{{TocRow|#GLOBAL_CATEGORIES|2.1 GLOBAL_CATEGORIES}}
* Use:
+
{{TocRow|#GLOBAL_COVERS|2.2 GLOBAL_COVERS}}
* Type: ''Table''
+
{{TocRow|#GLOBAL_COVER_SOURCES|2.3 GLOBAL_COVER_SOURCES}}
* Remarks:
+
{{TocRow|#GLOBAL_CROPS|2.4 GLOBAL_CROPS}}
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
|-
 
|
 
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| DECADE || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
|}
 
 
 
|}
 
<!-- end -->
 
 
 
 
 
 
 
== GLOBAL-datasets ==
 
{{TocTable|content=
 
{{TocRow|#GLOBAL_CATEGORIES|2.1 GLOBAL_CATEGORIES}}
 
{{TocRow|#GLOBAL_COVERS|2.2 GLOBAL_COVERS}}
 
{{TocRow|#GLOBAL_COVER_SOURCES|2.3 GLOBAL_COVER_SOURCES}}
 
{{TocRow|#GLOBAL_CROPS|2.4 GLOBAL_CROPS}}
 
 
{{TocRow|#GLOBAL_CROP_PARAMETERS|2.5 GLOBAL_CROP_PARAMETERS}}
 
{{TocRow|#GLOBAL_CROP_PARAMETERS|2.5 GLOBAL_CROP_PARAMETERS}}
 
{{TocRow|#GLOBAL_GRIDS|2.6 GLOBAL_GRIDS}}
 
{{TocRow|#GLOBAL_GRIDS|2.6 GLOBAL_GRIDS}}
Line 420: Line 347:
 
{{TocRow|#GLOBAL_REGION_SOURCES|2.12 GLOBAL_REGION_SOURCES}}
 
{{TocRow|#GLOBAL_REGION_SOURCES|2.12 GLOBAL_REGION_SOURCES}}
 
{{TocRow|#GLOBAL_SOIL_SOURCES|2.13 GLOBAL_SOIL_SOURCES}}
 
{{TocRow|#GLOBAL_SOIL_SOURCES|2.13 GLOBAL_SOIL_SOURCES}}
{{TocRow|#GLOBAL_STATISTIC_SOURCES|2.14 GLOBAL_STATISTIC_SOURCES}}
+
{{TocRow|#GLOBAL_STATIONS|2.14 GLOBAL_STATIONS}}
{{TocRow|#GLOBAL_SUITABILITY_PROPERTIES|2.15 GLOBAL_SUITABILITY_PROPERTIES}}
+
{{TocRow|#GLOBAL_STATISTIC_SOURCES|2.15 GLOBAL_STATISTIC_SOURCES}}
{{TocRow|#GLOBAL_THRESHOLDS|2.16 GLOBAL_THRESHOLDS}}
+
{{TocRow|#GLOBAL_SUITABILITY_PROPERTIES|2.16 GLOBAL_SUITABILITY_PROPERTIES}}
{{TocRow|#GLOBAL_TIME_DIMENSIONS|2.17 GLOBAL_TIME_DIMENSIONS}}
+
{{TocRow|#GLOBAL_THRESHOLDS|2.17 GLOBAL_THRESHOLDS}}
{{TocRow|#GLOBAL_TREATMENTS|2.18 GLOBAL_TREATMENTS}}
+
{{TocRow|#GLOBAL_TIME_DIMENSIONS|2.18 GLOBAL_TIME_DIMENSIONS}}
{{TocRow|#GLOBAL_WINDOWS|2.19 GLOBAL_WINDOWS}}
+
{{TocRow|#GLOBAL_TREATMENTS|2.19 GLOBAL_TREATMENTS}}
 +
{{TocRow|#GLOBAL_WINDOWS|2.20 GLOBAL_WINDOWS}}
 
}}
 
}}
  
Line 433: Line 361:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_CATEGORIES ===
 
=== GLOBAL_CATEGORIES ===
* Description:  
+
* Description: snapshot table for snapshot CGMS14CHN.GLOBAL_CATEGORIES
 
* Use:  
 
* Use:  
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
Line 444: Line 372:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCATEGORY || False || NUMBER ||  ||  
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
+
| CATEGORY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 458: Line 386:
 
   , category
 
   , category
 
   , descriptor
 
   , descriptor
  from categories@CGMS14SYS_ASSISTSAN
+
  from categories@cgms14sys_assistdas
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 477: Line 405:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 491: Line 419:
 
   , c.cover
 
   , c.cover
 
   , c.descriptor
 
   , c.descriptor
  from covers@CGMS14SYS_ASSISTSAN c
+
  from covers@CGMS14SYS_ASSISTDAS c
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 510: Line 438:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| COVER_SOURCE || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| UNC || || VARCHAR2(255) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 527: Line 455:
 
   , c.descriptor
 
   , c.descriptor
 
   , c.unc
 
   , c.unc
  from cover_sources@CGMS14SYS_ASSISTSAN c
+
  from cover_sources@CGMS14SYS_ASSISTDAS c
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 546: Line 474:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
+
| CROP || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| EUROSTAT || NOT NULL || VARCHAR2(30) ||  ||  
+
| EUROSTAT || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 563: Line 491:
 
   , c.descriptor
 
   , c.descriptor
 
   , c.eurostat
 
   , c.eurostat
  from crops@CGMS14SYS_ASSISTSAN c
+
  from crops@CGMS14SYS_ASSISTDAS c
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 571: Line 499:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_CROP_PARAMETERS ===
 
=== GLOBAL_CROP_PARAMETERS ===
* Description:  
+
* Description: snapshot table for snapshot CGMS14CHN.GLOBAL_CROP_PARAMETERS
 
* Use:  
 
* Use:  
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
Line 582: Line 510:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MULTI || NOT NULL || VARCHAR2(1) ||  ||  
+
| MULTI || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCATEGORY || False || NUMBER ||  ||  
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
+
| CATEGORY || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 606: Line 534:
 
   , c.category
 
   , c.category
 
  from
 
  from
     crop_parameters@CGMS14SYS_ASSISTSAN cp
+
     crop_parameters@CGMS14SYS_ASSISTDAS cp
   , categories@CGMS14SYS_ASSISTSAN c
+
   , categories@CGMS14SYS_ASSISTDAS c
 
  where cp.idcategory = c.idcategory
 
  where cp.idcategory = c.idcategory
 
|}
 
|}
Line 627: Line 555:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| LATITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| LATITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| LONGITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| LONGITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| ALTITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE_16 || || NUMBER(22) ||  ||  
+
| ALTITUDE_16 || True || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE_25 || || NUMBER(22) ||  ||  
+
| ALTITUDE_25 || True || NUMBER ||  ||  
 
|-
 
|-
| X || NOT NULL || NUMBER(22) ||  ||  
+
| X || False || NUMBER ||  ||  
 
|-
 
|-
| Y || NOT NULL || NUMBER(22) ||  ||  
+
| Y || False || NUMBER ||  ||  
 
|-
 
|-
| DISTANCE_FROM_COAST || || NUMBER(22) ||  ||  
+
| DISTANCE_FROM_COAST || True || NUMBER ||  ||  
 
|-
 
|-
| CLIMATE_BARRIER || || NUMBER(22) ||  ||  
+
| CLIMATE_BARRIER || True || NUMBER ||  ||  
 
|-
 
|-
| HAS_LAND || NOT NULL || VARCHAR2(1) ||  ||  
+
| HAS_LAND || False || VARCHAR2 ||  ||  
 
|-
 
|-
| GRID_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
+
| GRID_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  ||  
+
| RESOLUTION || False || NUMBER ||  ||  
 
|-
 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  ||  
+
| UNIT || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 680: Line 608:
 
   , resolution
 
   , resolution
 
   , unit
 
   , unit
  from grids@CGMS14SYS_ASSISTSAN g
+
  from grids@CGMS14SYS_ASSISTDAS g
   , windows@CGMS14SYS_ASSISTSAN w
+
   , windows@CGMS14SYS_ASSISTDAS w
   , grid_sources@CGMS14SYS_ASSISTSAN gs
+
   , grid_sources@CGMS14SYS_ASSISTDAS gs
 
  where g.idgrid_source = gs.idgrid_source
 
  where g.idgrid_source = gs.idgrid_source
 
   and gs.idwindow = w.idwindow
 
   and gs.idwindow = w.idwindow
Line 703: Line 631:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  ||  
+
| RESOLUTION || False || NUMBER ||  ||  
 
|-
 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  ||  
+
| UNIT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTION || || VARCHAR2(255) ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
| UNC || || VARCHAR2(255) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 732: Line 660:
 
   , gs.description
 
   , gs.description
 
   , gs.unc
 
   , gs.unc
  from grid_sources@CGMS14SYS_ASSISTSAN gs
+
  from grid_sources@CGMS14SYS_ASSISTDAS gs
   , windows@CGMS14SYS_ASSISTSAN w
+
   , windows@CGMS14SYS_ASSISTDAS w
 
  where gs.idwindow = w.idwindow
 
  where gs.idwindow = w.idwindow
 
|}
 
|}
Line 753: Line 681:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| COVER_SOURCE || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| COVER_SOURCE_DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| COVER_SOURCE_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 782: Line 710:
 
   , cover_source
 
   , cover_source
 
   , cs.descriptor as cover_source_descriptor
 
   , cs.descriptor as cover_source_descriptor
  from link_cover_window_source@CGMS14SYS_ASSISTSAN lcws
+
  from link_cover_window_source@CGMS14SYS_ASSISTDAS lcws
   , windows@CGMS14SYS_ASSISTSAN w
+
   , windows@CGMS14SYS_ASSISTDAS w
   , covers@CGMS14SYS_ASSISTSAN c
+
   , covers@CGMS14SYS_ASSISTDAS c
   , cover_sources@CGMS14SYS_ASSISTSAN cs
+
   , cover_sources@CGMS14SYS_ASSISTDAS cs
 
  where lcws.idwindow = w.idwindow
 
  where lcws.idwindow = w.idwindow
 
   and lcws.idcover = c.idcover
 
   and lcws.idcover = c.idcover
Line 810: Line 738:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 824: Line 752:
 
   , m.model
 
   , m.model
 
   , m.descriptor
 
   , m.descriptor
  from models@CGMS14SYS_ASSISTSAN m
+
  from models@CGMS14SYS_ASSISTDAS m
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 843: Line 771:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| REGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| REGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CONTINENT || NOT NULL || VARCHAR2(20) ||  ||  
+
| CONTINENT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| POPULATION || || NUMBER(22) ||  ||  
+
| POPULATION || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 863: Line 791:
 
   , r.continent
 
   , r.continent
 
   , r.population
 
   , r.population
  from regions@CGMS14SYS_ASSISTSAN r
+
  from regions@CGMS14SYS_ASSISTDAS r
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 882: Line 810:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION_ELEMENT || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_ELEMENT || False || NUMBER ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CONTINENT || NOT NULL || VARCHAR2(20) ||  ||  
+
| CONTINENT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| REGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| REGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| GLOBAL_NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| GLOBAL_NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| LOCAL_NAME || || VARCHAR2(255) ||  ||  
+
| LOCAL_NAME || True || VARCHAR2 ||  ||  
 
|-
 
|-
| REGION_LEVEL || NOT NULL || NUMBER(22) ||  ||  
+
| REGION_LEVEL || False || NUMBER ||  ||  
 
|-
 
|-
| POPULATION || || NUMBER(22) ||  ||  
+
| POPULATION || True || NUMBER ||  ||  
 
|-
 
|-
| STANDARD || NOT NULL || VARCHAR2(20) ||  ||  
+
| STANDARD || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDFATHER || || NUMBER(22, 12) ||  ||  
+
| IDFATHER || True || NUMBER ||  ||  
 
|-
 
|-
| IDREGION_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| REGION_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
+
| REGION_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 926: Line 854:
 
   , re.idregion_source
 
   , re.idregion_source
 
   , rs.region_source
 
   , rs.region_source
  from region_elements@CGMS14SYS_ASSISTSAN re
+
  from region_elements@CGMS14SYS_ASSISTDAS re
   , regions@CGMS14SYS_ASSISTSAN r
+
   , regions@CGMS14SYS_ASSISTDAS r
   , region_sources@CGMS14SYS_ASSISTSAN rs
+
   , region_sources@CGMS14SYS_ASSISTDAS rs
 
  where re.idregion = r.idregion
 
  where re.idregion = r.idregion
 
   and re.idregion_source = rs.idregion_source
 
   and re.idregion_source = rs.idregion_source
Line 949: Line 877:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| REGION_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
+
| REGION_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTION || || VARCHAR2(255) ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
| UNC || || VARCHAR2(255) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 966: Line 894:
 
   , r.description
 
   , r.description
 
   , r.unc
 
   , r.unc
  from region_sources@CGMS14SYS_ASSISTSAN r
+
  from region_sources@CGMS14SYS_ASSISTDAS r
 
  order by idregion_source
 
  order by idregion_source
 
|}
 
|}
Line 986: Line 914:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSOIL_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| SOIL_SOURCE || NOT NULL || VARCHAR2(30) ||  ||  
+
| SOIL_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,000: Line 928:
 
   , s.soil_source
 
   , s.soil_source
 
   , s.descriptor
 
   , s.descriptor
  from soil_sources@CGMS14SYS_ASSISTSAN s
+
  from soil_sources@CGMS14SYS_ASSISTDAS s
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 1,007: Line 935:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_STATISTIC_SOURCES ===
+
=== GLOBAL_STATIONS ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 1,019: Line 947:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSTATISTIC_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTATION || False || NUMBER ||  ||
 +
|-
 +
| STATION || False || VARCHAR2 ||  ||
 +
|-
 +
| ORGANIZATION || False || VARCHAR2 ||  ||
 +
|-
 +
| IDWMO || True || NUMBER ||  ||
 +
|-
 +
| WMO || True || VARCHAR2 ||  ||  
 
|-
 
|-
| STATISTIC_SOURCE || NOT NULL || VARCHAR2(60) ||  ||  
+
| LATITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| LONGITUDE || False || NUMBER ||  ||
 +
|-
 +
| Y_COORDINATE || False || NUMBER ||  ||
 +
|-
 +
| X_COORDINATE || False || NUMBER ||  ||
 +
|-
 +
| ALTITUDE || False || NUMBER ||  ||
 +
|-
 +
| IDCLIMATE_ZONE || False || NUMBER ||  ||
 +
|-
 +
| COUNTRY || False || VARCHAR2 ||  ||
 +
|-
 +
| DISTANCE_TO_COAST || False || NUMBER ||  ||
 +
|-
 +
| ANGSTROM_A || False || NUMBER ||  ||
 +
|-
 +
| ANGSTROM_B || False || NUMBER ||  ||
 +
|-
 +
| SUPIT_A || False || NUMBER ||  ||
 +
|-
 +
| SUPIT_B || False || NUMBER ||  ||
 +
|-
 +
| SUPIT_C || False || NUMBER ||  ||
 +
|-
 +
| HARGREAVES_A || False || NUMBER ||  ||
 +
|-
 +
| HARGREAVES_B || False || NUMBER ||  ||
 +
|-
 +
| RELIABLE_STATION || False || NUMBER ||  ||
 +
|-
 +
| ACTIVE_STATION || False || NUMBER ||  ||
 +
|-
 +
| AVAIL_PRECIPITATION_THRESHOLD || False || NUMBER ||  ||
 +
|-
 +
| AVAIL_SNOWDEPTH_THRESHOLD || False || NUMBER ||  ||
 +
|-
 +
| AVAIL_TEMPERATURE_THRESHOLD || False || NUMBER ||  ||
 +
|-
 +
| AVAIL_HUMIDITY_THRESHOLD || False || NUMBER ||  ||
 +
|-
 +
| AVAIL_REST_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
 
+
 
 
+
 
'''definition:'''
+
'''definition:'''
  select
+
  select
     s.idstatistic_source
+
     IDSTATION
   , s.statistic_source
+
   , STATION
   , s.descriptor
+
   , ORGANIZATION
  from statistic_sources@CGMS14SYS_ASSISTSAN s
+
  , IDWMO
|}
+
  , WMO
 +
  , LATITUDE
 +
  , LONGITUDE
 +
  , Y_COORDINATE
 +
  , X_COORDINATE
 +
  , ALTITUDE
 +
  , IDCLIMATE_ZONE
 +
  , COUNTRY
 +
  , DISTANCE_TO_COAST
 +
  , ANGSTROM_A
 +
  , ANGSTROM_B
 +
  , SUPIT_A
 +
  , SUPIT_B
 +
  , SUPIT_C
 +
  , HARGREAVES_A
 +
  , HARGREAVES_B
 +
  , RELIABLE_STATION
 +
  , ACTIVE_STATION
 +
  , AVAIL_PRECIPITATION_THRESHOLD
 +
  , AVAIL_SNOWDEPTH_THRESHOLD
 +
  , AVAIL_TEMPERATURE_THRESHOLD
 +
  , AVAIL_HUMIDITY_THRESHOLD
 +
  , AVAIL_REST_THRESHOLD
 +
  from stations@cgms14sys_assistdas s
 +
|}
 
<!-- end -->
 
<!-- end -->
  
Line 1,040: Line 1,040:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_SUITABILITY_PROPERTIES ===
+
=== GLOBAL_STATISTIC_SOURCES ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 1,052: Line 1,052:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTATISTIC_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| SUITABILITY_PROPERTY || NOT NULL || VARCHAR2(30) ||  ||  
+
| STATISTIC_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,063: Line 1,063:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     p.idsuitability_property
+
     s.idstatistic_source
   , p.suitability_property
+
   , s.statistic_source
   , p.descriptor
+
   , s.descriptor
  from suitability_properties@CGMS14SYS_ASSISTSAN p
+
  from statistic_sources@CGMS14SYS_ASSISTDAS s
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 1,073: Line 1,073:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_THRESHOLDS ===
+
=== GLOBAL_SUITABILITY_PROPERTIES ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 1,085: Line 1,085:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDTHRESHOLD || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||  
|-
 
| THRESHOLD || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| INDICATOR || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| OPERATOR || NOT NULL || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
| VALUE_MIN || NOT NULL || NUMBER(22) ||  ||  
+
| SUITABILITY_PROPERTY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| VALUE_MAX || NOT NULL || NUMBER(22) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,102: Line 1,096:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     t.idthreshold
+
     p.idsuitability_property
   , t.threshold
+
   , p.suitability_property
   , t.indicator
+
   , p.descriptor
  , t.operator
+
  from suitability_properties@CGMS14SYS_ASSISTDAS p
  , t.value_min
 
  , t.value_max
 
  from thresholds@CGMS14SYS_ASSISTSAN t
 
  , windows@CGMS14SYS_ASSISTSAN w
 
where t.idwindow = w.idwindow
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 1,117: Line 1,106:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_TIME_DIMENSIONS ===
+
=== GLOBAL_THRESHOLDS ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 1,129: Line 1,118:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| IDTHRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| DECADE || || NUMBER(22) ||  ||  
+
| THRESHOLD || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DECADE_ID || || NUMBER(22) ||  ||  
+
| INDICATOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MONTH || || NUMBER(22) ||  ||  
+
| OPERATOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MONTH_ID || || NUMBER(22) ||  ||  
+
| VALUE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| QUARTER || || NUMBER(22) ||  ||  
+
| VALUE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| QUARTER_ID ||  || NUMBER(22) ||  ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
    t.idthreshold
 +
  , t.threshold
 +
  , t.indicator
 +
  , t.operator
 +
  , t.value_min
 +
  , t.value_max
 +
from thresholds@CGMS14SYS_ASSISTDAS t
 +
  , windows@CGMS14SYS_ASSISTDAS w
 +
where t.idwindow = w.idwindow
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== GLOBAL_TIME_DIMENSIONS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 +
|-
 +
| DAY || False || DATE ||  ||
 +
|-
 +
| DECADE || True || NUMBER ||  ||
 +
|-
 +
| DECADE_ID || True || NUMBER ||  ||
 +
|-
 +
| MONTH || True || NUMBER ||  ||  
 
|-
 
|-
| YEAR || || NUMBER(22) ||  ||  
+
| MONTH_ID || True || NUMBER ||  ||  
 
|-
 
|-
| LAST_DAY_DECADE || || VARCHAR2(1) ||  ||  
+
| QUARTER || True || NUMBER ||  ||
 +
|-
 +
| QUARTER_ID || True || NUMBER ||  ||
 +
|-
 +
| YEAR || True || NUMBER ||  ||
 +
|-
 +
| LAST_DAY_DECADE || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,161: Line 1,194:
 
   , t.year
 
   , t.year
 
   , t.last_day_decade
 
   , t.last_day_decade
  from time_dimensions@CGMS14SYS_ASSISTSAN t
+
  from time_dimensions@CGMS14SYS_ASSISTDAS t
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 1,180: Line 1,213:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDTREATMENT || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDTREATMENT || False || NUMBER ||  ||  
 
|-
 
|-
| TREATMENT || NOT NULL || VARCHAR2(60) ||  ||  
+
| TREATMENT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,194: Line 1,227:
 
   , t.treatment
 
   , t.treatment
 
   , t.descriptor
 
   , t.descriptor
  from treatments@cgms14sys_assistsan t
+
  from treatments@cgms14sys_ASSISTDAS t
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 1,213: Line 1,246:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| REFERENCE_SYSTEM || NOT NULL || VARCHAR2(2000) ||  ||  
+
| REFERENCE_SYSTEM || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_LAT || NOT NULL || NUMBER(22) ||  ||  
+
| MAX_LAT || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_LON || NOT NULL || NUMBER(22) ||  ||  
+
| MAX_LON || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_LAT || NOT NULL || NUMBER(22) ||  ||  
+
| MIN_LAT || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_LON || NOT NULL || NUMBER(22) ||  ||  
+
| MIN_LON || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_X || NOT NULL || NUMBER(22) ||  ||  
+
| MAX_X || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_Y || NOT NULL || NUMBER(22) ||  ||  
+
| MAX_Y || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_X || NOT NULL || NUMBER(22) ||  ||  
+
| MIN_X || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_Y || NOT NULL || NUMBER(22) ||  ||  
+
| MIN_Y || False || NUMBER ||  ||  
 
|-
 
|-
| ROI || || NUMBER(22, 3) ||  ||  
+
| ROI || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,260: Line 1,293:
 
   , w.min_y
 
   , w.min_y
 
   , w.roi
 
   , w.roi
  from windows@CGMS14SYS_ASSISTSAN w
+
  from windows@CGMS14SYS_ASSISTDAS w
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 1,306: Line 1,339:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
+
| CROP || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CROP_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| CROP_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| PARAMETRIZATION_DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,367: Line 1,400:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| START_PERIOD || NOT NULL || VARCHAR2(20) ||  ||  
+
| START_PERIOD || False || VARCHAR2 ||  ||  
 
|-
 
|-
| START_DATE || || DATE ||  ||  
+
| START_DATE || True || DATE ||  ||  
 
|-
 
|-
| END_DATE || || DATE ||  ||  
+
| END_DATE || True || DATE ||  ||  
 
|-
 
|-
| DURATION || || NUMBER(22) ||  ||  
+
| DURATION || True || NUMBER ||  ||  
 
|-
 
|-
| START_DOY || || NUMBER(22) ||  ||  
+
| START_DOY || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,409: Line 1,442:
 
   ,
 
   ,
 
   case
 
   case
       when start_period = 'emergence' then emergence
+
       when start_period = 'EMERGENCE' then emergence
       when start_period = 'sowing' then sowing
+
       when start_period = 'SOWING' then sowing
 
   end
 
   end
 
     start_date
 
     start_date
 
   ,
 
   ,
 
   case
 
   case
       when end_period = 'harvesting' then harvesting
+
       when end_period = 'HARVESTING' then harvesting
       when end_period = 'maturity' then maturity
+
       when end_period = 'MATURITY' then maturity
 
   end
 
   end
 
     end_date
 
     end_date
Line 1,439: Line 1,472:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_PARAMETERS ===
 
=== LINK_CROP_PARAMETERS ===
* Description:  
+
* Description: snapshot table for snapshot CGMS14CHN.LINK_CROP_PARAMETERS
 
* Use:  
 
* Use:  
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
Line 1,450: Line 1,483:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCATEGORY || False || NUMBER ||  ||  
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
+
| CATEGORY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,513: Line 1,546:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_PARAMETERS_CROP ===
 
=== LINK_CROP_PARAMETERS_CROP ===
* Description:  
+
* Description: snapshot table for snapshot CGMS14CHN.LINK_CROP_PARAMETERS_CROP
 
* Use:  
 
* Use:  
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
Line 1,524: Line 1,557:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,582: Line 1,615:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_PARAMETERS_MODEL ===
 
=== LINK_CROP_PARAMETERS_MODEL ===
* Description:  
+
* Description: snapshot table for snapshot CGMS14CHN.LINK_CROP_PARAMETERS_MODEL
 
* Use:  
 
* Use:  
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
Line 1,593: Line 1,626:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,662: Line 1,695:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| PARAMETRIZATION_DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| COVER_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| COVER_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,718: Line 1,751:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDVARIETY || False || NUMBER ||  ||  
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  ||  
+
| VARIETY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,778: Line 1,811:
 
   and cs.idvariety = cvp.idvariety
 
   and cs.idvariety = cvp.idvariety
 
   and cvp.idcrop_parameter = cps.idcrop_parameter
 
   and cvp.idcrop_parameter = cps.idcrop_parameter
   and cp.active_parametrization = 'y'
+
   and cp.active_parametrization = 'Y'
 
  order by cs.idcrop_parametrization
 
  order by cs.idcrop_parametrization
 
   , cs.idgrid
 
   , cs.idgrid
Line 1,800: Line 1,833:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,824: Line 1,857:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDVARIETY || False || NUMBER ||  ||  
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  ||  
+
| VARIETY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,908: Line 1,941:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,934: Line 1,967:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,962: Line 1,995:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,988: Line 2,021:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,029: Line 2,062:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,077: Line 2,110:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,105: Line 2,138:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,135: Line 2,168:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| PERCENTAGE || NOT NULL || NUMBER(22) ||  ||  
+
| PERCENTAGE || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,161: Line 2,194:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDHORIZON || False || NUMBER ||  ||  
 
|-
 
|-
| DEPTH_MIN || NOT NULL || NUMBER(22, 5) ||  ||  
+
| DEPTH_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| DEPTH_MAX || NOT NULL || NUMBER(22, 5) ||  ||  
+
| DEPTH_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| HORIZON_LEVEL || NOT NULL || NUMBER(22, 1) ||  ||  
+
| HORIZON_LEVEL || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,191: Line 2,224:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| SAND || || NUMBER(22) ||  ||  
+
| SAND || True || NUMBER ||  ||  
 
|-
 
|-
| SILT || || NUMBER(22) ||  ||  
+
| SILT || True || NUMBER ||  ||  
 
|-
 
|-
| CLAY || || NUMBER(22) ||  ||  
+
| CLAY || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_WP || || NUMBER(22) ||  ||  
+
| SOIL_MOISTURE_WP || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_FC || || NUMBER(22) ||  ||  
+
| SOIL_MOISTURE_FC || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_SAT || || NUMBER(22) ||  ||  
+
| SOIL_MOISTURE_SAT || True || NUMBER ||  ||  
 
|-
 
|-
| BULK_DENSITY || || NUMBER(22) ||  ||  
+
| BULK_DENSITY || True || NUMBER ||  ||  
 
|-
 
|-
| ORGANIC_CARBON || || NUMBER(22) ||  ||  
+
| ORGANIC_CARBON || True || NUMBER ||  ||  
 
|-
 
|-
| DEPTH || || NUMBER(22) ||  ||  
+
| DEPTH || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,249: Line 2,282:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
+
| CROP || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CROP_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| CROP_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| PARAMETRIZATION_DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||  
 
|-
 
|-
| SUITABILITY_PROPERTY || NOT NULL || VARCHAR2(30) ||  ||  
+
| SUITABILITY_PROPERTY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| SUITABILITY_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| SUITABILITY_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| SUITABILITY_PROPERTY_MIN || || NUMBER(22) ||  ||  
+
| SUITABILITY_PROPERTY_MIN || True || NUMBER ||  ||  
 
|-
 
|-
| SUITABILITY_PROPERTY_MAX || || NUMBER(22) ||  ||  
+
| SUITABILITY_PROPERTY_MAX || True || NUMBER ||  ||  
 
|-
 
|-
| SUITABILITY_PROPERTY_VALUE || || VARCHAR2(30) ||  ||  
+
| SUITABILITY_PROPERTY_VALUE || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,356: Line 2,389:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHMEDIUMINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHMEDIUMINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,424: Line 2,457:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| AVG_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| AVG_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| AVG_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AVG_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| AVG_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AVG_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| AVG_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AVG_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| AVG_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AVG_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| AVG_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| AVG_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| AVG_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AVG_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| AVG_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| MIN_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| MIN_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| MIN_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| MAX_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| MAX_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| MAX_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MAX_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| MAX_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| STD_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| STD_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| STD_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| STD_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| STD_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| STD_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTRISKLEVEL || || NUMBER(22, 2) ||  ||  
+
| NUM_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTINFECTION || || NUMBER(22, 2) ||  ||  
+
| NUM_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTSPORULATION || || NUMBER(22, 2) ||  ||  
+
| NUM_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| NUM_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| NUM_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_GAIPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| NUM_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_GAIWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| NUM_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_AGBPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| NUM_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_AGBWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| NUM_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_STORAGEORGANSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| NUM_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_STORAGEORGANSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| NUM_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| NUM_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 2) ||  ||  
+
| NUM_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUE_POTENTIAL || || NUMBER(22, 2) ||  ||  
+
| NUM_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUE_WITH_BLAST || || NUMBER(22, 2) ||  ||  
+
| NUM_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_EFFECT_ON_RUE || || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_HUMIDITYMINIMUM || || NUMBER(22, 2) ||  ||  
+
| NUM_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_HUMIDITYMAXIMUM || || NUMBER(22, 2) ||  ||  
+
| NUM_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,642: Line 2,675:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHMEDIUMINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHMEDIUMINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,710: Line 2,743:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| AVG_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| AVG_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| AVG_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AVG_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| AVG_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AVG_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| AVG_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AVG_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| AVG_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AVG_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| AVG_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| AVG_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| AVG_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AVG_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| AVG_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| MIN_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| MIN_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| MIN_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| MAX_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| MAX_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| MAX_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MAX_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| MAX_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| STD_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| STD_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| STD_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| STD_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| STD_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| STD_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTRISKLEVEL || || NUMBER(22, 2) ||  ||  
+
| NUM_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTINFECTION || || NUMBER(22, 2) ||  ||  
+
| NUM_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTSPORULATION || || NUMBER(22, 2) ||  ||  
+
| NUM_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| NUM_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| NUM_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_GAIPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| NUM_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_GAIWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| NUM_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_AGBPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| NUM_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_AGBWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| NUM_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_STORAGEORGANSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| NUM_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_STORAGEORGANSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| NUM_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| NUM_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 2) ||  ||  
+
| NUM_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUE_POTENTIAL || || NUMBER(22, 2) ||  ||  
+
| NUM_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUE_WITH_BLAST || || NUMBER(22, 2) ||  ||  
+
| NUM_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_EFFECT_ON_RUE || || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_HUMIDITYMINIMUM || || NUMBER(22, 2) ||  ||  
+
| NUM_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_HUMIDITYMAXIMUM || || NUMBER(22, 2) ||  ||  
+
| NUM_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,928: Line 2,961:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_STORAGE || || NUMBER(22, 12) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| FORC_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| FORC_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| FORC_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,990: Line 3,023:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| AVG_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| AVG_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| AVG_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| MIN_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| MIN_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| MAX_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| MAX_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| STD_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| STD_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| STD_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SPIKELET_STERILITY || || NUMBER(22, 2) ||  ||  
+
| NUM_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 2) ||  ||  
+
| NUM_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TRANSPIRATION || || NUMBER(22, 2) ||  ||  
+
| NUM_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 3,178: Line 3,211:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_STORAGE || || NUMBER(22, 12) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| FORC_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| FORC_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| FORC_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 3,240: Line 3,273:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| AVG_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| AVG_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| AVG_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| MIN_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| MIN_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| MAX_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| MAX_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| STD_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| STD_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| STD_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SPIKELET_STERILITY || || NUMBER(22, 2) ||  ||  
+
| NUM_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 2) ||  ||  
+
| NUM_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TRANSPIRATION || || NUMBER(22, 2) ||  ||  
+
| NUM_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 3,428: Line 3,461:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| FSM || || NUMBER(22, 3) ||  ||  
+
| FSM || True || NUMBER ||  ||  
 
|-
 
|-
| FSMUR || || NUMBER(22, 3) ||  ||  
+
| FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| RUNOFF || || NUMBER(22, 8) ||  ||  
+
| RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 3,492: Line 3,525:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| AVG_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| AVG_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| AVG_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| AVG_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FSM || || NUMBER(22, 3) ||  ||  
+
| AVG_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FSMUR || || NUMBER(22, 3) ||  ||  
+
| AVG_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| AVG_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| AVG_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| AVG_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| AVG_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MIN_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MIN_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MIN_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MIN_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MIN_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| MIN_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSM || || NUMBER(22, 3) ||  ||  
+
| MIN_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSMUR || || NUMBER(22, 3) ||  ||  
+
| MIN_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MIN_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MIN_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MIN_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MIN_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MAX_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MAX_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MAX_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MAX_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MAX_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MAX_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| MAX_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSM || || NUMBER(22, 3) ||  ||  
+
| MAX_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSMUR || || NUMBER(22, 3) ||  ||  
+
| MAX_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MAX_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MAX_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MAX_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MAX_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| STD_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| STD_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| STD_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| STD_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSM || || NUMBER(22, 3) ||  ||  
+
| STD_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSMUR || || NUMBER(22, 3) ||  ||  
+
| STD_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| STD_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| STD_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| STD_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| STD_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 2) ||  ||  
+
| NUM_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 2) ||  ||  
+
| NUM_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 2) ||  ||  
+
| NUM_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSM || || NUMBER(22, 2) ||  ||  
+
| NUM_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSMUR || || NUMBER(22, 2) ||  ||  
+
| NUM_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVES_DIED_BY_COLD || || NUMBER(22, 2) ||  ||  
+
| NUM_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUNOFF || || NUMBER(22, 2) ||  ||  
+
| NUM_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SOIL_EVAPORATION || || NUMBER(22, 2) ||  ||  
+
| NUM_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LOSS_TO_SUBSOIL || || NUMBER(22, 2) ||  ||  
+
| NUM_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 3,682: Line 3,715:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| FSM || || NUMBER(22, 3) ||  ||  
+
| FSM || True || NUMBER ||  ||  
 
|-
 
|-
| FSMUR || || NUMBER(22, 3) ||  ||  
+
| FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| RUNOFF || || NUMBER(22, 8) ||  ||  
+
| RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 3,744: Line 3,777:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| AVG_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| AVG_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| AVG_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| AVG_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FSM || || NUMBER(22, 3) ||  ||  
+
| AVG_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FSMUR || || NUMBER(22, 3) ||  ||  
+
| AVG_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| AVG_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| AVG_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| AVG_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| AVG_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MIN_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MIN_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MIN_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MIN_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MIN_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| MIN_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSM || || NUMBER(22, 3) ||  ||  
+
| MIN_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSMUR || || NUMBER(22, 3) ||  ||  
+
| MIN_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MIN_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MIN_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MIN_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MIN_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MAX_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MAX_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MAX_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MAX_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MAX_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MAX_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| MAX_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSM || || NUMBER(22, 3) ||  ||  
+
| MAX_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSMUR || || NUMBER(22, 3) ||  ||  
+
| MAX_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MAX_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MAX_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MAX_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MAX_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| STD_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| STD_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| STD_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| STD_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSM || || NUMBER(22, 3) ||  ||  
+
| STD_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSMUR || || NUMBER(22, 3) ||  ||  
+
| STD_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| STD_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| STD_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| STD_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| STD_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 2) ||  ||  
+
| NUM_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 2) ||  ||  
+
| NUM_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 2) ||  ||  
+
| NUM_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSM || || NUMBER(22, 2) ||  ||  
+
| NUM_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSMUR || || NUMBER(22, 2) ||  ||  
+
| NUM_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVES_DIED_BY_COLD || || NUMBER(22, 2) ||  ||  
+
| NUM_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUNOFF || || NUMBER(22, 2) ||  ||  
+
| NUM_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SOIL_EVAPORATION || || NUMBER(22, 2) ||  ||  
+
| NUM_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LOSS_TO_SUBSOIL || || NUMBER(22, 2) ||  ||  
+
| NUM_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 3,932: Line 3,965:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| FSM || || NUMBER(22, 3) ||  ||  
+
| FSM || True || NUMBER ||  ||  
 
|-
 
|-
| FSMUR || || NUMBER(22, 3) ||  ||  
+
| FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| RUNOFF || || NUMBER(22, 8) ||  ||  
+
| RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 3,994: Line 4,027:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| AVG_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| AVG_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| AVG_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| AVG_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FSM || || NUMBER(22, 3) ||  ||  
+
| AVG_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FSMUR || || NUMBER(22, 3) ||  ||  
+
| AVG_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| AVG_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| AVG_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| AVG_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| AVG_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MIN_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MIN_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MIN_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MIN_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MIN_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| MIN_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSM || || NUMBER(22, 3) ||  ||  
+
| MIN_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSMUR || || NUMBER(22, 3) ||  ||  
+
| MIN_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MIN_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MIN_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MIN_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MIN_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MAX_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MAX_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MAX_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MAX_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MAX_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MAX_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| MAX_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSM || || NUMBER(22, 3) ||  ||  
+
| MAX_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSMUR || || NUMBER(22, 3) ||  ||  
+
| MAX_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MAX_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MAX_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MAX_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MAX_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| STD_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| STD_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| STD_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| STD_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSM || || NUMBER(22, 3) ||  ||  
+
| STD_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSMUR || || NUMBER(22, 3) ||  ||  
+
| STD_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| STD_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| STD_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| STD_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| STD_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 2) ||  ||  
+
| NUM_RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 2) ||  ||  
+
| NUM_TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 2) ||  ||  
+
| NUM_TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSM || || NUMBER(22, 2) ||  ||  
+
| NUM_FSM || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSMUR || || NUMBER(22, 2) ||  ||  
+
| NUM_FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVES_DIED_BY_COLD || || NUMBER(22, 2) ||  ||  
+
| NUM_LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUNOFF || || NUMBER(22, 2) ||  ||  
+
| NUM_RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SOIL_EVAPORATION || || NUMBER(22, 2) ||  ||  
+
| NUM_SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LOSS_TO_SUBSOIL || || NUMBER(22, 2) ||  ||  
+
| NUM_LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 4,182: Line 4,215:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| IDSERIES || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSERIES || False || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| FSM || || NUMBER(22, 3) ||  ||  
+
| FSM || True || NUMBER ||  ||  
 
|-
 
|-
| FSMUR || || NUMBER(22, 3) ||  ||  
+
| FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| RUNOFF || || NUMBER(22, 8) ||  ||  
+
| RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 4,259: Line 4,292:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDHORIZON || False || NUMBER ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSOIL_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| HORIZON || NOT NULL || VARCHAR2(30) ||  ||  
+
| HORIZON || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| ORIGINAL_LEVEL || || NUMBER(22, 1) ||  ||  
+
| ORIGINAL_LEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_WP || || NUMBER(22) ||  ||  
+
| SOIL_MOISTURE_CONTENT_WP || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_FC || || NUMBER(22) ||  ||  
+
| SOIL_MOISTURE_CONTENT_FC || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_SAT || || NUMBER(22) ||  ||  
+
| SOIL_MOISTURE_CONTENT_SAT || True || NUMBER ||  ||  
 
|-
 
|-
| DEPTH || || NUMBER(22, 5) ||  ||  
+
| DEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| USDA_CLASS# || || NUMBER(22, 3) ||  ||  
+
| USDA_CLASS# || True || NUMBER ||  ||  
 
|-
 
|-
| USDA_CLASS || || VARCHAR2(8) ||  ||  
+
| USDA_CLASS || True || VARCHAR2 ||  ||  
 
|-
 
|-
| GRAVEL || || NUMBER(22, 3) ||  ||  
+
| GRAVEL || True || NUMBER ||  ||  
 
|-
 
|-
| SAND || || NUMBER(22, 3) ||  ||  
+
| SAND || True || NUMBER ||  ||  
 
|-
 
|-
| SILT || || NUMBER(22, 3) ||  ||  
+
| SILT || True || NUMBER ||  ||  
 
|-
 
|-
| CLAY || || NUMBER(22, 3) ||  ||  
+
| CLAY || True || NUMBER ||  ||  
 
|-
 
|-
| BULK_DENSITY || || NUMBER(22, 5) ||  ||  
+
| BULK_DENSITY || True || NUMBER ||  ||  
 
|-
 
|-
| ORGANIC_CARBON || || NUMBER(22, 5) ||  ||  
+
| ORGANIC_CARBON || True || NUMBER ||  ||  
 
|-
 
|-
| PH_H2O || || NUMBER(22, 5) ||  ||  
+
| PH_H2O || True || NUMBER ||  ||  
 
|-
 
|-
| CLAY_CATION_EXCNG_CAPCTY || || NUMBER(22, 3) ||  ||  
+
| CLAY_CATION_EXCNG_CAPCTY || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_CATION_EXCNG_CAPCTY || || NUMBER(22, 3) ||  ||  
+
| SOIL_CATION_EXCNG_CAPCTY || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_BASE_SATURATION || || NUMBER(22, 3) ||  ||  
+
| SOIL_BASE_SATURATION || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_EXCHANGEABLE_BASE || || NUMBER(22, 5) ||  ||  
+
| TOTAL_EXCHANGEABLE_BASE || True || NUMBER ||  ||  
 
|-
 
|-
| CALCIUM_CARBONATE || || NUMBER(22, 5) ||  ||  
+
| CALCIUM_CARBONATE || True || NUMBER ||  ||  
 
|-
 
|-
| CALCIUM_SULPHATE || || NUMBER(22, 5) ||  ||  
+
| CALCIUM_SULPHATE || True || NUMBER ||  ||  
 
|-
 
|-
| EXCHANGEABLE_SODIUM || || NUMBER(22, 3) ||  ||  
+
| EXCHANGEABLE_SODIUM || True || NUMBER ||  ||  
 
|-
 
|-
| ELECTRICAL_CONDUCTIVITY || || NUMBER(22, 5) ||  ||  
+
| ELECTRICAL_CONDUCTIVITY || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 4,333: Line 4,366:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| INITIAL_DEPTH_GROUND_WATER || || NUMBER(22, 4) ||  ||  
+
| INITIAL_DEPTH_GROUND_WATER || True || NUMBER ||  ||  
 
|-
 
|-
| DRAINAGE_DEPTH || || NUMBER(22, 3) ||  ||  
+
| DRAINAGE_DEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| ROOTING_DEPTH_POTENTIAL_WATER || || NUMBER(22, 3) ||  ||  
+
| ROOTING_DEPTH_POTENTIAL_WATER || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_WATER_STARTDATE || || DATE ||  ||  
+
| POTENTIAL_WATER_STARTDATE || True || DATE ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 4,369: Line 4,402:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSOIL_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 4,395: Line 4,428:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSOIL_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| STU || NOT NULL || VARCHAR2(30) ||  ||  
+
| STU || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| SOIL_WRB || || VARCHAR2(8) ||  ||  
+
| SOIL_WRB || True || VARCHAR2 ||  ||  
 
|-
 
|-
| SOIL_WRB_CL || || VARCHAR2(1) ||  ||  
+
| SOIL_WRB_CL || True || VARCHAR2 ||  ||  
 
|-
 
|-
| SOIL_FAO90 || || VARCHAR2(8) ||  ||  
+
| SOIL_FAO90 || True || VARCHAR2 ||  ||  
 
|-
 
|-
| SOIL_FAO90_CL || || VARCHAR2(1) ||  ||  
+
| SOIL_FAO90_CL || True || VARCHAR2 ||  ||  
 
|-
 
|-
| SOIL_FAO85 || || VARCHAR2(8) ||  ||  
+
| SOIL_FAO85 || True || VARCHAR2 ||  ||  
 
|-
 
|-
| SOIL_FAO85_CL || || VARCHAR2(1) ||  ||  
+
| SOIL_FAO85_CL || True || VARCHAR2 ||  ||  
 
|-
 
|-
| SLOPE || || VARCHAR2(1) ||  ||  
+
| SLOPE || True || VARCHAR2 ||  ||  
 
|-
 
|-
| TEXTURE || || VARCHAR2(1) ||  ||  
+
| TEXTURE || True || VARCHAR2 ||  ||  
 
|-
 
|-
| PHASE || || VARCHAR2(2) ||  ||  
+
| PHASE || True || VARCHAR2 ||  ||  
 
|-
 
|-
| LAYERS || || NUMBER(22, 1) ||  ||  
+
| LAYERS || True || NUMBER ||  ||  
 
|-
 
|-
| CALCULATED_ROOTING_DEPTH || || NUMBER(22, 5) ||  ||  
+
| CALCULATED_ROOTING_DEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| DRAINAGE || || NUMBER(22, 1) ||  ||  
+
| DRAINAGE || True || NUMBER ||  ||  
 
|-
 
|-
| LIMITATION_TO_AGRIC_USE1 || || NUMBER(22, 2) ||  ||  
+
| LIMITATION_TO_AGRIC_USE1 || True || NUMBER ||  ||  
 
|-
 
|-
| LIMITATION_TO_AGRIC_USE2 || || NUMBER(22, 2) ||  ||  
+
| LIMITATION_TO_AGRIC_USE2 || True || NUMBER ||  ||  
 
|-
 
|-
| OBSTACLE_TO_ROOTS || || NUMBER(22, 1) ||  ||  
+
| OBSTACLE_TO_ROOTS || True || NUMBER ||  ||  
 
|-
 
|-
| IMPERMEABLE_DEPTH_LAYER || || NUMBER(22, 1) ||  ||  
+
| IMPERMEABLE_DEPTH_LAYER || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_WATER_REGIME || || NUMBER(22, 1) ||  ||  
+
| SOIL_WATER_REGIME || True || NUMBER ||  ||  
 
|-
 
|-
| DEPTH_TO_BEDROCK || || VARCHAR2(8) ||  ||  
+
| DEPTH_TO_BEDROCK || True || VARCHAR2 ||  ||  
 
|-
 
|-
| SOIL_FAO74 || || VARCHAR2(8) ||  ||  
+
| SOIL_FAO74 || True || VARCHAR2 ||  ||  
 
|-
 
|-
| SOIL_FAO74_CL || || VARCHAR2(1) ||  ||  
+
| SOIL_FAO74_CL || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 4,476: Line 4,509:
 
{{TocRow|#WEATHER_OBS_STATION_ERRORS|6.21 WEATHER_OBS_STATION_ERRORS}}
 
{{TocRow|#WEATHER_OBS_STATION_ERRORS|6.21 WEATHER_OBS_STATION_ERRORS}}
 
{{TocRow|#WEATHER_OBS_STATION_INFO|6.22 WEATHER_OBS_STATION_INFO}}
 
{{TocRow|#WEATHER_OBS_STATION_INFO|6.22 WEATHER_OBS_STATION_INFO}}
{{TocRow|#WEATHER_OBS_STATION_LTA|6.23 WEATHER_OBS_STATION_LTA}}
+
{{TocRow|#WEATHER_OBS_STATION_INFO_ERR|6.23 WEATHER_OBS_STATION_INFO_ERR}}
{{TocRow|#WEATHER_OBS_STATION_RAW|6.24 WEATHER_OBS_STATION_RAW}}
+
{{TocRow|#WEATHER_OBS_STATION_LTA|6.24 WEATHER_OBS_STATION_LTA}}
{{TocRow|#WEATHER_OPE_GRID|6.25 WEATHER_OPE_GRID}}
+
{{TocRow|#WEATHER_OBS_STATION_RAW|6.25 WEATHER_OBS_STATION_RAW}}
{{TocRow|#WEATHER_OPE_REGIONCOVER|6.26 WEATHER_OPE_REGIONCOVER}}
+
{{TocRow|#WEATHER_OBS_STATION_TEMP|6.26 WEATHER_OBS_STATION_TEMP}}
 +
{{TocRow|#WEATHER_OPE_GRID|6.27 WEATHER_OPE_GRID}}
 +
{{TocRow|#WEATHER_OPE_REGIONCOVER|6.28 WEATHER_OPE_REGIONCOVER}}
 
}}
 
}}
  
Line 4,490: Line 4,525:
 
* Use: input for crop simulation.
 
* Use: input for crop simulation.
 
* Type: ''Table''
 
* Type: ''Table''
* Remarks: The products from ECMWF (see [[Weather_Monitoring#Forecasted weather|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.
+
* Remarks: The products from ECMWF (see [[Weather_Monitoring#Forecasted weather|Forecasted weather]]) are stored in separate tables. Replace &lt;MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,531: Line 4,566:
 
|-
 
|-
 
|}
 
|}
<nowiki>*</nowiki> Not available (relevant) in HIS product<br>
+
&lt;nowiki>*&lt;/nowiki> Not available (relevant) in HIS product&lt;br>
<nowiki>**</nowiki> Not available in EPS, MON and SEA products<br>
+
&lt;nowiki>**&lt;/nowiki> Not available in EPS, MON and SEA products&lt;br>
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 4,539: Line 4,574:
  
 
<!-- start -->
 
<!-- start -->
 
 
=== WEATHER_ERA_GRID_LTA ===
 
=== WEATHER_ERA_GRID_LTA ===
 
* Description:  
 
* Description:  
Line 4,552: Line 4,586:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| AVG_WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_E0 || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| AVG_RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| AVG_SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| AVG_SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTALCLOUD || || NUMBER(22, 3) ||  ||  
+
| AVG_TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| MIN_WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_E0 || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| MIN_RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| MIN_SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| MIN_SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTALCLOUD || || NUMBER(22, 3) ||  ||  
+
| MIN_TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| MAX_WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_E0 || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| MAX_RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| MAX_SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| MAX_SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTALCLOUD || || NUMBER(22, 3) ||  ||  
+
| MAX_TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| STD_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| STD_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| STD_WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| STD_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| STD_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_E0 || False || NUMBER ||  ||  
 
|-
 
|-
| STD_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| STD_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| STD_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| STD_RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| STD_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| STD_SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| STD_SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTALCLOUD || || NUMBER(22, 3) ||  ||  
+
| STD_TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_VAPOURPRESSURE || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_WINDSPEED || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_PRECIPITATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_E0 || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_E0 || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_ES0 || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_ET0 || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| NUM_SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| NUM_SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTALCLOUD || || NUMBER(22, 6) ||  ||  
+
| NUM_TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 4,718: Line 4,752:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| E0 || False || NUMBER ||  ||  
 
|-
 
|-
| ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| TOTALCLOUD || || NUMBER(22) ||  ||  
+
| TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 4,772: Line 4,806:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| AVG_WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_E0 || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| AVG_RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| AVG_SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| AVG_SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTALCLOUD || || NUMBER(22, 3) ||  ||  
+
| AVG_TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| MIN_WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_E0 || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| MIN_RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| MIN_SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| MIN_SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTALCLOUD || || NUMBER(22, 3) ||  ||  
+
| MIN_TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| MAX_WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_E0 || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| MAX_RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| MAX_SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| MAX_SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTALCLOUD || || NUMBER(22, 3) ||  ||  
+
| MAX_TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| STD_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| STD_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| STD_WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| STD_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| STD_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_E0 || False || NUMBER ||  ||  
 
|-
 
|-
| STD_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| STD_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| STD_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| STD_RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| STD_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| STD_SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| STD_SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTALCLOUD || || NUMBER(22) ||  ||  
+
| STD_TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_VAPOURPRESSURE || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_WINDSPEED || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_PRECIPITATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_E0 || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_E0 || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_ES0 || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_ET0 || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| NUM_SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| NUM_SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTALCLOUD || || NUMBER(22, 6) ||  ||  
+
| NUM_TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 4,932: Line 4,966:
 
* Use: input for crop simulation.
 
* Use: input for crop simulation.
 
* Type: ''Table''
 
* Type: ''Table''
* Remarks: The products from ECMWF (see [[Weather_Monitoring#Forecasted weather|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.
+
* Remarks: The products from ECMWF (see [[Weather_Monitoring#Forecasted weather|Forecasted weather]]) are stored in separate tables. Replace &lt;MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,973: Line 5,007:
 
|-
 
|-
 
|}
 
|}
<nowiki>*</nowiki> Not available (relevant) in HIS product<br>
+
&lt;nowiki>*&lt;/nowiki> Not available (relevant) in HIS product&lt;br>
<nowiki>**</nowiki> Not available in EPS, MON and SEA products<br>
+
&lt;nowiki>**&lt;/nowiki> Not available in EPS, MON and SEA products&lt;br>
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 4,981: Line 5,015:
  
 
<!-- start -->
 
<!-- start -->
 
 
=== WEATHER_HIS_REGIONCOVER ===
 
=== WEATHER_HIS_REGIONCOVER ===
 
* Description:  
 
* Description:  
Line 4,994: Line 5,027:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_AVG || False || NUMBER ||  ||  
 
|-
 
|-
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_DEW || False || NUMBER ||  ||  
 
|-
 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| VAPOURPRESSURE || False || NUMBER ||  ||  
 
|-
 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| WINDSPEED || False || NUMBER ||  ||  
 
|-
 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| PRECIPITATION || False || NUMBER ||  ||  
 
|-
 
|-
| E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| E0 || False || NUMBER ||  ||  
 
|-
 
|-
| ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| ES0 || False || NUMBER ||  ||  
 
|-
 
|-
| ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| ET0 || False || NUMBER ||  ||  
 
|-
 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| RADIATION || False || NUMBER ||  ||  
 
|-
 
|-
| SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| TOTALCLOUD || || NUMBER(22, 3) ||  ||  
+
| TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 5,039: Line 5,072:
 
* Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
 
* Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
 
* Use: input for crop simulation.
 
* Use: input for crop simulation.
* Type: ''Table''
+
* Type: ''View''
* Remarks: The products from ECMWF (see [[Weather_Monitoring#Forecasted weather|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.
+
* Remarks: The products from ECMWF (see [[Weather_Monitoring#Forecasted weather|Forecasted weather]]) are stored in separate tables. Replace &lt;MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,048: Line 5,081:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDGRID || False || NUMBER ||  ||  
+
| IDGRID || True || NUMBER ||  ||
 +
|-
 +
| DAY || True || DATE ||  ||  
 
|-
 
|-
| DAY || False || DATE || ||  
+
| TEMPERATURE_MAX || True || NUMBER || °C || maximum air temperature at 2 m height
 
|-
 
|-
| TEMPERATURE_MAX || False || NUMBER || °C || maximum air temperature at 2 m height
+
| TEMPERATURE_MIN || True || NUMBER || °C || minimum air temperature at 2 m height
 
|-
 
|-
| TEMPERATURE_MIN || False || NUMBER || °C || minimum air temperature at 2 m height
+
| TEMPERATURE_AVG || True || NUMBER || °C || average air temperature at 2 m height
 
|-
 
|-
| TEMPERATURE_AVG || False || NUMBER || °C || average air temperature at 2 m height
+
| TEMPERATURE_DEW || True || NUMBER || °C || dewpoint air temperature at 2 m height
 
|-
 
|-
| TEMPERATURE_DEW || False || NUMBER || °C || dewpoint air temperature at 2 m height
+
| VAPOURPRESSURE || True || NUMBER || hPa || mean daily vapour pressure
 
|-
 
|-
| VAPOURPRESSURE || False || NUMBER || hPa || mean daily vapour pressure
+
| WINDSPEED || True || NUMBER || m.s-1 || mean daily wind speed at 10 m height
 
|-
 
|-
| WINDSPEED || False || NUMBER || m.s-1 || mean daily wind speed at 10 m height
+
| PRECIPITATION || True || NUMBER || mm.d-1 || daily rainfall
 
|-
 
|-
| PRECIPITATION || False || NUMBER || mm.d-1 || daily rainfall
+
| E0 || True || NUMBER || mm.d-1 || daily transpiration of water surface
 
|-
 
|-
| E0 || False || NUMBER || mm.d-1 || daily transpiration of water surface
+
| ES0 || True || NUMBER || mm.d-1 || daily transpiration of wet bare soil
 
|-
 
|-
| ES0 || False || NUMBER || mm.d-1 || daily transpiration of wet bare soil
+
| ET0 || True || NUMBER || mm.d-1 || daily transpiration of crop canopy
 
|-
 
|-
| ET0 || False || NUMBER || mm.d-1 || daily transpiration of crop canopy
+
| RADIATION || True || NUMBER || kJ.m-2.d-1 || daily radiation at surface
 
|-
 
|-
| RADIATION || False || NUMBER || kJ.m-2.d-1 || daily radiation at surface
+
| SNOWDEPTH || True || NUMBER || cm || daily mean snow depth**
 
|-
 
|-
 
| SNOWWEQ || True || NUMBER || cm || daily mean snow water equivalent
 
| SNOWWEQ || True || NUMBER || cm || daily mean snow water equivalent
 
|-
 
|-
| SNOWDEPTH || True || NUMBER || cm || daily mean snow depth**
+
| SNOWDENSITY || True || VARCHAR2 || ||  
 
|-
 
|-
 
| TOTALCLOUD || True || NUMBER ||  ||  
 
| TOTALCLOUD || True || NUMBER ||  ||  
 +
|-
 +
| GEOPOTENTIAL350 || True || VARCHAR2 ||  ||
 +
|-
 +
| GEOPOTENTIAL500 || True || VARCHAR2 ||  ||
 +
|-
 +
| GEOPOTENTIAL800 || True || VARCHAR2 ||  ||
 +
|-
 +
| HUMIDITY_06H || True || VARCHAR2 ||  ||
 +
|-
 +
| HUMIDITY_09H || True || VARCHAR2 ||  ||
 +
|-
 +
| HUMIDITY_12H || True || VARCHAR2 ||  ||
 +
|-
 +
| HUMIDITY_15H || True || VARCHAR2 ||  ||
 +
|-
 +
| HUMIDITY_18H || True || VARCHAR2 ||  ||
 
|-
 
|-
 
|}
 
|}
<nowiki>*</nowiki> Not available (relevant) in HIS product<br>
+
&lt;nowiki>*&lt;/nowiki> Not available (relevant) in HIS product&lt;br>
<nowiki>**</nowiki> Not available in EPS, MON and SEA products<br>
+
&lt;nowiki>**&lt;/nowiki> Not available in EPS, MON and SEA products&lt;br>
 +
 
 +
 
  
 
'''definition:'''
 
'''definition:'''
Line 5,177: Line 5,230:
  
 
<!-- start -->
 
<!-- start -->
 
 
=== WEATHER_HRES_REGIONCOVER ===
 
=== WEATHER_HRES_REGIONCOVER ===
 
* Description:  
 
* Description:  
Line 5,190: Line 5,242:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDGRID || || NUMBER(22, 12) ||  ||  
+
| IDREGION || True || VARCHAR2 ||  ||  
 
|-
 
|-
| DAY || || DATE ||  ||  
+
| IDCOVER || True || NUMBER ||  ||  
 
|-
 
|-
| TEMPERATURE_MAX || || NUMBER(22, 3) ||  ||  
+
| DAY || True || DATE ||  ||  
 
|-
 
|-
| TEMPERATURE_MIN || || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_MAX || True || NUMBER ||  ||  
 
|-
 
|-
| TEMPERATURE_AVG || || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_MIN || True || NUMBER ||  ||  
 
|-
 
|-
| TEMPERATURE_DEW || || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_AVG || True || NUMBER ||  ||  
 
|-
 
|-
| VAPOURPRESSURE || || NUMBER(22, 4) ||  ||  
+
| TEMPERATURE_DEW || True || NUMBER ||  ||  
 
|-
 
|-
| WINDSPEED || || NUMBER(22, 5) ||  ||  
+
| VAPOURPRESSURE || True || NUMBER ||  ||  
 
|-
 
|-
| PRECIPITATION || || NUMBER(22, 4) ||  ||  
+
| WINDSPEED || True || NUMBER ||  ||  
 
|-
 
|-
| E0 || || NUMBER(22, 4) ||  ||  
+
| PRECIPITATION || True || NUMBER ||  ||  
 
|-
 
|-
| ES0 || || NUMBER(22, 4) ||  ||  
+
| E0 || True || NUMBER ||  ||  
 
|-
 
|-
| ET0 || || NUMBER(22, 4) ||  ||  
+
| ES0 || True || NUMBER ||  ||  
 
|-
 
|-
| RADIATION || || NUMBER(22, 6) ||  ||  
+
| ET0 || True || NUMBER ||  ||  
 
|-
 
|-
| SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| RADIATION || True || NUMBER ||  ||  
 
|-
 
|-
| SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| SNOWDEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| SNOWDENSITY || || VARCHAR2 ||  ||  
+
| SNOWWEQ || True || NUMBER ||  ||  
 
|-
 
|-
| TOTALCLOUD || || NUMBER(22) ||  ||  
+
| SNOWDENSITY || True || VARCHAR2 ||  ||  
 
|-
 
|-
| GEOPOTENTIAL350 || || VARCHAR2 ||  ||  
+
| TOTALCLOUD || True || NUMBER ||  ||  
 
|-
 
|-
| GEOPOTENTIAL500 || || VARCHAR2 ||  ||  
+
| GEOPOTENTIAL350 || True || VARCHAR2 ||  ||  
 
|-
 
|-
| GEOPOTENTIAL800 || || VARCHAR2 ||  ||  
+
| GEOPOTENTIAL500 || True || VARCHAR2 ||  ||  
 
|-
 
|-
| HUMIDITY_06H || || VARCHAR2 ||  ||  
+
| GEOPOTENTIAL800 || True || VARCHAR2 ||  ||  
 
|-
 
|-
| HUMIDITY_09H || || VARCHAR2 ||  ||  
+
| HUMIDITY_06H || True || VARCHAR2 ||  ||  
 
|-
 
|-
| HUMIDITY_12H || || VARCHAR2 ||  ||  
+
| HUMIDITY_09H || True || VARCHAR2 ||  ||  
 
|-
 
|-
| HUMIDITY_15H || || VARCHAR2 ||  ||  
+
| HUMIDITY_12H || True || VARCHAR2 ||  ||  
 
|-
 
|-
| HUMIDITY_18H ||  || VARCHAR2 ||  ||  
+
| HUMIDITY_15H || True || VARCHAR2 ||  ||
 +
|-
 +
| HUMIDITY_18H || True || VARCHAR2 ||  ||
 +
|-
 +
| SOURCE || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 5,245: Line 5,301:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     idgrid
+
     idregion
 +
  , idcover
 +
  , day
 +
  , temperature_max
 +
  , temperature_min
 +
  , temperature_avg
 +
  , temperature_dew
 +
  , vapourpressure
 +
  , windspeed
 +
  , precipitation
 +
  , e0
 +
  , es0
 +
  , et0
 +
  , radiation
 +
  , snowdepth
 +
  , snowweq
 +
  , null snowdensity
 +
  , totalcloud
 +
  , null geopotential350
 +
  , null geopotential500
 +
  , null geopotential800
 +
  , null humidity_06h
 +
  , null humidity_09h
 +
  , null humidity_12h
 +
  , null humidity_15h
 +
  , null humidity_18h
 +
  , 'ERA REANALISYS'
 +
from weather_era_regioncover
 +
union
 +
select
 +
    idregion
 +
  , idcover
 
   , day
 
   , day
 
   , temperature_max
 
   , temperature_max
Line 5,270: Line 5,357:
 
   , null humidity_15h
 
   , null humidity_15h
 
   , null humidity_18h
 
   , null humidity_18h
  from weather_his_grid
+
  , 'HIS ANALISYS'
  union all
+
  from weather_his_regioncover
 +
where day between (select max(day)+1 from weather_era_regioncover) and (select min(day)-1 from weather_ope_regioncover)
 +
  union
 
  select
 
  select
     idgrid
+
     idregion
 +
  , idcover
 
   , day + dayoffset day
 
   , day + dayoffset day
 
   , temperature_max
 
   , temperature_max
Line 5,298: Line 5,388:
 
   , null humidity_15h
 
   , null humidity_15h
 
   , null humidity_18h
 
   , null humidity_18h
from weather_ope_grid
+
  , 'OPE DETERMINISTIC FORECAST'
where idmember = 0
+
  from weather_ope_regioncover
  and day+dayoffset > (select max(day) from weather_his_grid)
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 5,319: Line 5,408:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE || - || calendar day
+
| DAY || False || DATE || - || calendar day
 
|-
 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || °C || maximum air temperature
+
| TEMPERATURE_MAX || False || NUMBER || °C || maximum air temperature
 
|-
 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || °C || minimum air temperature
+
| TEMPERATURE_MIN || False || NUMBER || °C || minimum air temperature
 
|-
 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || °C || average air temperature
+
| TEMPERATURE_AVG || False || NUMBER || °C || average air temperature
 
|-
 
|-
| HUMIDITY_06H || || NUMBER(22, 6) || - ||  
+
| HUMIDITY_06H || True || NUMBER || - ||  
 
|-
 
|-
| HUMIDITY_09H || || NUMBER(22, 6) || - ||  
+
| HUMIDITY_09H || True || NUMBER || - ||  
 
|-
 
|-
| HUMIDITY_12H || || NUMBER(22, 6) || - ||  
+
| HUMIDITY_12H || True || NUMBER || - ||  
 
|-
 
|-
| HUMIDITY_15H || || NUMBER(22, 6) || - ||  
+
| HUMIDITY_15H || True || NUMBER || - ||  
 
|-
 
|-
| HUMIDITY_18H || || NUMBER(22, 6) ||  ||  
+
| HUMIDITY_18H || True || NUMBER ||  ||  
 
|-
 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || m.s-1 || mean daily vapour pressure
+
| VAPOURPRESSURE || False || NUMBER || m.s-1 || mean daily vapour pressure
 
|-
 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) || hPa || mean daily wind speed at 10 m height
+
| WINDSPEED || False || NUMBER || hPa || mean daily wind speed at 10 m height
 
|-
 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily rainfall
+
| PRECIPITATION || False || NUMBER || mm.d-1 || daily rainfall
 
|-
 
|-
| E0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of water surface
+
| E0 || False || NUMBER || mm.d-1 || daily transpiration of water surface
 
|-
 
|-
| ES0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of wet bare soil
+
| ES0 || False || NUMBER || mm.d-1 || daily transpiration of wet bare soil
 
|-
 
|-
| ET0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of crop canopy
+
| ET0 || False || NUMBER || mm.d-1 || daily transpiration of crop canopy
 
|-
 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) || KJ.m-2.d-1 || daily radiation at surface
+
| RADIATION || False || NUMBER || KJ.m-2.d-1 || daily radiation at surface
 
|-
 
|-
| SNOWDEPTH || || NUMBER(22, 6) || cm || daily mean snow depth
+
| SNOWDEPTH || True || NUMBER || cm || daily mean snow depth
 
|-
 
|-
 
|}
 
|}
Line 5,375: Line 5,464:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE || - ||  
+
| DAY || False || DATE || - ||  
 
|-
 
|-
| TEMPERATURE_GROUP_SOURCE || NOT NULL || VARCHAR2(10) ||  ||  
+
| TEMPERATURE_GROUP_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| TEMPERATURE_STATION_1 || NOT NULL || NUMBER(22, 7) ||  ||  
+
| TEMPERATURE_STATION_1 || False || NUMBER ||  ||  
 
|-
 
|-
| TEMPERATURE_STATION_2 || || NUMBER(22, 7) ||  ||  
+
| TEMPERATURE_STATION_2 || True || NUMBER ||  ||  
 
|-