Difference between revisions of "Appendix 5: Database objects"
From Agri4castWiki
Wimdewinter (talk | contribs) |
Wimdewinter (talk | contribs) (→renamed datasets) |
||
| Line 9: | Line 9: | ||
== renamed datasets == | == renamed datasets == | ||
{| class='wikitable' | {| class='wikitable' | ||
| + | !old table name | ||
!new table name | !new table name | ||
| − | |||
| − | |||
|- | |- | ||
| CROP_AGGREGATIONS || STAT_CROP | | CROP_AGGREGATIONS || STAT_CROP | ||
Revision as of 14:59, 7 March 2016
- CGMS14xxx database objects
- CGMS14SYS database objects
- GWSI_E_12 database objects
- CGMS12xxx database objects (legacy)
renamed datasets
| old table name | new 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 | ... |
