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
analise_proposta.[id_proposta] proposta.[id_proposta]
categoria_despesa_proposta.[id_proposta] proposta.[id_proposta]
classificacao_ingresso.[id_parceria_conta] parceria_conta.[id_parceria_conta]
cronograma_desembolso.[id_proposta] proposta.[id_proposta]
item_proposta.[id_classificacao_despesa] classificacao_despesa.[id_classificacao_despesa]

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
beneficiario_emenda_parlamentar_programa
classificacao_despesa

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

Table
Anomaly not detected