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
batch_job_execution_params.[parameter_type] m_external_event_configuration.[type]
m_business_date.[type] m_external_event_configuration.[type]
m_external_event.[type] m_external_event_configuration.[type]
m_loan.[buy_down_fee_calculation_type] m_external_event_configuration.[type]
m_loan.[buy_down_fee_income_type] m_external_event_configuration.[type]
m_loan.[capitalized_income_calculation_type] m_external_event_configuration.[type]
m_loan_reage_parameter.[frequency_type] m_external_event_configuration.[type]
m_product_loan.[buy_down_fee_calculation_type] m_external_event_configuration.[type]
m_product_loan.[buy_down_fee_income_type] m_external_event_configuration.[type]
m_product_loan.[capitalized_income_calculation_type] m_external_event_configuration.[type]

Tables without indexes

Table Rows
databasechangelog 2065
m_trial_balance -1
oauth_access_token -1
oauth_refresh_token -1

Tables that contain a single column

Table Column
rpt_sequence id

Tables with incrementing column names, potentially indicating denormalization

Table
m_address
m_guarantor

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

Table
Anomaly not detected