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

From Agri4castWiki
Jump to: navigation, search
(WOG)
(CROP_PARAMETRIZATION_PARAMETER)
 
(58 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
 
 
{{expert}}
 
{{expert}}
 
__NOTOC__
 
__NOTOC__
Line 12: Line 10:
 
{{TocRow|#other datasets|7. other datasets}}
 
{{TocRow|#other datasets|7. other datasets}}
 
}}
 
}}
 
 
 
  
 
== CROP-datasets ==
 
== CROP-datasets ==
Line 20: 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 ===
''Table''.
+
* Description: Link between simulated and aggregated crops.
*Description:  
+
* 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.
*Use:  
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 49: 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 63: Line 52:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== CROP_CALENDARS ===
 
=== CROP_CALENDARS ===
''Table''.
+
* 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.
+
* Use: determines which crops are simulated for a grid, and simulation period
*Use: determines which crops are simulated for a grid, and simulation period
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: user defined, one of the ‘driving’ tables of the system
*Remarks: user defined, one of the ‘driving’ tables of the system
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 76: 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 107: Line 94:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_CALENDARS_OLD ===
 
''Table''.
 
  
 +
=== 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:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 117: 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 147: Line 132:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_PARAMETRIZATIONS ===
 
''Table''.
 
  
 +
=== CROP_PARAMETRIZATION_PARAMETER ===
 +
* 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''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 157: 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) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x-value
 
|-
 
|-
| ACTIVE_PARAMETRIZATION || NOT NULL || VARCHAR2(1) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y-value in case of AFGEN function
|-
 
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||
 
|-
 
| DESCRIPTOR ||  || VARCHAR2(255) ||  ||
 
 
|-
 
|-
 
|}
 
|}
Line 173: Line 157:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
  
  
 
<!-- start -->
 
<!-- start -->
=== CROP_PARAMETRIZATION_PARAMETER ===
 
''Table''.
 
  
 +
=== CROP_REGIMES ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 187: 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 203: Line 195:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_REGIMES ===
+
=== CROP_SPATIALIZATIONS ===
''Table''.  
+
* Description: Storing for each grid and crop the variety that should be used to simulate the crop
 
+
* 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''
 +
* 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 213: 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) || ||  
+
| IDGRID || False || NUMBER || - || grid number
 
|-
 
|-
| SOWING_REGIME || NOT NULL || VARCHAR2(30) ||  ||
+
| IDVARIETY || False || NUMBER || - || variety number
|-
 
| REGIME_DETAIL || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| DETAIL_VALUE || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| DETAIL_DIMENSION || NOT NULL || VARCHAR2(60) ||  ||
 
|-
 
| DESCRIPTION ||  || VARCHAR2(256) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 235: Line 221:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_SPATIALIZATIONS ===
 
''Table''.
 
  
 +
=== CROP_SUITABILITY_RULES ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 245: 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 ||  ||
 +
|-
 +
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||
 +
|-
 +
| VALUEC || True || VARCHAR2 ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| VALUEN_MIN || True || NUMBER ||  ||  
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| VALUEN_MAX || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 259: Line 252:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_SUITABILITY_RULES ===
+
=== CROP_VARIETIES ===
''Table''.
+
* Description: list of all unique valrieties
 
+
* Use: lookup table for various link_* objects.
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 269: 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) || ||  
+
| VARIETY || False || VARCHAR2 || - || variety name
 
|-
 
|-
| VALUEC || || VARCHAR2(30) ||  ||
+
| DESCRIPTOR || False || VARCHAR2 || - || variety description
|-
 
| VALUEN_MIN ||  || NUMBER(22) ||  ||
 
|-
 
| VALUEN_MAX ||  || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 287: Line 278:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETIES ===
 
''Table''.
 
  
 +
=== CROP_VARIETY_PARAMETERS ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 297: 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 ||  ||  
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| XVALUE || False || NUMBER ||  ||
 +
|-
 +
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 311: Line 307:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETY_PARAMETERS ===
+
=== CROP_VARIETY_REGIMES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 321: 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 335: 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 ===
''Table''.
+
* Description: snapshot table for snapshot CGMS14CHN.GLOBAL_CATEGORIES
 
+
* Use:
 +
* Type: ''Materialized View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 347: 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 363: Line 393:
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETY_REGIMES ===
+
=== GLOBAL_COVERS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 373: 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 -->
 
 
 
== 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_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 -->
 
<!-- start -->
=== GLOBAL_CATEGORIES ===
+
=== GLOBAL_COVER_SOURCES ===
''Materialized_View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 425: 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 ||  ||
 +
|-
 +
| COVER_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
+
| DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 436: 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 446: Line 462:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_COVERS ===
+
=== GLOBAL_CROPS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 456: 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 467: 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 477: Line 498:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_COVER_SOURCES ===
+
=== GLOBAL_CROP_PARAMETERS ===
''View''.  
+
* 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:
 +
* Type: ''Materialized View''
 +
* Remarks: source objects exist in a different tennent, available via dblink.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 487: 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 ===
''View''.  
+
* Description: list of season events
 
+
* Use: lookup table for events in {{Object|CROP_CALENDARS}}
 +
* Type: ''Materialized View''
 +
* 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 521: 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) || ||  
+
| EVENT || False || VARCHAR2 || - || event name
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||
+
| DESCRIPTOR || False || VARCHAR2 || - || description of event
|-
 
| EUROSTAT || NOT NULL || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
 
  
 
'''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_CROP_PARAMETERS ===
 
''Materialized_View''.
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
|-
 
|
 
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||
 
|-
 
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||
 
|-
 
| MULTI || NOT NULL || VARCHAR2(1) ||  ||
 
|-
 
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
|}
 
 
 
'''definition:'''
 
select
 
    cp.idcrop_parameter
 
  , cp.crop_parameter
 
  , cp.descriptor
 
  , cp.multi
 
  , cp.idcategory
 
  , c.category
 
from
 
    crop_parameters@CGMS14SYS_ASSISTSAN cp
 
  , categories@CGMS14SYS_ASSISTSAN c
 
where cp.idcategory = c.idcategory
 
|}
 
<!-- end -->
 
 
 
  
<!-- start -->
 
 
=== GLOBAL_GRIDS ===
 
=== GLOBAL_GRIDS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 598: 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
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| LATITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| LATITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| LONGITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| LONGITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| ALTITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE_16 || || NUMBER(22) ||  ||  
+
| ALTITUDE_16 || True || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE_25 || || NUMBER(22) ||  ||  
+
| ALTITUDE_25 || True || NUMBER ||  ||  
 
|-
 
|-
| X || NOT NULL || NUMBER(22) ||  ||  
+
| X || False || NUMBER ||  ||  
 
|-
 
|-
| Y || NOT NULL || NUMBER(22) ||  ||  
+
| Y || False || NUMBER ||  ||  
 
|-
 
|-
| DISTANCE_FROM_COAST || || NUMBER(22) ||  ||  
+
| DISTANCE_FROM_COAST || True || NUMBER ||  ||  
 
|-
 
|-
| CLIMATE_BARRIER || || NUMBER(22) ||  ||  
+
| CLIMATE_BARRIER || True || NUMBER ||  ||  
 
|-
 
|-
| HAS_LAND || NOT NULL || VARCHAR2(1) ||  ||  
+
| HAS_LAND || False || VARCHAR2 ||  ||  
 
|-
 
|-
| GRID_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
+
| GRID_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  ||  
+
| RESOLUTION || False || NUMBER ||  ||  
 
|-
 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  ||  
+
| UNIT || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 651: Line 638:
 
   , resolution
 
   , resolution
 
   , unit
 
   , unit
  from grids@CGMS14SYS_ASSISTSAN g
+
  from grids@CGMS14SYS_ASSISTDAS g
   , windows@CGMS14SYS_ASSISTSAN w
+
   , windows@CGMS14SYS_ASSISTDAS w
   , grid_sources@CGMS14SYS_ASSISTSAN gs
+
   , grid_sources@CGMS14SYS_ASSISTDAS gs
 
  where g.idgrid_source = gs.idgrid_source
 
  where g.idgrid_source = gs.idgrid_source
 
   and gs.idwindow = w.idwindow
 
   and gs.idwindow = w.idwindow
Line 663: Line 650:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_GRID_SOURCES ===
 
=== GLOBAL_GRID_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 672: 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_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  ||  
+
| RESOLUTION || False || NUMBER ||  ||  
 
|-
 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  ||  
+
| UNIT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTION || || VARCHAR2(255) ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
| UNC || || VARCHAR2(255) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 701: Line 690:
 
   , gs.description
 
   , gs.description
 
   , gs.unc
 
   , gs.unc
  from grid_sources@CGMS14SYS_ASSISTSAN gs
+
  from grid_sources@CGMS14SYS_ASSISTDAS gs
   , windows@CGMS14SYS_ASSISTSAN w
+
   , windows@CGMS14SYS_ASSISTDAS w
 
  where gs.idwindow = w.idwindow
 
  where gs.idwindow = w.idwindow
 
|}
 
|}
Line 711: Line 700:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
 
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 720: 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
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| COVER_SOURCE || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| COVER_SOURCE_DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| COVER_SOURCE_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 749: Line 740:
 
   , cover_source
 
   , cover_source
 
   , cs.descriptor as cover_source_descriptor
 
   , cs.descriptor as cover_source_descriptor
  from link_cover_window_source@CGMS14SYS_ASSISTSAN lcws
+
  from link_cover_window_source@CGMS14SYS_ASSISTDAS lcws
   , windows@CGMS14SYS_ASSISTSAN w
+
   , windows@CGMS14SYS_ASSISTDAS w
   , covers@CGMS14SYS_ASSISTSAN c
+
   , covers@CGMS14SYS_ASSISTDAS c
   , cover_sources@CGMS14SYS_ASSISTSAN cs
+
   , cover_sources@CGMS14SYS_ASSISTDAS cs
 
  where lcws.idwindow = w.idwindow
 
  where lcws.idwindow = w.idwindow
 
   and lcws.idcover = c.idcover
 
   and lcws.idcover = c.idcover
Line 766: Line 757:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_MODELS ===
 
=== GLOBAL_MODELS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 775: 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
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 789: Line 782:
 
   , m.model
 
   , m.model
 
   , m.descriptor
 
   , m.descriptor
  from models@CGMS14SYS_ASSISTSAN m
+
  from models@CGMS14SYS_ASSISTDAS m
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 797: Line 790:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_REGIONS ===
 
=== GLOBAL_REGIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 806: 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 826: Line 821:
 
   , r.continent
 
   , r.continent
 
   , r.population
 
   , r.population
  from regions@CGMS14SYS_ASSISTSAN r
+
  from regions@CGMS14SYS_ASSISTDAS r
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 834: Line 829:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_REGION_ELEMENTS ===
 
=== GLOBAL_REGION_ELEMENTS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 843: 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 887: 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 899: Line 896:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_REGION_SOURCES ===
 
=== GLOBAL_REGION_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 908: 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 925: 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 934: Line 933:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_SOIL_SOURCES ===
 
=== GLOBAL_SOIL_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 943: 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 957: 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 964: Line 965:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_STATISTIC_SOURCES ===
+
=== GLOBAL_STATIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 974: 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 ||  ||
 +
|-
 +
| STATION || False || VARCHAR2 ||  ||
 +
|-
 +
| 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 ||  ||  
 
|-
 
|-
| STATISTIC_SOURCE || NOT NULL || VARCHAR2(60) ||  ||  
+
| AVAIL_SNOWDEPTH_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| AVAIL_TEMPERATURE_THRESHOLD || False || NUMBER ||  ||
 +
|-
 +
| AVAIL_HUMIDITY_THRESHOLD || False || NUMBER ||  ||
 +
|-
 +
| AVAIL_REST_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 985: Line 1,036:
 
'''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 995: Line 1,070:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_SUITABILITY_PROPERTIES ===
+
=== GLOBAL_STATISTIC_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,005: 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,016: 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,026: Line 1,103:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_THRESHOLDS ===
+
=== GLOBAL_SUITABILITY_PROPERTIES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,036: 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) ||  ||  
+
| SUITABILITY_PROPERTY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| INDICATOR || NOT NULL || VARCHAR2(30) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| OPERATOR || NOT NULL || VARCHAR2(30) ||  ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
    p.idsuitability_property
 +
  , p.suitability_property
 +
  , 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 ||  ||  
 
|-
 
|-
| VALUE_MIN || NOT NULL || NUMBER(22) ||  ||  
+
| OPERATOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| VALUE_MAX || NOT NULL || NUMBER(22) ||  ||  
+
| VALUE_MIN || False || NUMBER ||  ||
 +
|-
 +
| VALUE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,059: Line 1,171:
 
   , 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,069: Line 1,181:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_TIME_DIMENSIONS ===
 
=== GLOBAL_TIME_DIMENSIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,078: 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,110: 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,118: Line 1,232:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_TREATMENTS ===
 
=== GLOBAL_TREATMENTS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,127: 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,141: 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,149: Line 1,265:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_WINDOWS ===
 
=== GLOBAL_WINDOWS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,158: 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,205: 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,234: 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 ===
''View''.  
+
* Description: relation between simulated crop parameterizations and crop aggregation areas.
 
+
* Use:
 +
* Type: ''Materialized View''
 +
* 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,249: 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,298: Line 1,413:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_CROP_CALENDARS ===
 
=== LINK_CROP_CALENDARS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,308: 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,350: 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,380: Line 1,498:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_PARAMETERS ===
 
=== LINK_CROP_PARAMETERS ===
''Materialized_View''.
+
* 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: default crop parameter values in case no variety specific crop parameters are available.
 +
* Type: ''Materialized View''
 +
* 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,389: 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,441: 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 ===
''Materialized_View''.
+
* 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: default crop parameter values in case no variety specific crop parameters are available.
 +
* Type: ''Materialized View''
 +
* 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,461: 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,505: 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,518: Line 1,636:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_CROP_PARAMETERS_MODEL ===
 
=== LINK_CROP_PARAMETERS_MODEL ===
''Materialized_View''.
+
* 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: default crop parameter values in case no variety specific crop parameters are available.
 +
* Type: ''Materialized View''
 +
* 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,528: 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,572: 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,585: Line 1,704:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_CROP_PARAMETRIZATION ===
 
=== LINK_CROP_PARAMETRIZATION ===
''View''.  
+
* 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:
 +
* Type: ''View''
 +
* 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,595: 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 ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| TAG || False || VARCHAR2 ||  ||  
 
|-
 
|-
| PARAMETRIZATION_DESCRIPTOR || || VARCHAR2(255) || ||  
+
| ACTIVE_PARAMETRIZATION || False || VARCHAR2 || Y/N ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) || ||  
+
| VIEWER_ENABLED || False || VARCHAR2 || Y/N ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||
 +
|-
 +
| COVER_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,618: 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,639: Line 1,771:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_CROP_SPATIALIZATIONS ===
 
=== LINK_CROP_SPATIALIZATIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,649: 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,709: 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,720: Line 1,855:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_STU ===
 
=== LINK_CROP_STU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,729: 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,742: Line 1,879:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_VARIETY_PARAMETERS ===
 
=== LINK_CROP_VARIETY_PARAMETERS ===
''View''.
+
* Description: Optimized parameters for a variety.
 
+
* 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: ''Materialized View''
 +
* 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,751: 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,781: 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,823: Line 1,964:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_GRID_COVER ===
 
=== LINK_GRID_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,833: 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,848: Line 1,992:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_GRID_REGION_COVER ===
 
=== LINK_GRID_REGION_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,857: 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,874: Line 2,020:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_REGION_COVER ===
 
=== LINK_REGION_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,883: 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,898: Line 2,046:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SIMULATION_UNIT ===
 
=== LINK_SIMULATION_UNIT ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,907: 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 1,937: Line 2,087:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SIMULATION_UNIT_CROP ===
 
=== LINK_SIMULATION_UNIT_CROP ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,946: 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 1,983: Line 2,135:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SMU_GRID_COVER ===
 
=== LINK_SMU_GRID_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,992: 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,009: Line 2,163:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SMU_GRID_REGION_COVER ===
 
=== LINK_SMU_GRID_REGION_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,018: 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,037: Line 2,193:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SMU_STU ===
 
=== LINK_SMU_STU ===
''Table''.  
+
* Description: Relative area of each STU inside a SMU.
 
+
* Use: used to find unique simulation units in elementary mapping units (see [[Spatial_schematization]]).
 +
* Type: ''Table''
 +
* Remarks: The total percentage per SMU adds up to 100%.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,046: 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,057: Line 2,215:
 
<!-- end -->
 
<!-- end -->
  
 +
<!-- start -->
  
 
<!-- start -->
 
 
=== LINK_STU_HORIZONS ===
 
=== LINK_STU_HORIZONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,070: 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,089: Line 2,248:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_STU_WEIGHTED_PARAMETERS ===
 
=== LINK_STU_WEIGHTED_PARAMETERS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,098: 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,145: Line 2,306:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SUITABILITY_RULES ===
 
=== LINK_SUITABILITY_RULES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,154: 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,223: Line 2,386:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
 
  
 
== SIM-datasets ==
 
== SIM-datasets ==
Line 2,250: Line 2,411:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_BLAST_HRES_GRID ===
 
=== SIM_BLAST_HRES_GRID ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,259: 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,316: Line 2,479:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_BLAST_HRES_GRID_LTA ===
 
=== SIM_BLAST_HRES_GRID_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,325: 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,532: Line 2,697:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_BLAST_HRES_REGION ===
 
=== SIM_BLAST_HRES_REGION ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,541: 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,598: Line 2,765:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_BLAST_HRES_REGION_LTA ===
 
=== SIM_BLAST_HRES_REGION_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,607: 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,814: Line 2,983:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WARM_HRES_GRID ===
 
=== SIM_WARM_HRES_GRID ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,823: 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,874: Line 3,045:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WARM_HRES_GRID_LTA ===
 
=== SIM_WARM_HRES_GRID_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,883: 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,060: Line 3,233:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WARM_HRES_REGION ===
 
=== SIM_WARM_HRES_REGION ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,069: 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,120: Line 3,295:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WARM_HRES_REGION_LTA ===
 
=== SIM_WARM_HRES_REGION_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,129: 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,306: Line 3,483:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_EMU ===
 
=== SIM_WOFOST_HRES_EMU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,315: 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,368: Line 3,547:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_EMU_LTA ===
 
=== SIM_WOFOST_HRES_EMU_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,377: 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,556: Line 3,737:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_GRID ===
 
=== SIM_WOFOST_HRES_GRID ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,565: 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,616: Line 3,799:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_GRID_LTA ===
 
=== SIM_WOFOST_HRES_GRID_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,625: 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,802: Line 3,987:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_REGION ===
 
=== SIM_WOFOST_HRES_REGION ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,811: 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,862: Line 4,049:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_REGION_LTA ===
 
=== SIM_WOFOST_HRES_REGION_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,871: 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,048: Line 4,237:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_STU ===
 
=== SIM_WOFOST_HRES_STU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,057: 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,123: Line 4,314:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_HORIZONS ===
 
=== SOIL_HORIZONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,132: 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,195: Line 4,388:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_INITIAL_WATER ===
 
=== SOIL_INITIAL_WATER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,204: 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,229: Line 4,424:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_SMU ===
 
=== SOIL_SMU ===
''Table''.
+
* Description: Spatially available unique Soil Map Units (SMU's).
 
+
* Use: The soil map units are one of the layers used in the [[Spatial_schematization]]
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,238: 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,252: Line 4,449:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== SOIL_STU ===
 
=== SOIL_STU ===
''Table''.
+
* 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:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,262: 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
 
|-
&