Difference between revisions of "Appendix 5: Database objects"

From Agri4castWiki
Jump to: navigation, search
Line 6: Line 6:
 
* [[{{BASEPAGENAME}}/GWSI_E_12|GWSI_E_12 database objects]]<br>
 
* [[{{BASEPAGENAME}}/GWSI_E_12|GWSI_E_12 database objects]]<br>
 
* [[{{BASEPAGENAME}}/CGMS12xxx|CGMS12xxx database objects (legacy)]]
 
* [[{{BASEPAGENAME}}/CGMS12xxx|CGMS12xxx database objects (legacy)]]
 +
 +
== renamed datasets ==
 +
{| class='wikitable'
 +
!new table name
 +
!old table name
 +
 +
|-
 +
| CROP_AGGREGATIONS || STAT_CROP
 +
|-
 +
| CROP_CALENDARS || CROP_CALENDAR
 +
|-
 +
| CROP_CALENDARS_OLD || ...
 +
|-
 +
| CROP_PARAMETRIZATIONS || ...
 +
|-
 +
| CROP_PARAMETRIZATION_PARAMETER || ...
 +
|-
 +
| CROP_REGIMES || ...
 +
|-
 +
| CROP_SPATIALIZATIONS || ...
 +
|-
 +
| CROP_SUITABILITY_RULES || ...
 +
|-
 +
| CROP_VARIETIES || ...
 +
|-
 +
| CROP_VARIETY_PARAMETERS || ...
 +
|-
 +
| CROP_VARIETY_PARAMETERS_OLD || ...
 +
|-
 +
| CROP_VARIETY_REGIMES || ...
 +
|-
 +
| DATES_75_15 || DATES_75_15
 +
|-
 +
| GLOBAL_CATEGORIES || ...
 +
|-
 +
| GLOBAL_COVERS || ...
 +
|-
 +
| GLOBAL_COVER_SOURCES || ...
 +
|-
 +
| GLOBAL_CROPS || ...
 +
|-
 +
| GLOBAL_CROP_PARAMETERS || ...
 +
|-
 +
| GLOBAL_GRIDS || ...
 +
|-
 +
| GLOBAL_GRID_SOURCES || ...
 +
|-
 +
| GLOBAL_LINK_COVERWINDOW_SOURCE || ...
 +
|-
 +
| GLOBAL_MODELS || ...
 +
|-
 +
| GLOBAL_REGIONS || ...
 +
|-
 +
| GLOBAL_REGION_ELEMENTS || ...
 +
|-
 +
| GLOBAL_REGION_SOURCES || ...
 +
|-
 +
| GLOBAL_SOIL_SOURCES || ...
 +
|-
 +
| GLOBAL_STATISTIC_SOURCES || ...
 +
|-
 +
| GLOBAL_SUITABILITY_PROPERTIES || ...
 +
|-
 +
| GLOBAL_THRESHOLDS || ...
 +
|-
 +
| GLOBAL_TIME_DIMENSIONS || ...
 +
|-
 +
| GLOBAL_TREATMENTS || ...
 +
|-
 +
| GLOBAL_WINDOWS || ...
 +
|-
 +
| GRIDS || ...
 +
|-
 +
| HRES_YEARS || ...
 +
|-
 +
| INTERPOLATION_PARAMETERS || ...
 +
|-
 +
| LINK_CROP_AGGREGATION || ...
 +
|-
 +
| LINK_CROP_CALENDARS || ...
 +
|-
 +
| LINK_CROP_PARAMETERS || ...
 +
|-
 +
| LINK_CROP_PARAMETERS_CROP || ...
 +
|-
 +
| LINK_CROP_PARAMETERS_MODEL || ...
 +
|-
 +
| LINK_CROP_PARAMETRIZATION || ...
 +
|-
 +
| LINK_CROP_SPATIALIZATIONS || ...
 +
|-
 +
| LINK_CROP_STU || ...
 +
|-
 +
| LINK_CROP_VARIETY_PARAMETERS || ...
 +
|-
 +
| LINK_GRID_COVER || ...
 +
|-
 +
| LINK_GRID_REGION_COVER || ...
 +
|-
 +
| LINK_REGION_COVER || ...
 +
|-
 +
| LINK_SIMULATION_UNIT || ...
 +
|-
 +
| LINK_SIMULATION_UNIT_CROP || ...
 +
|-
 +
| LINK_SMU_GRID_COVER || ...
 +
|-
 +
| LINK_SMU_GRID_REGION_COVER || ...
 +
|-
 +
| LINK_SMU_STU || ...
 +
|-
 +
| LINK_STU_HORIZONS || ...
 +
|-
 +
| LINK_STU_WEIGHTED_PARAMETERS || ...
 +
|-
 +
| LINK_SUITABILITY_RULES || ...
 +
|-
 +
| REGIONS || ...
 +
|-
 +
| SIM_BLAST_HRES_GRID || ...
 +
|-
 +
| SIM_BLAST_HRES_GRID_LTA || ...
 +
|-
 +
| SIM_BLAST_HRES_REGION || ...
 +
|-
 +
| SIM_BLAST_HRES_REGION_LTA || ...
 +
|-
 +
| SIM_WARM_HRES_GRID || ...
 +
|-
 +
| SIM_WARM_HRES_GRID_LTA || ...
 +
|-
 +
| SIM_WARM_HRES_REGION || ...
 +
|-
 +
| SIM_WARM_HRES_REGION_LTA || ...
 +
|-
 +
| SIM_WOFOST_HRES_EMU || ...
 +
|-
 +
| SIM_WOFOST_HRES_EMU_LTA || ...
 +
|-
 +
| SIM_WOFOST_HRES_GRID || ...
 +
|-
 +
| SIM_WOFOST_HRES_GRID_LTA || ...
 +
|-
 +
| SIM_WOFOST_HRES_REGION || ...
 +
|-
 +
| SIM_WOFOST_HRES_REGION_LTA || ...
 +
|-
 +
| SIM_WOFOST_HRES_STU || ...
 +
|-
 +
| SOIL_HORIZONS || ...
 +
|-
 +
| SOIL_INITIAL_WATER || ...
 +
|-
 +
| SOIL_SMU || ...
 +
|-
 +
| SOIL_STU || ...
 +
|-
 +
| STATIONS || ...
 +
|-
 +
| STAT_REGION_AREAS || ...
 +
|-
 +
| SYSTABLES || SYSTABLES
 +
|-
 +
| TASKS || TASKS
 +
|-
 +
| WEATHER_ERA_GRID || WEATHER_ERA_GRID
 +
|-
 +
| WEATHER_ERA_GRID_LTA || WEATHER_<MODEL>_GRID_LTA
 +
|-
 +
| WEATHER_ERA_REGIONCOVER || WEATHER_ERA_REGION
 +
|-
 +
| WEATHER_ERA_REGIONCOVER_LTA || WEATHER_ERA_REGION_LTA
 +
|-
 +
| WEATHER_HIS_GRID || WEATHER_HIS_GRID
 +
|-
 +
| WEATHER_HIS_REGIONCOVER || WEATHER_HIS_REGION
 +
|-
 +
| WEATHER_HRES_GRID || ...
 +
|-
 +
| WEATHER_HRES_REGIONCOVER || ...
 +
|-
 +
| WEATHER_OBS_GRID || WEATHER_OBS_GRID
 +
|-
 +
| WEATHER_OBS_GRID_INFO || WEATHER_OBS_GRID_INFO
 +
|-
 +
| WEATHER_OBS_GRID_LTA || WEATHER_OBS_GRID_LTA
 +
|-
 +
| WEATHER_OBS_GRID_LTA_MISS || WEATHER_OBS_GRID_LTA_MISS
 +
|-
 +
| WEATHER_OBS_REGCOV_LTA_THRSHLD || ...
 +
|-
 +
| WEATHER_OBS_REGCOV_THRESHOLDS || WEATHER_OBS_REGION_THRES
 +
|-
 +
| WEATHER_OBS_REGIONCOVER || WEATHER_OBS_REGION
 +
|-
 +
| WEATHER_OBS_REGIONCOVER_LTA || WEATHER_OBS_REGION_LTA
 +
|-
 +
| WEATHER_OBS_STATION || WEATHER_OBS_STATION
 +
|-
 +
| WEATHER_OBS_STATION_AVAIL || WEATHER_OBS_STATION_AVAIL
 +
|-
 +
| WEATHER_OBS_STATION_CALCULATED || WEATHER_OBS_STATION_CALCULATED
 +
|-
 +
| WEATHER_OBS_STATION_ERRAIN || WEATHER_OBS_STATION_ERRAIN
 +
|-
 +
| WEATHER_OBS_STATION_ERRORS || WEATHER_OBS_STATION_ERRORS
 +
|-
 +
| WEATHER_OBS_STATION_INFO || WEATHER_OBS_STATION_INFO
 +
|-
 +
| WEATHER_OBS_STATION_LTA || WEATHER_OBS_STATION_LTA
 +
|-
 +
| WEATHER_OBS_STATION_RAW || WEATHER_OBS_STATION_RAW
 +
|-
 +
| WEATHER_OPE_GRID || ...
 +
|-
 +
| WEATHER_OPE_REGIONCOVER || ...
 +
|}

Revision as of 18:23, 28 January 2016




renamed datasets

new table name old table name
CROP_AGGREGATIONS STAT_CROP
CROP_CALENDARS CROP_CALENDAR
CROP_CALENDARS_OLD ...
CROP_PARAMETRIZATIONS ...
CROP_PARAMETRIZATION_PARAMETER ...
CROP_REGIMES ...
CROP_SPATIALIZATIONS ...
CROP_SUITABILITY_RULES ...
CROP_VARIETIES ...
CROP_VARIETY_PARAMETERS ...
CROP_VARIETY_PARAMETERS_OLD ...
CROP_VARIETY_REGIMES ...
DATES_75_15 DATES_75_15
GLOBAL_CATEGORIES ...
GLOBAL_COVERS ...
GLOBAL_COVER_SOURCES ...
GLOBAL_CROPS ...
GLOBAL_CROP_PARAMETERS ...
GLOBAL_GRIDS ...
GLOBAL_GRID_SOURCES ...
GLOBAL_LINK_COVERWINDOW_SOURCE ...
GLOBAL_MODELS ...
GLOBAL_REGIONS ...
GLOBAL_REGION_ELEMENTS ...
GLOBAL_REGION_SOURCES ...
GLOBAL_SOIL_SOURCES ...
GLOBAL_STATISTIC_SOURCES ...
GLOBAL_SUITABILITY_PROPERTIES ...
GLOBAL_THRESHOLDS ...
GLOBAL_TIME_DIMENSIONS ...
GLOBAL_TREATMENTS ...
GLOBAL_WINDOWS ...
GRIDS ...
HRES_YEARS ...
INTERPOLATION_PARAMETERS ...
LINK_CROP_AGGREGATION ...
LINK_CROP_CALENDARS ...
LINK_CROP_PARAMETERS ...
LINK_CROP_PARAMETERS_CROP ...
LINK_CROP_PARAMETERS_MODEL ...
LINK_CROP_PARAMETRIZATION ...
LINK_CROP_SPATIALIZATIONS ...
LINK_CROP_STU ...
LINK_CROP_VARIETY_PARAMETERS ...
LINK_GRID_COVER ...
LINK_GRID_REGION_COVER ...
LINK_REGION_COVER ...
LINK_SIMULATION_UNIT ...
LINK_SIMULATION_UNIT_CROP ...
LINK_SMU_GRID_COVER ...
LINK_SMU_GRID_REGION_COVER ...
LINK_SMU_STU ...
LINK_STU_HORIZONS ...
LINK_STU_WEIGHTED_PARAMETERS ...
LINK_SUITABILITY_RULES ...
REGIONS ...
SIM_BLAST_HRES_GRID ...
SIM_BLAST_HRES_GRID_LTA ...
SIM_BLAST_HRES_REGION ...
SIM_BLAST_HRES_REGION_LTA ...
SIM_WARM_HRES_GRID ...
SIM_WARM_HRES_GRID_LTA ...
SIM_WARM_HRES_REGION ...
SIM_WARM_HRES_REGION_LTA ...
SIM_WOFOST_HRES_EMU ...
SIM_WOFOST_HRES_EMU_LTA ...
SIM_WOFOST_HRES_GRID ...
SIM_WOFOST_HRES_GRID_LTA ...
SIM_WOFOST_HRES_REGION ...
SIM_WOFOST_HRES_REGION_LTA ...
SIM_WOFOST_HRES_STU ...
SOIL_HORIZONS ...
SOIL_INITIAL_WATER ...
SOIL_SMU ...
SOIL_STU ...
STATIONS ...
STAT_REGION_AREAS ...
SYSTABLES SYSTABLES
TASKS TASKS
WEATHER_ERA_GRID WEATHER_ERA_GRID
WEATHER_ERA_GRID_LTA WEATHER_<MODEL>_GRID_LTA
WEATHER_ERA_REGIONCOVER WEATHER_ERA_REGION
WEATHER_ERA_REGIONCOVER_LTA WEATHER_ERA_REGION_LTA
WEATHER_HIS_GRID WEATHER_HIS_GRID
WEATHER_HIS_REGIONCOVER WEATHER_HIS_REGION
WEATHER_HRES_GRID ...
WEATHER_HRES_REGIONCOVER ...
WEATHER_OBS_GRID WEATHER_OBS_GRID
WEATHER_OBS_GRID_INFO WEATHER_OBS_GRID_INFO
WEATHER_OBS_GRID_LTA WEATHER_OBS_GRID_LTA
WEATHER_OBS_GRID_LTA_MISS WEATHER_OBS_GRID_LTA_MISS
WEATHER_OBS_REGCOV_LTA_THRSHLD ...
WEATHER_OBS_REGCOV_THRESHOLDS WEATHER_OBS_REGION_THRES
WEATHER_OBS_REGIONCOVER WEATHER_OBS_REGION
WEATHER_OBS_REGIONCOVER_LTA WEATHER_OBS_REGION_LTA
WEATHER_OBS_STATION WEATHER_OBS_STATION
WEATHER_OBS_STATION_AVAIL WEATHER_OBS_STATION_AVAIL
WEATHER_OBS_STATION_CALCULATED WEATHER_OBS_STATION_CALCULATED
WEATHER_OBS_STATION_ERRAIN WEATHER_OBS_STATION_ERRAIN
WEATHER_OBS_STATION_ERRORS WEATHER_OBS_STATION_ERRORS
WEATHER_OBS_STATION_INFO WEATHER_OBS_STATION_INFO
WEATHER_OBS_STATION_LTA WEATHER_OBS_STATION_LTA
WEATHER_OBS_STATION_RAW WEATHER_OBS_STATION_RAW
WEATHER_OPE_GRID ...
WEATHER_OPE_REGIONCOVER ...