SchemaSpy Analysis of cxgn.phenome - Anomalies

Generated by
SchemaSpy


Things that might not be 'quite right' about your schema:	Please support this project

Columns whose name and type imply a relationship to another table's primary key:
Anomaly not detected
Tables without indexes:
Anomaly not detected

Columns that are flagged as both 'nullable' and 'must be unique':

Column
dbxref_type.dbxref_type_definition
dbxref_type.dbxref_type_name
dbxref_type.dbxref_type_url
image.image_file_name
locus_registry.locus_id
locus_registry.registry_id
phenotype_term.phenotype_id
phenotype_term.term_id
population.name
variant.variant_gi

10 instances of anomaly detected

Tables that contain a single column:
Anomaly not detected
Tables with incrementing column names, potentially indicating denormalization:
Anomaly not detected
Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
Anomaly not detected