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
act_advisories_flat_history.[rec_resource_id] recreation_resource.[rec_resource_id]
recreation_access_and_sub_access_code_history.[access_code] recreation_access_code.[access_code]
recreation_access_code_history.[access_code] recreation_access_code.[access_code]
recreation_access_history.[access_code] recreation_access_code.[access_code]
recreation_access_history.[id] recreation_access.[id]
recreation_access_history.[rec_resource_id] recreation_resource.[rec_resource_id]
recreation_activity_code_history.[recreation_activity_code] recreation_activity_code.[recreation_activity_code]
recreation_activity_code_trails_history.[rec_resource_id] recreation_resource.[rec_resource_id]
recreation_activity_code_trails_history.[recreation_activity_code] recreation_activity_code.[recreation_activity_code]
recreation_activity_history.[rec_resource_id] recreation_status.[rec_resource_id]
recreation_activity_history.[recreation_activity_code] recreation_activity_code.[recreation_activity_code]
recreation_control_access_code_history.[recreation_control_access_code] recreation_control_access_code.[recreation_control_access_code]
recreation_defined_campsite_history.[recreation_remed_repair_code] recreation_remed_repair_code.[recreation_remed_repair_code]
recreation_district_code_history.[district_code] recreation_district_code.[district_code]
recreation_establishment_order_docs_history.[s3_key] recreation_establishment_order_docs.[s3_key]
recreation_feature_code_history.[recreation_feature_code] recreation_feature_code.[recreation_feature_code]
recreation_feature_history.[rec_resource_id] recreation_resource.[rec_resource_id]
recreation_feature_history.[recreation_feature_code] recreation_feature_code.[recreation_feature_code]
recreation_fee_code_history.[recreation_fee_code] recreation_fee_code.[recreation_fee_code]
recreation_fee_history.[rec_resource_id] recreation_status.[rec_resource_id]
recreation_fee_history.[recreation_fee_code] recreation_fee_code.[recreation_fee_code]
recreation_fee_sub_code_history.[recreation_fee_code] recreation_fee_code.[recreation_fee_code]
recreation_image_consent_form_history.[consent_id] recreation_image_consent_form.[consent_id]
recreation_image_consent_form_history.[doc_id] recreation_resource_document.[doc_id]
recreation_image_consent_form_history.[image_id] recreation_resource_image.[image_id]
recreation_image_consent_form_history.[photographer_type_code] recreation_photographer_type_code.[photographer_type_code]
recreation_maintenance_standard_code_history.[maintenance_standard_code] recreation_maintenance_standard_code.[maintenance_standard_code]
recreation_map_feature.[amendment_id] recreation_access.[id]
recreation_map_feature_geom.[map_feature_id] recreation_access.[id]
recreation_map_feature_geom_history.[map_feature_id] recreation_access.[id]
recreation_map_feature_history.[amendment_id] recreation_access.[id]
recreation_photographer_type_code_history.[photographer_type_code] recreation_photographer_type_code.[photographer_type_code]
recreation_remed_repair_code_history.[recreation_remed_repair_code] recreation_remed_repair_code.[recreation_remed_repair_code]
recreation_resource_doc_code_history.[doc_code] recreation_resource_doc_code.[doc_code]
recreation_resource_docs_history.[doc_code] recreation_resource_doc_code.[doc_code]
recreation_resource_document_history.[doc_code] recreation_resource_doc_code.[doc_code]
recreation_resource_document_history.[doc_id] recreation_resource_document.[doc_id]
recreation_resource_history.[district_code] recreation_district_code.[district_code]
recreation_resource_history.[maintenance_standard_code] recreation_maintenance_standard_code.[maintenance_standard_code]
recreation_resource_history.[rec_resource_id] recreation_resource.[rec_resource_id]
recreation_resource_history.[risk_rating_code] recreation_risk_rating_code.[risk_rating_code]
recreation_resource_image_history.[image_id] recreation_resource_image.[image_id]
recreation_resource_status_code_history.[recreation_resource_status_code] recreation_resource_status_code.[recreation_resource_status_code]
recreation_resource_type_code_history.[rec_resource_type_code] recreation_resource_type_code.[rec_resource_type_code]
recreation_risk_rating_code_history.[risk_rating_code] recreation_risk_rating_code.[risk_rating_code]
recreation_status_code_history.[status_code] recreation_status_code.[status_code]
recreation_status_history.[rec_resource_id] recreation_status.[rec_resource_id]
recreation_status_history.[status_code] recreation_status_code.[status_code]
recreation_structure_code_history.[structure_code] recreation_structure_code.[structure_code]
recreation_structure_history.[rec_resource_id] recreation_resource.[rec_resource_id]
recreation_structure_history.[structure_code] recreation_structure_code.[structure_code]

Tables without indexes

Table Rows
act_advisories_flat_history -1
natural_resource_org_unit_history -1
recreation_access_and_sub_access_code_history -1
recreation_access_code_history -1
recreation_access_history -1
recreation_activity_code_history -1
recreation_activity_code_trails_history -1
recreation_activity_history -1
recreation_agreement_holder_history -1
recreation_control_access_code_history -1
recreation_defined_campsite_history -1
recreation_district_code_history -1
recreation_driving_direction_history -1
recreation_establishment_order_docs_history -1
recreation_feature_code_history -1
recreation_feature_history -1
recreation_fee_code_history -1
recreation_fee_history -1
recreation_fee_sub_code_history -1
recreation_image_consent_form_history -1
recreation_maintenance_standard_code_history -1
recreation_map_feature_geom_history -1
recreation_map_feature_history -1
recreation_photographer_type_code_history -1
recreation_remed_repair_code_history -1
recreation_resource_doc_code_history -1
recreation_resource_docs_history -1
recreation_resource_document_history -1
recreation_resource_history -1
recreation_resource_image_history -1
recreation_resource_image_variants_history -1
recreation_resource_images_history -1
recreation_resource_reservation_info_history -1
recreation_resource_status_code_history -1
recreation_resource_type_code_history -1
recreation_risk_rating_code_history -1
recreation_site_description_history -1
recreation_site_point_history -1
recreation_status_code_history -1
recreation_status_history -1
recreation_structure_code_history -1
recreation_structure_history -1
recreation_sub_access_code_history -1

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
Anomaly not detected

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

Table
Anomaly not detected