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

From Agri4castWiki
Jump to: navigation, search
(WEATHER_HIS_GRID)
(CROP_PARAMETRIZATION_PARAMETER)
 
(55 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
 
{{expert}}
 
{{expert}}
 
__NOTOC__
 
__NOTOC__
Line 11: Line 10:
 
{{TocRow|#other datasets|7. other datasets}}
 
{{TocRow|#other datasets|7. other datasets}}
 
}}
 
}}
 
 
 
  
 
== CROP-datasets ==
 
== CROP-datasets ==
Line 19: Line 15:
 
{{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}}
 
 
}}
 
}}
 
 
 
  
 
<!-- start -->
 
<!-- start -->
 
=== CROP_AGGREGATIONS ===
 
=== CROP_AGGREGATIONS ===
* Description:  
+
* Description: Link between simulated and aggregated crops.
* Use:  
+
* Use: To aggregate simulation results at EMU resolution (IDCROP_PARAMETRIZATION) to regional resolution (IDCROP_AGGREGATION). A single simulated crop (IDCROP_PARAMETERIZATION) can be aggregated to different aggregated crops (IDCROP_AGGREGATION) using different aggregation areas.
 
* Type: ''Table''
 
* Type: ''Table''
 
* Remarks:  
 
* Remarks:  
Line 47: Line 38:
 
! 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 || - || identifier for aggregated crop
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP || False || NUMBER || - || identifier to link statistical crop (EUROSTAT)
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || identifier for simulated crop
 
|-
 
|-
 
|}
 
|}
Line 61: Line 52:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== CROP_CALENDARS ===
 
=== CROP_CALENDARS ===
 
* Description: ''where'' and ''when'' crops are grown. crop, crop variety and growing season per grid.
 
* Description: ''where'' and ''when'' crops are grown. crop, crop variety and growing season per grid.
Line 73: Line 65:
 
! 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 || - || identifier for simulated crop
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) || ||  
+
| IDGRID || False || NUMBER || - || identifier for agro-climatic grid
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) || - || calendar year
+
| YEAR || False || NUMBER || - || calendar year (year of sowing/emergence)
 
|-
 
|-
| START_PERIOD || NOT NULL || VARCHAR2(20) || ||  
+
| START_EVENT || False || VARCHAR2 || - || identifier for start event (SOWING, EMERGENCE)
 
|-
 
|-
| END_PERIOD || NOT NULL || VARCHAR2(20) || ||  
+
| END_EVENT || False || VARCHAR2 || - || identifier for end event (MATURITY, HARVESTING)
 
|-
 
|-
| EMERGENCE || || DATE ||  ||  
+
| EMERGENCE || True || DATE ||  || date of emergence
 
|-
 
|-
| SOWING || || DATE ||  ||  
+
| SOWING || True || DATE ||  || date of sowing
 
|-
 
|-
| HARVESTING || || DATE ||  ||  
+
| HARVESTING || True || DATE ||  || date of harvesting
 
|-
 
|-
| MATURITY || || DATE ||  ||  
+
| MATURITY || True || DATE ||  || date of maturity
 
|-
 
|-
| DURATION || || NUMBER(22) || ||
+
| WINDOW_DURATION || True || NUMBER || days || maximum duration of the season
|-
 
| 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: 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]]).
+
<nowiki>**</nowiki> possible values: HARVEST or MATURITY (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 104: Line 94:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_CALENDARS_OLD ===
+
 
* Description:  
+
=== CROP_PARAMETRIZATIONS ===
 +
* Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.
 
* Use:  
 
* Use:  
 
* Type: ''Table''
 
* Type: ''Table''
Line 116: Line 107:
 
! 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 || - || identifier for simulated crop
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) || ||  
+
| IDMODEL || False || NUMBER || - || identifier for crop model
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) || ||  
+
| IDCOVER || False || NUMBER || - || identifier for linked landcover/cropmask
 
|-
 
|-
| START_PERIOD || NOT NULL || VARCHAR2(20) || ||  
+
| ACTIVE_PARAMETRIZATION || False || VARCHAR2 || Y/N || switch to enable/disable parametrization simulations
 
|-
 
|-
| END_PERIOD || NOT NULL || VARCHAR2(20) || ||  
+
| VIEWER_ENABLED || False || VARCHAR2 || Y/N || switch to enable/disable parametrization in viewer
 
|-
 
|-
| EMERGENCE || || DATE || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || simulated crop name
 
|-
 
|-
| SOWING || || DATE || ||  
+
| DESCRIPTOR || True || VARCHAR2 || - || description for simulated crop
 
|-
 
|-
| HARVESTING || || DATE ||  ||
+
| TAG || True || VARCHAR2 ||  ||  
|-
 
| MATURITY ||  || DATE ||  ||
 
|-
 
| DURATION ||  || NUMBER(22) ||  ||
 
|-
 
| START_DOY ||  || NUMBER(22) ||  ||  
 
 
|-
 
|-
 +
 
|}
 
|}
  
Line 146: Line 132:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_PARAMETRIZATIONS ===
+
 
* Description:  
+
=== CROP_PARAMETRIZATION_PARAMETER ===
* Use:  
+
* Description: crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
 +
* Use: default crop parameter values in case no variety specific crop parameters are available.
 
* Type: ''Table''
 
* Type: ''Table''
 
* Remarks:  
 
* Remarks:  
Line 158: 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 || - || crop number
|-
 
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| ACTIVE_PARAMETRIZATION || NOT NULL || VARCHAR2(1) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x-value
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y-value in case of AFGEN function
|-
 
| DESCRIPTOR ||  || VARCHAR2(255) ||  ||
 
 
|-
 
|-
 
|}
 
|}
Line 176: Line 159:
  
  
 +
<!-- start -->
  
<!-- start -->
+
=== CROP_REGIMES ===
=== CROP_PARAMETRIZATION_PARAMETER ===
 
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 190: 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_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_REGIME || False || NUMBER ||  ||
 +
|-
 +
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||
 +
|-
 +
| SOWING_REGIME || False || VARCHAR2 ||  ||
 +
|-
 +
| REGIME_DETAIL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DETAIL_VALUE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| DETAIL_DIMENSION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 206: Line 195:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_REGIMES ===
+
=== CROP_SPATIALIZATIONS ===
* Description:  
+
* Description: Storing for each grid and crop the variety that should be used to simulate the crop
* Use:  
+
* Use: used for calibrations, the find the grid belonging to a variety and calibrating variety specific crop parameters. Used in in simulations to find variety specific crop parameter values.
 
* Type: ''Table''
 
* Type: ''Table''
* Remarks:  
+
* Remarks: usually the spatial coverage per crop is the same is in object {{Object|CROP_CALENDARS}}, except now without the season identifier. The specified spatial variety is static over years.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 218: 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_REGIME || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || crop number
|-
 
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
| SOWING_REGIME || NOT NULL || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
| REGIME_DETAIL || NOT NULL || VARCHAR2(30) || ||  
+
| IDGRID || False || NUMBER || - || grid number
 
|-
 
|-
| DETAIL_VALUE || NOT NULL || VARCHAR2(30) ||  ||
+
| IDVARIETY || False || NUMBER || - || variety number
|-
 
| DETAIL_DIMENSION || NOT NULL || VARCHAR2(60) ||  ||
 
|-
 
| DESCRIPTION ||  || VARCHAR2(256) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 240: Line 221:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_SPATIALIZATIONS ===
+
 
 +
=== CROP_SUITABILITY_RULES ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 252: Line 234:
 
! 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 || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||  
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| VALUEC || True || VARCHAR2 ||  ||
 +
|-
 +
| VALUEN_MIN || True || NUMBER ||  ||
 +
|-
 +
| VALUEN_MAX || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 266: Line 252:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_SUITABILITY_RULES ===
+
=== CROP_VARIETIES ===
* Description:  
+
* Description: list of all unique valrieties
* Use:  
+
* Use: lookup table for various link_* objects.
 
* Type: ''Table''
 
* Type: ''Table''
 
* Remarks:  
 
* Remarks:  
Line 278: Line 264:
 
! 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) ||  ||
+
| IDVARIETY || False || NUMBER || - || unique identifier for variety
|-
 
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| VALUEC ||  || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
| VALUEN_MIN || || NUMBER(22) || ||  
+
| VARIETY || False || VARCHAR2 || - || variety name
 
|-
 
|-
| VALUEN_MAX || || NUMBER(22) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || variety description
 
|-
 
|-
 
|}
 
|}
Line 296: Line 278:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETIES ===
+
 
 +
=== CROP_VARIETY_PARAMETERS ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 308: Line 291:
 
! 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 || False || NUMBER ||  ||  
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 322: Line 307:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETY_PARAMETERS ===
+
=== CROP_VARIETY_REGIMES ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 334: Line 319:
 
! 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 348: Line 333:
  
  
 +
 +
== 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_EVENTS|2.6 GLOBAL_EVENTS}}
 +
{{TocRow|#GLOBAL_GRIDS|2.7 GLOBAL_GRIDS}}
 +
{{TocRow|#GLOBAL_GRID_SOURCES|2.8 GLOBAL_GRID_SOURCES}}
 +
{{TocRow|#GLOBAL_LINK_COVERWINDOW_SOURCE|2.9 GLOBAL_LINK_COVERWINDOW_SOURCE}}
 +
{{TocRow|#GLOBAL_MODELS|2.10 GLOBAL_MODELS}}
 +
{{TocRow|#GLOBAL_REGIONS|2.11 GLOBAL_REGIONS}}
 +
{{TocRow|#GLOBAL_REGION_ELEMENTS|2.12 GLOBAL_REGION_ELEMENTS}}
 +
{{TocRow|#GLOBAL_REGION_SOURCES|2.13 GLOBAL_REGION_SOURCES}}
 +
{{TocRow|#GLOBAL_SOIL_SOURCES|2.14 GLOBAL_SOIL_SOURCES}}
 +
{{TocRow|#GLOBAL_STATIONS|2.15 GLOBAL_STATIONS}}
 +
{{TocRow|#GLOBAL_STATISTIC_SOURCES|2.16 GLOBAL_STATISTIC_SOURCES}}
 +
{{TocRow|#GLOBAL_SUITABILITY_PROPERTIES|2.17 GLOBAL_SUITABILITY_PROPERTIES}}
 +
{{TocRow|#GLOBAL_THRESHOLDS|2.18 GLOBAL_THRESHOLDS}}
 +
{{TocRow|#GLOBAL_TIME_DIMENSIONS|2.19 GLOBAL_TIME_DIMENSIONS}}
 +
{{TocRow|#GLOBAL_TREATMENTS|2.20 GLOBAL_TREATMENTS}}
 +
{{TocRow|#GLOBAL_WINDOWS|2.21 GLOBAL_WINDOWS}}
 +
}}
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETY_PARAMETERS_OLD ===
+
=== GLOBAL_CATEGORIES ===
* Description:  
+
* Description: snapshot table for snapshot CGMS14CHN.GLOBAL_CATEGORIES
 
* Use:  
 
* Use:  
* Type: ''Table''
+
* Type: ''Materialized View''
 
* Remarks:  
 
* Remarks:  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 362: 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
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDCATEGORY || False || NUMBER ||  ||  
|-
 
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| CATEGORY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    idcategory
 +
  , category
 +
  , descriptor
 +
from categories@cgms14sys_assistdas
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 378: Line 393:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETY_REGIMES ===
+
=== GLOBAL_COVERS ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
* Type: ''Table''
+
* Type: ''View''
 
* Remarks:  
 
* Remarks:  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 390: 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
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDCOVER || False || NUMBER ||  ||  
|-
 
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
| DECADE || NOT NULL || NUMBER(22) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    c.idcover
 +
  , c.cover
 +
  , c.descriptor
 +
from covers@CGMS14SYS_ASSISTDAS c
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 405: Line 425:
  
  
== GLOBAL-datasets ==
+
<!-- start -->
{{TocTable|content=
+
=== GLOBAL_COVER_SOURCES ===
{{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_GRIDS|2.6 GLOBAL_GRIDS}}
 
{{TocRow|#GLOBAL_GRID_SOURCES|2.7 GLOBAL_GRID_SOURCES}}
 
{{TocRow|#GLOBAL_LINK_COVERWINDOW_SOURCE|2.8 GLOBAL_LINK_COVERWINDOW_SOURCE}}
 
{{TocRow|#GLOBAL_MODELS|2.9 GLOBAL_MODELS}}
 
{{TocRow|#GLOBAL_REGIONS|2.10 GLOBAL_REGIONS}}
 
{{TocRow|#GLOBAL_REGION_ELEMENTS|2.11 GLOBAL_REGION_ELEMENTS}}
 
{{TocRow|#GLOBAL_REGION_SOURCES|2.12 GLOBAL_REGION_SOURCES}}
 
{{TocRow|#GLOBAL_SOIL_SOURCES|2.13 GLOBAL_SOIL_SOURCES}}
 
{{TocRow|#GLOBAL_STATISTIC_SOURCES|2.14 GLOBAL_STATISTIC_SOURCES}}
 
{{TocRow|#GLOBAL_SUITABILITY_PROPERTIES|2.15 GLOBAL_SUITABILITY_PROPERTIES}}
 
{{TocRow|#GLOBAL_THRESHOLDS|2.16 GLOBAL_THRESHOLDS}}
 
{{TocRow|#GLOBAL_TIME_DIMENSIONS|2.17 GLOBAL_TIME_DIMENSIONS}}
 
{{TocRow|#GLOBAL_TREATMENTS|2.18 GLOBAL_TREATMENTS}}
 
{{TocRow|#GLOBAL_WINDOWS|2.19 GLOBAL_WINDOWS}}
 
}}
 
 
 
 
 
 
 
 
 
<!-- start -->
 
=== GLOBAL_CATEGORIES ===
 
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
* Type: ''Materialized View''
+
* Type: ''View''
 
* Remarks:  
 
* Remarks:  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 444: 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
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || True || VARCHAR2 ||  ||
 +
|-
 +
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 455: Line 451:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
    idcategory
+
  c.idcover_source
   , category
+
   , c.cover_source
   , descriptor
+
   , c.descriptor
  from categories@CGMS14SYS_ASSISTSAN
+
  , c.unc
 +
  from cover_sources@CGMS14SYS_ASSISTDAS c
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 465: Line 462:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_COVERS ===
+
=== GLOBAL_CROPS ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 477: 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
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||
 +
|-
 +
| CROP || False || VARCHAR2 ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| EUROSTAT || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 488: Line 487:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     c.idcover
+
     c.idcrop
   , c.cover
+
   , c.crop
 
   , c.descriptor
 
   , c.descriptor
  from covers@CGMS14SYS_ASSISTSAN c
+
  , c.eurostat
 +
  from crops@CGMS14SYS_ASSISTDAS c
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 498: Line 498:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_COVER_SOURCES ===
+
=== GLOBAL_CROP_PARAMETERS ===
* Description:  
+
* Description: snapshot table for snapshot GLOBAL_CROP_PARAMETERS. List of all crop parameters, description, unit, type (single value or AFGEN function) and category (crop- or model parameters).
 
* Use:  
 
* Use:  
* Type: ''View''
+
* Type: ''Materialized View''
* Remarks:  
+
* Remarks: source objects exist in a different tennent, available via dblink.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 510: 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
 
|-
 
|-
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || -
 +
|-
 +
| CROP_PARAMETER || False || VARCHAR2 || - || -
 
|-
 
|-
| COVER_SOURCE || NOT NULL || VARCHAR2(30) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || -
 
|-
 
|-
| DESCRIPTOR || || VARCHAR2(255) || ||  
+
| MULTI || False || VARCHAR2 || Y/N || single value (x) or AFGEN function (xy)
 
|-
 
|-
| UNC || || VARCHAR2(255) || ||  
+
| IDCATEGORY || False || NUMBER || - || -
 +
|-
 +
| CATEGORY || False || VARCHAR2 || - || CROP/MODEL
 
|-
 
|-
 
|}
 
|}
 
  
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
   c.idcover_source
+
    cp.idcrop_parameter
   , c.cover_source
+
  , cp.crop_parameter
   , c.descriptor
+
   , cp.descriptor
   , c.unc
+
   , cp.multi
  from cover_sources@CGMS14SYS_ASSISTSAN c
+
   , cp.idcategory
 +
   , c.category
 +
  from
 +
    crop_parameters@CGMS14SYS_ASSISTDAS cp
 +
  , categories@CGMS14SYS_ASSISTDAS c
 +
where cp.idcategory = c.idcategory
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
  
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_CROPS ===
+
=== GLOBAL_EVENTS ===
* Description:  
+
* Description: list of season events
* Use:  
+
* Use: lookup table for events in {{Object|CROP_CALENDARS}}
* Type: ''View''
+
* Type: ''Materialized View''
* Remarks:  
+
* Remarks: values in column EVENT are case sensitive recognized by the crop model and should not be changed unless the mapping is also changed in the crop model.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 546: Line 553:
 
! 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) ||  ||
+
| IDEVENT || False || NUMBER || - || unique identifier for event
|-
 
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) || ||  
+
| EVENT || False || VARCHAR2 || - || event name
 
|-
 
|-
| EUROSTAT || NOT NULL || VARCHAR2(30) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || description of event
 
|-
 
|-
 
|}
 
|}
 
  
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
    c.idcrop
+
    idevent
  , c.crop
+
  , event
  , c.descriptor
+
  , c.descriptor
  , c.eurostat
+
  from events@cgms14sys_assistdas c
  from crops@CGMS14SYS_ASSISTSAN c
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
  
 +
<!-- start -->
  
<!-- start -->
+
=== GLOBAL_GRIDS ===
=== GLOBAL_CROP_PARAMETERS ===
 
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
* Type: ''Materialized View''
+
* Type: ''View''
 
* Remarks:  
 
* Remarks:  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 582: Line 585:
 
! 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) ||  ||  
+
| IDGRID || False || NUMBER ||  ||
 +
|-
 +
| IDGRID_SOURCE || False || NUMBER ||  ||
 +
|-
 +
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||
 +
|-
 +
| LATITUDE || False || NUMBER ||  ||
 +
|-
 +
| LONGITUDE || False || NUMBER ||  ||
 +
|-
 +
| ALTITUDE || False || NUMBER ||  ||
 +
|-
 +
| ALTITUDE_16 || True || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| ALTITUDE_25 || True || NUMBER ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| X || False || NUMBER ||  ||  
 
|-
 
|-
| MULTI || NOT NULL || VARCHAR2(1) ||  ||  
+
| Y || False || NUMBER ||  ||  
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DISTANCE_FROM_COAST || True || NUMBER ||  ||  
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
+
| CLIMATE_BARRIER || True || NUMBER ||  ||
 +
|-
 +
| HAS_LAND || False || VARCHAR2 ||  ||
 +
|-
 +
| GRID_SOURCE || False || VARCHAR2 ||  ||
 +
|-
 +
| RESOLUTION || False || NUMBER ||  ||
 +
|-
 +
| UNIT || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 599: Line 622:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     cp.idcrop_parameter
+
     g.idgrid
   , cp.crop_parameter
+
   , g.idgrid_source
   , cp.descriptor
+
   , idoriginal_code
   , cp.multi
+
  , latitude
   , cp.idcategory
+
  , longitude
   , c.category
+
  , altitude
  from
+
  , altitude_16
    crop_parameters@CGMS14SYS_ASSISTSAN cp
+
  , altitude_25
   , categories@CGMS14SYS_ASSISTSAN c
+
  , x
  where cp.idcategory = c.idcategory
+
  , y
 +
  , distance_from_coast
 +
  , climate_barrier
 +
  , has_land
 +
   , grid_source
 +
   , resolution
 +
   , unit
 +
  from grids@CGMS14SYS_ASSISTDAS g
 +
  , windows@CGMS14SYS_ASSISTDAS w
 +
   , grid_sources@CGMS14SYS_ASSISTDAS gs
 +
  where g.idgrid_source = gs.idgrid_source
 +
  and gs.idwindow = w.idwindow
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 615: Line 649:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_GRIDS ===
+
=== GLOBAL_GRID_SOURCES ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 627: Line 661:
 
! 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_SOURCE || False || NUMBER ||  ||  
|-
 
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  ||
 
|-
 
| LATITUDE || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| LONGITUDE || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| ALTITUDE || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| ALTITUDE_16 ||  || NUMBER(22) ||  ||
 
|-
 
| ALTITUDE_25 ||  || NUMBER(22) ||  ||
 
|-
 
| X || NOT NULL || NUMBER(22) ||  ||  
 
 
|-
 
|-
| Y || NOT NULL || NUMBER(22) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| DISTANCE_FROM_COAST || || NUMBER(22) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CLIMATE_BARRIER || || NUMBER(22) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| HAS_LAND || NOT NULL || VARCHAR2(1) ||  ||  
+
| RESOLUTION || False || NUMBER ||  ||  
 
|-
 
|-
| GRID_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
+
| UNIT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 664: Line 682:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     g.idgrid
+
     idgrid_source
   , g.idgrid_source
+
   , gs.idwindow
   , idoriginal_code
+
   , w.window
   , latitude
+
   , w.name
   , longitude
+
   , gs.resolution
   , altitude
+
   , gs.unit
   , altitude_16
+
   , gs.description
   , altitude_25
+
   , gs.unc
  , x
+
  from grid_sources@CGMS14SYS_ASSISTDAS gs
  , y
+
   , windows@CGMS14SYS_ASSISTDAS w
  , distance_from_coast
+
  where gs.idwindow = w.idwindow
  , climate_barrier
+
|}
  , has_land
 
  , grid_source
 
  , resolution
 
  , unit
 
  from grids@CGMS14SYS_ASSISTSAN g
 
   , windows@CGMS14SYS_ASSISTSAN w
 
  , grid_sources@CGMS14SYS_ASSISTSAN gs
 
  where g.idgrid_source = gs.idgrid_source
 
  and gs.idwindow = w.idwindow
 
|}
 
 
<!-- end -->
 
<!-- end -->
  
Line 691: Line 699:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_GRID_SOURCES ===
+
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 703: Line 711:
 
! 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) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDCOVER_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| DESCRIPTION || || VARCHAR2(255) ||  ||  
+
| COVER_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| UNC || || VARCHAR2(255) ||  ||  
+
| COVER_SOURCE_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 724: Line 732:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     idgrid_source
+
     lcws.idwindow
  , gs.idwindow
 
 
   , w.window
 
   , w.window
 
   , w.name
 
   , w.name
   , gs.resolution
+
   , lcws.idcover
   , gs.unit
+
   , c.cover
   , gs.description
+
   , lcws.idcover_source
   , gs.unc
+
   , cover_source
  from grid_sources@CGMS14SYS_ASSISTSAN gs
+
  , cs.descriptor as cover_source_descriptor
   , windows@CGMS14SYS_ASSISTSAN w
+
  from link_cover_window_source@CGMS14SYS_ASSISTDAS lcws
  where gs.idwindow = w.idwindow
+
   , windows@CGMS14SYS_ASSISTDAS w
 +
  , covers@CGMS14SYS_ASSISTDAS c
 +
  , cover_sources@CGMS14SYS_ASSISTDAS cs
 +
  where lcws.idwindow = w.idwindow
 +
  and lcws.idcover = c.idcover
 +
  and lcws.idcover_source = cs.idcover_source
 +
order by w.idwindow
 +
  , c.idcover
 +
  , cs.idcover_source
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 741: Line 756:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
+
=== GLOBAL_MODELS ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 753: Line 768:
 
! 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) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
|-
 
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| COVER || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| COVER_SOURCE || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| COVER_SOURCE_DESCRIPTOR ||  || VARCHAR2(255) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 774: Line 779:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
    lcws.idwindow
+
     m.idmodel
  , w.window
+
   , m.model
  , w.name
+
   , m.descriptor
  , lcws.idcover
+
  from models@CGMS14SYS_ASSISTDAS m
  , c.cover
+
|}
  , lcws.idcover_source
 
  , cover_source
 
  , cs.descriptor as cover_source_descriptor
 
from link_cover_window_source@CGMS14SYS_ASSISTSAN lcws
 
  , windows@CGMS14SYS_ASSISTSAN w
 
  , covers@CGMS14SYS_ASSISTSAN c
 
  , cover_sources@CGMS14SYS_ASSISTSAN cs
 
where lcws.idwindow = w.idwindow
 
  and lcws.idcover = c.idcover
 
  and lcws.idcover_source = cs.idcover_source
 
order by w.idwindow
 
  , c.idcover
 
  , cs.idcover_source
 
|}
 
<!-- end -->
 
 
 
 
 
 
 
<!-- start -->
 
=== GLOBAL_MODELS ===
 
* 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
 
|-
 
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| MODEL || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||
 
|-
 
|}
 
 
 
 
 
'''definition:'''
 
select
 
     m.idmodel
 
   , m.model
 
   , m.descriptor
 
  from models@CGMS14SYS_ASSISTSAN m
 
|}
 
 
<!-- end -->
 
<!-- end -->
  
Line 843: Line 801:
 
! 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 821:
 
   , r.continent
 
   , r.continent
 
   , r.population
 
   , r.population
  from regions@CGMS14SYS_ASSISTSAN r
+
  from regions@CGMS14SYS_ASSISTDAS r
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 882: Line 840:
 
! 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 884:
 
   , 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 907:
 
! 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 924:
 
   , 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 944:
 
! 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 958:
 
   , 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 965:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_STATISTIC_SOURCES ===
+
=== GLOBAL_STATIONS ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 1,019: Line 977:
 
! 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 ||  ||  
 
|-
 
|-
| STATISTIC_SOURCE || NOT NULL || VARCHAR2(60) ||  ||  
+
| STATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| ORGANIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
|}
+
| IDWMO || True || NUMBER ||  ||
 
+
|-
 +
| WMO || True || VARCHAR2 ||  ||
 +
|-
 +
| LATITUDE || False || NUMBER ||  ||
 +
|-
 +
| 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,070:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_SUITABILITY_PROPERTIES ===
+
=== GLOBAL_STATISTIC_SOURCES ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 1,052: Line 1,082:
 
! 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,093:
 
'''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,103:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_THRESHOLDS ===
+
=== GLOBAL_SUITABILITY_PROPERTIES ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 1,085: Line 1,115:
 
! 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,126:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     t.idthreshold
+
    p.idsuitability_property
   , t.threshold
+
  , p.suitability_property
   , t.indicator
+
  , p.descriptor
 +
from suitability_properties@CGMS14SYS_ASSISTDAS p
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== GLOBAL_THRESHOLDS ===
 +
* 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
 +
|-
 +
| IDTHRESHOLD || False || NUMBER ||  ||
 +
|-
 +
| THRESHOLD || False || VARCHAR2 ||  ||
 +
|-
 +
| INDICATOR || False || VARCHAR2 ||  ||
 +
|-
 +
| OPERATOR || False || VARCHAR2 ||  ||
 +
|-
 +
| VALUE_MIN || False || NUMBER ||  ||
 +
|-
 +
| VALUE_MAX || False || NUMBER ||  ||
 +
|-
 +
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
     t.idthreshold
 +
   , t.threshold
 +
   , t.indicator
 
   , t.operator
 
   , t.operator
 
   , t.value_min
 
   , t.value_min
 
   , t.value_max
 
   , t.value_max
  from thresholds@CGMS14SYS_ASSISTSAN t
+
  from thresholds@CGMS14SYS_ASSISTDAS t
   , windows@CGMS14SYS_ASSISTSAN w
+
   , windows@CGMS14SYS_ASSISTDAS w
 
  where t.idwindow = w.idwindow
 
  where t.idwindow = w.idwindow
 
|}
 
|}
Line 1,129: Line 1,192:
 
! 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 ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| DECADE || || NUMBER(22) ||  ||  
+
| DECADE || True || NUMBER ||  ||  
 
|-
 
|-
| DECADE_ID || || NUMBER(22) ||  ||  
+
| DECADE_ID || True || NUMBER ||  ||  
 
|-
 
|-
| MONTH || || NUMBER(22) ||  ||  
+
| MONTH || True || NUMBER ||  ||  
 
|-
 
|-
| MONTH_ID || || NUMBER(22) ||  ||  
+
| MONTH_ID || True || NUMBER ||  ||  
 
|-
 
|-
| QUARTER || || NUMBER(22) ||  ||  
+
| QUARTER || True || NUMBER ||  ||  
 
|-
 
|-
| QUARTER_ID || || NUMBER(22) ||  ||  
+
| QUARTER_ID || True || NUMBER ||  ||  
 
|-
 
|-
| YEAR || || NUMBER(22) ||  ||  
+
| YEAR || True || NUMBER ||  ||  
 
|-
 
|-
| LAST_DAY_DECADE || || VARCHAR2(1) ||  ||  
+
| LAST_DAY_DECADE || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,161: Line 1,224:
 
   , 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,243:
 
! 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,257:
 
   , 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,276:
 
! 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,323:
 
   , w.min_y
 
   , w.min_y
 
   , w.roi
 
   , w.roi
  from windows@CGMS14SYS_ASSISTSAN w
+
  from windows@CGMS14SYS_ASSISTDAS w
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
 
  
 
== LINK-datasets ==
 
== LINK-datasets ==
Line 1,289: Line 1,350:
 
{{TocRow|#LINK_SUITABILITY_RULES|3.20 LINK_SUITABILITY_RULES}}
 
{{TocRow|#LINK_SUITABILITY_RULES|3.20 LINK_SUITABILITY_RULES}}
 
}}
 
}}
 
 
 
  
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_AGGREGATION ===
 
=== LINK_CROP_AGGREGATION ===
* Description:  
+
* Description: relation between simulated crop parameterizations and crop aggregation areas.
 
* Use:  
 
* Use:  
* Type: ''View''
+
* Type: ''Materialized View''
* Remarks:  
+
* Remarks: One simulated crop parametetrization can be combined with multiple aggregation areas to create alternative aggregated crops. The object contains records from {{Object|CROP_AGGREGATIONS}}, with extra descriptive fields.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,306: Line 1,364:
 
! 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 || - || aggregated crop number
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP || False || NUMBER || - || global crop number
 
|-
 
|-
| CROP || NOT NULL || VARCHAR2(30) || ||  
+
| CROP || False || VARCHAR2 || - || global crop name
 
|-
 
|-
| CROP_DESCRIPTOR || NOT NULL || VARCHAR2(255) || ||  
+
| CROP_DESCRIPTOR || False || VARCHAR2 || - || global crop description
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) || ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 || - || crop model description
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || simulated crop number
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || simulated crop name
 
|-
 
|-
| PARAMETRIZATION_DESCRIPTOR || || VARCHAR2(255) || ||  
+
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 || - || simulated crop description
 
|-
 
|-
 
|}
 
|}
Line 1,355: Line 1,413:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_CROP_CALENDARS ===
 
=== LINK_CROP_CALENDARS ===
 
* Description:  
 
* Description:  
Line 1,367: Line 1,426:
 
! 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,468:
 
   ,
 
   ,
 
   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,498:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_PARAMETERS ===
 
=== LINK_CROP_PARAMETERS ===
* Description:  
+
* Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
* Use:  
+
* Use: default crop parameter values in case no variety specific crop parameters are available.
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
* Remarks:  
+
* Remarks: Contains records from {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,450: Line 1,509:
 
! 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 number
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) || ||  
+
| CROP_PARAMETER || False || VARCHAR2 || - || parameter name
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || parameter description and unit
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCATEGORY || False || NUMBER || - || parameter category number
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) || ||  
+
| CATEGORY || False || VARCHAR2 || - || parameter category name
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| YVALUE || || NUMBER(22) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
 
|}
 
|}
 
 
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
Line 1,502: Line 1,559:
 
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
 
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
 
  and  cpp.idcrop_parameter      = cps.idcrop_parameter
 
  and  cpp.idcrop_parameter      = cps.idcrop_parameter
  and  cp.idcover                = c.idcover
+
  and  cp.idcover                = c.idcover  
 
  and  cp.idmodel                = m.idmodel
 
  and  cp.idmodel                = m.idmodel
  and  cp.active_parametrization  = 'Y'
+
  and  lower(cp.active_parametrization) = lower('Y')
   
+
  order by cpp.idcrop_parametrization, cps.crop_parameter
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
  
 +
<!-- start -->
  
<!-- start -->
 
 
=== LINK_CROP_PARAMETERS_CROP ===
 
=== LINK_CROP_PARAMETERS_CROP ===
* Description:  
+
* Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
* Use:  
+
* Use: default crop parameter values in case no variety specific crop parameters are available.
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
* Remarks:  
+
* Remarks: Contains records from {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields and only of the parameter category 'CROP'
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,524: Line 1,581:
 
! 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 number
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) || ||  
+
| CROP_PARAMETER || False || VARCHAR2 || - || parameter name
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || parameter description and unit
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| YVALUE || || NUMBER(22) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
 
|}
 
|}
 
 
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
Line 1,568: Line 1,623:
 
   , crop_parametrizations cp
 
   , crop_parametrizations cp
 
   , global_crop_parameters cps
 
   , global_crop_parameters cps
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
+
  where cpp.idcrop_parametrization       = cp.idcrop_parametrization
  and  cpp.idcrop_parameter       = cps.idcrop_parameter
+
  and  cpp.idcrop_parameter             = cps.idcrop_parameter
  and  cp.idcover                 = c.idcover
+
  and  cp.idcover                       = c.idcover  
  and  cp.idmodel                 = m.idmodel
+
  and  cp.idmodel                       = m.idmodel
  and  cp.active_parametrization  = 'Y'
+
  and  lower(cp.active_parametrization) = lower('Y')
  and  cps.category              = 'CROP'
+
  and  lower(cps.category)               = lower('CROP')
   
+
  order by cpp.idcrop_parametrization, cps.crop_parameter
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 1,581: Line 1,636:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_CROP_PARAMETERS_MODEL ===
 
=== LINK_CROP_PARAMETERS_MODEL ===
* Description:  
+
* Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
* Use:  
+
* Use: default crop parameter values in case no variety specific crop parameters are available.
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
* Remarks:  
+
* Remarks: Contains records from {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields and only of the parameter category 'MODEL'
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,593: Line 1,649:
 
! 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 number
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) || ||  
+
| CROP_PARAMETER || False || VARCHAR2 || - || parameter name
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || parameter description and unit
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| YVALUE || || NUMBER(22) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
 
|}
 
|}
 
 
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
Line 1,637: Line 1,691:
 
   , crop_parametrizations cp
 
   , crop_parametrizations cp
 
   , global_crop_parameters cps
 
   , global_crop_parameters cps
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
+
  where cpp.idcrop_parametrization       = cp.idcrop_parametrization
  and  cpp.idcrop_parameter       = cps.idcrop_parameter
+
  and  cpp.idcrop_parameter             = cps.idcrop_parameter
  and  cp.idcover                 = c.idcover
+
  and  cp.idcover                       = c.idcover  
  and  cp.idmodel                 = m.idmodel
+
  and  cp.idmodel                       = m.idmodel
  and  cp.active_parametrization  = 'Y'
+
  and  lower(cp.active_parametrization) = lower('Y')
  and  cps.category              = 'MODEL'
+
  and  lower(cps.category)               = lower('MODEL')
   
+
  order by cpp.idcrop_parametrization, cps.crop_parameter
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 1,650: Line 1,704:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_CROP_PARAMETRIZATION ===
 
=== LINK_CROP_PARAMETRIZATION ===
* Description:  
+
* Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.
 
* Use:  
 
* Use:  
 
* Type: ''View''
 
* Type: ''View''
* Remarks:  
+
* Remarks: contains the same records as {{Object|CROP_PARAMETRIZATIONS}}, with additional descriptive fields.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,662: Line 1,717:
 
! 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 || False || VARCHAR2 ||  ||
 +
|-
 +
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 ||  ||
 +
|-
 +
| TAG || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) || ||  
+
| ACTIVE_PARAMETRIZATION || False || VARCHAR2 || Y/N ||  
 
|-
 
|-
| PARAMETRIZATION_DESCRIPTOR || || VARCHAR2(255) || ||  
+
| VIEWER_ENABLED || False || VARCHAR2 || Y/N ||  
 
|-
 
|-
| 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,685: Line 1,746:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
    cp.idcrop_parametrization
+
    cp.idcrop_parametrization
  , cp.crop_parametrization
+
  , cp.crop_parametrization
  , cp.descriptor
+
  , cp.descriptor as parametrization_descriptor
  , cp.idmodel
+
  , cp.tag
  , m.model
+
  , cp.active_parametrization
  , m.descriptor
+
  , cp.viewer_enabled
  , c.idcover
+
  , cp.idmodel
  , c.cover
+
  , m.model
  , c.descriptor
+
  , m.descriptor as model_descriptor
  from crop_parametrizations cp
+
  , c.idcover
  , global_models m
+
  , c.cover
  , global_covers c
+
  , c.descriptor as cover_descriptor
 +
  from
 +
    crop_parametrizations cp
 +
  , global_models         m
 +
  , global_covers         c
 
  where cp.idmodel = m.idmodel
 
  where cp.idmodel = m.idmodel
  and  cp.idcover = c.idcover
+
and  cp.idcover = c.idcover
 
  order by cp.idcrop_parametrization
 
  order by cp.idcrop_parametrization
 
|}
 
|}
Line 1,706: Line 1,771:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_CROP_SPATIALIZATIONS ===
 
=== LINK_CROP_SPATIALIZATIONS ===
 
* Description:  
 
* Description:  
Line 1,718: Line 1,784:
 
! 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,844:
 
   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,866:
 
! 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,813: Line 1,879:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_VARIETY_PARAMETERS ===
 
=== LINK_CROP_VARIETY_PARAMETERS ===
* Description:  
+
* Description: Optimized parameters for a variety.
* Use:  
+
* Use: If a parameter exist in this object it overwrites the default value stored in {{Object|LINK_CROP_PARAMETERS_CROP}} and {{Object|LINK_CROP_PARAMETERS_MODEL}}.
* Type: ''View''
+
* Type: ''Materialized View''
* Remarks:  
+
* Remarks: Contains records from {{Object|CROP_VARIETY_PARAMETERS}}, with extra descriptive fields
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,824: Line 1,890:
 
! 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 number
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) || ||  
+
| IDVARIETY || False || NUMBER || - || variety number
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) || ||  
+
| VARIETY || False || VARCHAR2 || - || variety name
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  || parameter name
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  || parameter description and unit
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| YVALUE || || NUMBER(22) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
 
|}
 
|}
Line 1,854: Line 1,920:
  
 
'''definition:'''
 
'''definition:'''
  select
+
  select  
    "IDCROP_PARAMETRIZATION","CROP_PARAMETRIZATION","IDMODEL","MODEL","IDCOVER","COVER","IDVARIETY","VARIETY","IDCROP_PARAMETER","CROP_PARAMETER","DESCRIPTOR","XVALUE","YVALUE"
+
    *
  from
+
from
    (
+
    (  
    select distinct
+
    select distinct
        cp.idcrop_parametrization
+
        cp.idcrop_parametrization
      , cp.crop_parametrization
+
      , cp.crop_parametrization
      , m.idmodel
+
      , m.idmodel
      , m.model
+
      , m.model
      , c.idcover
+
      , c.idcover
      , c.cover
+
      , c.cover
      , v.idvariety
+
      , v.idvariety
      , v.variety
+
      , v.variety
      , cps.idcrop_parameter
+
      , cps.idcrop_parameter
      , cps.crop_parameter
+
      , cps.crop_parameter
      , cps.descriptor
+
      , cps.descriptor
      , cvp.xvalue
+
      , cvp.xvalue
      , cvp.yvalue
+
      , cvp.yvalue
    from cgms14chn.global_models m
+
    from
      , global_covers c
+
        global_models m
      , crop_varieties v
+
      , global_covers c
      , crop_parametrizations cp
+
      , crop_varieties v
      , crop_spatializations cs
+
      , crop_parametrizations cp
      , global_crop_parameters cps
+
      , crop_spatializations cs
      , crop_variety_parameters cvp
+
      , global_crop_parameters cps
    where cs.idcrop_parametrization = cp.idcrop_parametrization
+
      , crop_variety_parameters cvp
      and cp.idcover = c.idcover
+
    where cs.idcrop_parametrization       = cp.idcrop_parametrization
      and cs.idvariety = v.idvariety
+
      and cp.idcover                       = c.idcover  
      and cp.idmodel = m.idmodel
+
      and cs.idvariety                     = v.idvariety
      and cs.idvariety = cvp.idvariety
+
      and cp.idmodel                       = m.idmodel
      and cvp.idcrop_parameter = cps.idcrop_parameter
+
      and cs.idvariety                     = cvp.idvariety
      and cp.active_parametrization = 'Y'
+
      and cvp.idcrop_parameter             = cps.idcrop_parameter
    ) a
+
      and lower(cp.active_parametrization) = lower('Y')
  order by idcrop_parametrization
+
    ) a      
    , idvariety
+
order by
    , crop_parameter
+
      idcrop_parametrization
 +
    , idvariety
 +
    , crop_parameter
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 1,896: Line 1,964:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_GRID_COVER ===
 
=== LINK_GRID_COVER ===
 
* Description:  
 
* Description:  
Line 1,908: Line 1,977:
 
! 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 2,003:
 
! 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 2,031:
 
! 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,057:
 
! 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,098:
 
! 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,146:
 
! 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,174:
 
! 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,124: Line 2,193:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SMU_STU ===
 
=== LINK_SMU_STU ===
* Description:  
+
* Description: Relative area of each STU inside a SMU.
* Use:  
+
* Use: used to find unique simulation units in elementary mapping units (see [[Spatial_schematization]]).
 
* Type: ''Table''
 
* Type: ''Table''
* Remarks:  
+
* Remarks: The total percentage per SMU adds up to 100%.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,135: Line 2,204:
 
! 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 || - || unique identifier for the soil map unit
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) || ||  
+
| IDSTU || False || NUMBER || - || identifier to the soil typologic unit
 
|-
 
|-
| PERCENTAGE || NOT NULL || NUMBER(22) || ||  
+
| PERCENTAGE || False || NUMBER || - || % of area inside the SMU, covered by the STU
 
|-
 
|-
 
|}
 
|}
Line 2,146: Line 2,215:
 
<!-- end -->
 
<!-- end -->
  
 +
<!-- start -->
  
 
<!-- start -->
 
 
=== LINK_STU_HORIZONS ===
 
=== LINK_STU_HORIZONS ===
 
* Description:  
 
* Description:  
Line 2,161: Line 2,229:
 
! 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,259:
 
! 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,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
 
|-
 
|-
| 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,318: Line 2,386:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
 
  
 
== SIM-datasets ==
 
== SIM-datasets ==
Line 2,356: Line 2,422:
 
! 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,490:
 
! 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,708:
 
! 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,776:
 
! 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,994:
 
! 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,056:
 
! 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,244:
 
! 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,306:
 
! 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,494:
 
! 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,558:
 
! 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,748:
 
! 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,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
 
|-
 
|-
| 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,998:
 
! 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,060:
 
! 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,248:
 
! 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,325:
 
! 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,399:
 
! 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,358: Line 4,424:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_SMU ===
 
=== SOIL_SMU ===
* Description:  
+
* Description: Spatially available unique Soil Map Units (SMU's).
* Use:  
+
* Use: The soil map units are one of the layers used in the [[Spatial_schematization]]
 
* Type: ''Table''
 
* Type: ''Table''
 
* Remarks:  
 
* Remarks:  
Line 4,369: Line 4,435:
 
! 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 || - || unique identifier for the soil map unit
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) || ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 || - || legacy identifier
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) || ||  
+
| IDSOIL_SOURCE || False || NUMBER || - || soil source number
 
|-
 
|-
 
|}
 
|}
Line 4,383: Line 4,449:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== SOIL_STU ===
 
=== SOIL_STU ===
* Description:  
+
* Description: distinct soil types that have been identified and described by attributes (variables) specifying the nature and properties of the soils (e.g. name, texture, the moisture regime, the stoniness, depth to bedrock etc.).
 
* Use:  
 
* Use:  
 
* Type: ''Table''
 
* Type: ''Table''
Line 4,395: Line 4,462:
 
! 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 || - || unique identifier for soil typologic unit
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) || ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 || - || legacy identifier
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) || ||  
+
| IDSOIL_SOURCE || False || NUMBER || - || soil source number
 
|-
 
|-
| STU || NOT NULL || VARCHAR2(30) || ||  
+
| STU || False || VARCHAR2 || - || resulution
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || resolution description
 
|-
 
|-
| SOIL_WRB || || VARCHAR2(8) || ||  
+
| SOIL_WRB || True || VARCHAR2 || - || World Reference Base soil code
 
|-
 
|-
| SOIL_WRB_CL || || VARCHAR2(1) || ||  
+
| SOIL_WRB_CL || True || VARCHAR2 || - || World Reference Base soil code
 
|-
 
|-
| SOIL_FAO90 || || VARCHAR2(8) || ||  
+
| SOIL_FAO90 || True || VARCHAR2 || - || FAO 1990 soil code
 
|-
 
|-
| SOIL_FAO90_CL || || VARCHAR2(1) || ||  
+
| SOIL_FAO90_CL || True || VARCHAR2 || - || FAO 1990 soil code
 
|-
 
|-
| SOIL_FAO85 || || VARCHAR2(8) || ||  
+
| SOIL_FAO85 || True || VARCHAR2 || - || FAO 1985 soil code
 
|-
 
|-
| SOIL_FAO85_CL || || VARCHAR2(1) || ||  
+
| SOIL_FAO85_CL || True || VARCHAR2 || - || FAO 1985 soil code
 
|-
 
|-
| SLOPE || || VARCHAR2(1) || ||  
+
| SLOPE || True || VARCHAR2 || - || slope
 
|-
 
|-
| TEXTURE || || VARCHAR2(1) || ||  
+
| TEXTURE || True || VARCHAR2 || - || texture of the soil
 
|-
 
|-
| PHASE || || VARCHAR2(2) || ||  
+
| PHASE || True || VARCHAR2 || - || agricultural limitation
 
|-
 
|-
| LAYERS || || NUMBER(22, 1) || ||  
+
| LAYERS || True || NUMBER || - || number of soil layers
 
|-
 
|-
| CALCULATED_ROOTING_DEPTH || || NUMBER(22, 5) || ||  
+
| CALCULATED_ROOTING_DEPTH || True || NUMBER || - || rooting depth class
 
|-
 
|-
| DRAINAGE || || NUMBER(22, 1) || ||  
+
| DRAINAGE || True || NUMBER || - || the drainage of the soil
 
|-
 
|-
| LIMITATION_TO_AGRIC_USE1 || || NUMBER(22, 2) || ||  
+
| LIMITATION_TO_AGRIC_USE1 || True || NUMBER || - || first limitation for agricultural usage
 
|-
 
|-
| LIMITATION_TO_AGRIC_USE2 || || NUMBER(22, 2) || ||  
+
| LIMITATION_TO_AGRIC_USE2 || True || NUMBER || - || second limitation for agricultural usage
 
|-
 
|-
| OBSTACLE_TO_ROOTS || || NUMBER(22, 1) || ||  
+
| OBSTACLE_TO_ROOTS || True || NUMBER || - || obstacle to root
 
|-
 
|-
| IMPERMEABLE_DEPTH_LAYER || || NUMBER(22, 1) || ||  
+
| IMPERMEABLE_DEPTH_LAYER || True || NUMBER || - || impermeable layer number
 
|-
 
|-
| SOIL_WATER_REGIME || || NUMBER(22, 1) || ||  
+
| SOIL_WATER_REGIME || True || NUMBER || - || soil water regime
 
|-
 
|-
| DEPTH_TO_BEDROCK || || VARCHAR2(8) || ||  
+
| DEPTH_TO_BEDROCK || True || VARCHAR2 || - || depth to bedrock
 
|-
 
|-
| SOIL_FAO74 || || VARCHAR2(8) || ||  
+
| SOIL_FAO74 || True || VARCHAR2 || - || FAO 1974 soil code
 
|-
 
|-
| SOIL_FAO74_CL || || VARCHAR2(1) || ||  
+
| SOIL_FAO74_CL || True || VARCHAR2 || - || FAO 1974 soil code
 
|-
 
|-
 
|}
 
|}
Line 4,449: Line 4,516:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
 
  
 
== WEATHER-datasets ==
 
== WEATHER-datasets ==
Line 4,476: Line 4,541:
 
{{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,557:
 
* 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,598:
 
|-
 
|-
 
|}
 
|}
<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,606:
  
 
<!-- start -->
 
<!-- start -->
 
 
=== WEATHER_ERA_GRID_LTA ===
 
=== WEATHER_ERA_GRID_LTA ===
 
* Description:  
 
* Description:  
Line 4,552: Line 4,618:
 
! 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 ||