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
catalog_item_location_pricing.[legacy_practice_location_id] schema_migrations.[id]
catalog_item_location_pricing.[practice_location_id] schema_migrations.[id]
catalog_item_lots.[legacy_item_lot_id] schema_migrations.[id]
catalog_item_lots.[practice_location_id] schema_migrations.[id]
catalog_item_provider_mappings.[legacy_provider_id] schema_migrations.[id]
catalog_item_provider_mappings.[practice_location_id] schema_migrations.[id]
catalog_item_provider_mappings.[provider_id] schema_migrations.[id]
catalog_items.[legacy_fee_id] schema_migrations.[id]
catalog_items.[legacy_item_id] schema_migrations.[id]
catalog_items.[legacy_practice_service_type_id] schema_migrations.[id]
catalog_items.[legacy_service_id] schema_migrations.[id]
catalog_items.[manufacturer_id] schema_migrations.[id]
catalog_items.[practice_id] schema_migrations.[id]
gift_card_definition_locations.[practice_location_id] schema_migrations.[id]
gift_card_definitions.[practice_id] schema_migrations.[id]
gift_card_ledger_entries.[actor_user_id] schema_migrations.[id]
gift_card_ledger_entries.[source_id] schema_migrations.[id]
gift_cards.[location_id] schema_migrations.[id]
gift_cards.[patient_id] schema_migrations.[id]
gift_cards.[practice_id] schema_migrations.[id]
loyalty_point_adjustments.[actor_user_id] schema_migrations.[id]
loyalty_point_adjustments.[source_id] schema_migrations.[id]
loyalty_profiles.[patient_id] schema_migrations.[id]
loyalty_profiles.[practice_id] schema_migrations.[id]
native_payment_transactions.[checkout_id] schema_migrations.[id]
native_payment_transactions.[gateway_transaction_id] schema_migrations.[id]
native_payment_transactions.[invoice_id] schema_migrations.[id]
native_payment_transactions.[location_id] schema_migrations.[id]
native_payment_transactions.[patient_id] schema_migrations.[id]
native_payment_transactions.[practice_id] schema_migrations.[id]
native_payment_transactions.[processor_id] schema_migrations.[id]
notification_user_states.[user_id] schema_migrations.[id]
notifications.[location_id] schema_migrations.[id]
notifications.[practice_id] schema_migrations.[id]
notifications.[source_entity_id] schema_migrations.[id]
package_definition_location_prices.[practice_location_id] schema_migrations.[id]
package_definitions.[practice_id] schema_migrations.[id]
package_items.[catalog_item_id] schema_migrations.[id]
package_ledger_entries.[actor_user_id] schema_migrations.[id]
package_ledger_entries.[source_id] schema_migrations.[id]
patient_files.[created_by_user_id] schema_migrations.[id]
patient_files.[deleted_by_user_id] schema_migrations.[id]
patient_files.[patient_id] schema_migrations.[id]
patient_files.[practice_id] schema_migrations.[id]
patient_package_instances.[location_id] schema_migrations.[id]
patient_package_instances.[patient_id] schema_migrations.[id]
patient_package_instances.[practice_id] schema_migrations.[id]
patient_package_instances.[source_checkout_id] schema_migrations.[id]
patient_package_instances.[source_invoice_id] schema_migrations.[id]
patient_package_instances.[source_payment_id] schema_migrations.[id]
patient_package_item_balances.[catalog_item_id] schema_migrations.[id]
patient_portal_accounts.[legacy_patient_id] schema_migrations.[id]
patient_portal_accounts.[legacy_user_id] schema_migrations.[id]
patient_portal_provider_links.[legacy_provider_id] schema_migrations.[id]
payment_gateway_configs.[location_id] schema_migrations.[id]
payment_gateway_configs.[practice_id] schema_migrations.[id]
payment_gateway_configs.[private_api_key_secret_id] schema_migrations.[id]
payment_gateway_configs.[processor_id] schema_migrations.[id]
promotion_applications.[actor_user_id] schema_migrations.[id]
promotion_applications.[catalog_item_id] schema_migrations.[id]
promotion_applications.[line_id] schema_migrations.[id]
promotion_applications.[location_id] schema_migrations.[id]
promotion_applications.[patient_id] schema_migrations.[id]
promotion_applications.[practice_id] schema_migrations.[id]
promotion_applications.[source_checkout_id] schema_migrations.[id]
promotion_applications.[source_id] schema_migrations.[id]
promotion_applications.[source_invoice_id] schema_migrations.[id]
promotion_definitions.[practice_id] schema_migrations.[id]
promotion_linked_items.[catalog_item_id] schema_migrations.[id]
rbac_audit_events.[actor_user_id] schema_migrations.[id]
rbac_audit_events.[practice_id] schema_migrations.[id]
rbac_audit_events.[target_id] schema_migrations.[id]
rbac_role_emulation_grants.[granted_by_user_id] schema_migrations.[id]
rbac_role_emulation_grants.[practice_id] schema_migrations.[id]
rbac_roles.[practice_id] schema_migrations.[id]
rbac_users.[legacy_user_id] schema_migrations.[id]
rbac_users.[practice_id] schema_migrations.[id]

Tables without indexes

Table
Anomaly not detected

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