Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
cabah_AnalysisUnit.[UNITID] global_UnitMaster.[UNITID]
crn_aus_basins.[OAID] global_Author.[OAID]
crn_aus_basins.[PROJEPSGID] crn_projepsgID.[PROJEPSGID]
crn_aus_basins.[STUDYID] crn_studynote.[STUDYID]
crn_aus_outlets.[STUDYID] crn_studynote.[STUDYID]
crn_inprep_basins.[PROJEPSGID] crn_projepsgID.[PROJEPSGID]
crn_inprep_basins.[STUDYID] crn_studynote.[STUDYID]
crn_inprep_outlets.[STUDYID] crn_studynote.[STUDYID]
crn_int_basins.[OAID] global_Author.[OAID]
crn_int_basins.[PROJEPSGID] crn_projepsgID.[PROJEPSGID]
crn_int_basins.[STUDYID] crn_studynote.[STUDYID]
crn_int_outlets.[STUDYID] crn_studynote.[STUDYID]
crn_studies_boundingbox.[STUDYID] crn_studynote.[STUDYID]
crn_xxl_basins.[OAID] global_Author.[OAID]
crn_xxl_basins.[PROJEPSGID] crn_projepsgID.[PROJEPSGID]
crn_xxl_basins.[STUDYID] crn_studynote.[STUDYID]
crn_xxl_outlets.[STUDYID] crn_studynote.[STUDYID]
expage.[METASITEID] global_MetaSite.[METASITEID]
expage.[SITEID] global_SiteMaster.[SITEID]
fossahul_webmercator_nrand_25000.[METASITEID] global_MetaSite.[METASITEID]
fossahul_webmercator_nrand_25000.[SITEID] global_SiteMaster.[SITEID]
ippd_baseline_pollen.[CHRONLGYID] neo_chronologies.[CHRONLGYID]
ippd_baseline_pollen.[DATAID] ippd_DataCore.[DATAID]
ippd_baseline_pollen.[DATASETID] global_DataSetMaster.[DATASETID]
ippd_baseline_pollen.[SITEID] global_SiteMaster.[SITEID]
ippd_baseline_pollen.[UNITID] global_UnitMaster.[UNITID]
ippd_datasets.[DATASETID] global_DataSetMaster.[DATASETID]
ippd_datasets.[METASITEID] global_MetaSite.[METASITEID]
ippd_datasets.[OAID] global_Author.[OAID]
ippd_datasets.[PRME_OAID] global_Author.[OAID]
ippd_datasets.[SITEID] global_SiteMaster.[SITEID]
ippd_datasets.[UNITID] global_UnitMaster.[UNITID]
neo_chronologies.[NEO_UNITID] global_UnitMaster.[UNITID]
sahularch_c14.[METASITEID] global_MetaSite.[METASITEID]
sahularch_c14.[SITEID] global_SiteMaster.[SITEID]
sahularch_osl.[METASITEID] global_MetaSite.[METASITEID]
sahularch_osl.[SITEID] global_SiteMaster.[SITEID]
sahularch_tl.[METASITEID] global_MetaSite.[METASITEID]
sahularch_tl.[SITEID] global_SiteMaster.[SITEID]
sahulchar.[METASITEID] global_MetaSite.[METASITEID]
sahulchar.[OBSID] char_DataCore.[OBSID]
sahulchar.[SITEID] global_SiteMaster.[SITEID]
sahulchar.[SMPID] char_Sample.[SMPID]
sahulchar.[UNITID] global_UnitMaster.[UNITID]
sahulchar_units.[METASITEID] global_MetaSite.[METASITEID]
sahulchar_units.[OAID] global_Author.[OAID]
sahulchar_units.[SITEID] global_SiteMaster.[SITEID]
sahulchar_units.[UNITID] global_UnitMaster.[UNITID]
sahulchar_units_points_EPSG3857.[UNITID] global_UnitMaster.[UNITID]
sahulsed_aeolian_osl.[METASITEID] global_MetaSite.[METASITEID]
sahulsed_aeolian_osl.[SITEID] global_SiteMaster.[SITEID]
sahulsed_aeolian_tl.[METASITEID] global_MetaSite.[METASITEID]
sahulsed_aeolian_tl.[SITEID] global_SiteMaster.[SITEID]
sahulsed_coastal_osl.[SITEID] global_SiteMaster.[SITEID]
sahulsed_coastal_tl.[SITEID] global_SiteMaster.[SITEID]
sahulsed_fluvial_osl.[METASITEID] global_MetaSite.[METASITEID]
sahulsed_fluvial_osl.[SITEID] global_SiteMaster.[SITEID]
sahulsed_fluvial_tl.[METASITEID] global_MetaSite.[METASITEID]
sahulsed_fluvial_tl.[SITEID] global_SiteMaster.[SITEID]
sahulsed_lacustrine_osl.[METASITEID] global_MetaSite.[METASITEID]
sahulsed_lacustrine_osl.[SITEID] global_SiteMaster.[SITEID]
sahulsed_lacustrine_tl.[METASITEID] global_MetaSite.[METASITEID]
sahulsed_lacustrine_tl.[SITEID] global_SiteMaster.[SITEID]

Tables without indexes

Table Rows
downloadlogs 0

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
arch_c14_DataCore
arch_c14_polygons_EPSG3857
arch_osl_DataCore
arch_osl_polygons_EPSG3857
arch_tl_DataCore
arch_tl_polygons_EPSG3857
char_DataCore
crn_al_DataCore
crn_aus_basins
crn_aus_outlets
crn_be_DataCore
crn_inprep_basins
crn_inprep_outlets
crn_int_basins
crn_int_outlets
crn_v3_basins_EPSG3857
crn_v3_outlets_EPSG3857
crn_xxl_basins
crn_xxl_outlets
expage
expage_DataCore
expage_points_EPSG3857
fos_DataCore
fos_polygons_EPSG3857
fossahul_webmercator_nrand_25000
global_rivID
global_SiteMaster
ippd_datasets
publications
sahularch_c14
sahularch_osl
sahularch_tl
sahulchar
sahulchar_units
sahulsed_aeolian_osl
sahulsed_aeolian_tl
sahulsed_coastal_osl
sahulsed_coastal_tl
sahulsed_fluvial_osl
sahulsed_fluvial_tl
sahulsed_lacustrine_osl
sahulsed_lacustrine_tl
sed-osl_DataCore
sed-osl_points_EPSG3857
sed-tl_DataCore
sed-tl_points_EPSG3857

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected