# 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