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
additional_method_info.[action_num] action.[action_num]
additional_method_info.[variable_num] variable.[variable_num]
d_affiliation.[affiliation_num] affiliation.[affiliation_num]
d_affiliation.[organization_num] organization.[organization_num]
d_affiliation.[person_num] person.[person_num]
d_author_list.[author_list_num] author_list.[author_list_num]
d_author_list.[person_num] person.[person_num]
d_citation_external_identifier.[external_identifier_system_num] external_identifier_system.[external_identifier_system_num]
d_ec_status_info.[ec_status_info_num] ec_status_info.[ec_status_info_num]
d_organization.[country_num] country.[country_num]
d_organization.[organization_num] organization.[organization_num]
d_organization.[organization_type_num] organization_type.[organization_type_num]
d_person.[person_num] person.[person_num]
external_identifier_system.[external_identifier_system_organization_num] organization.[organization_num]
seddb_affiliation.[person_num] person.[person_num]

Tables without indexes

Table Rows
d1 11988
d_affiliation 305
d_author_list 726
d_citation 148
d_citation_external_identifier 135
d_ec_status_info 150
d_organization 1277
d_person 4934
datasource 665
gma_term_map 0
lab 771
seddb_affiliation 1352
tmp_3904_igsn 514
tmp_fe_mo 586
tmp_latlong 68

Tables that contain a single column

Table Column
d1 sample

Tables with incrementing column names, potentially indicating denormalization

Table
d_organization
organization

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

Table
Anomaly not detected