SchemaSpy Analysis of webco_4.3.1.public - Anomalies | Generated by SchemaSpy |
Things that might not be 'quite right' about your schema: |
|
-
Columns whose name and type imply a relationship to another table's primary key:
Anomaly not detected -
Tables without indexes:
Table Rows bibliographic_record_helix_ext 0 resource_container_tcm 0 resource_parent 0 wco_version 1 -
Columns that are flagged as both 'nullable' and 'must be unique':
Column authentication.pin_hash freelancer_person_location.location_oid freelancer_person_location.person_oid person.barcode person.userid person.userid person_location_signature.location_oid person_location_signature.person_oid pir_person_location.location_oid pir_person_location.person_oid resource.barcode resource.foreignid resource_controller.device_id wco_group.foreignid -
Tables that contain a single column:
Table Column group_set obj_oid resource_sleep_queue obj_oid resource_wake_queue obj_oid wco_version version -
Tables with incrementing column names, potentially indicating denormalization:
Table department department_ext organization person person_ext wco_group -
Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
Anomaly not detected