SchemaSpy Analysis of cxgn.sgn_people - 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:
5 instances of anomaly detectedTable Rows clone_validation_log 0 clone_verification_log 379 sp_clone_il_mapping_segment_log 8 sp_group_member 483 sp_project_il_mapping_clone_log 2,199 -
Columns that are flagged as both 'nullable' and 'must be unique':
5 instances of anomaly detectedColumn bac_status.bac_id sp_login_old.username sp_person.cookie_string sp_person.cookie_string sp_person.username -
Tables that contain a single column:
Anomaly not detected -
Tables with incrementing column names, potentially indicating denormalization:
1 instance of anomaly detectedTable user_map -
Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
Anomaly not detected