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
analysis_log_per_rentals.[kimaroom_rental_id] job_batches.[id]
estimation_jsb_details.[campus_pref_id] job_batches.[id]
files.[fileable_id] migrations.[id]
inquiry_rentals.[media_rental_id] job_batches.[id]
inquiry_rentals.[rental_id] job_batches.[id]
jsb_campuses.[pref_id] migrations.[id]
line_users.[line_user_id] job_batches.[id]
staffs.[login_id] job_batches.[id]
suggestions.[media_rental_id] job_batches.[id]
suggestions.[rental_id] job_batches.[id]
temporary_obic_customer_basic.[campus_code] access_control_targets.[code]
temporary_obic_customer_basic.[campus_department_code] access_control_targets.[code]
temporary_obic_customer_basic.[campus_grade_code] access_control_targets.[code]
temporary_obic_customer_basic.[tenant_relationship_code] access_control_targets.[code]
web_meetings.[meeting_id] job_batches.[id]

Tables without indexes

Table Rows
telescope_monitoring 0

Tables that contain a single column

Table Column
telescope_monitoring

Tables with incrementing column names, potentially indicating denormalization

Table
aggregation_candidates
analysis_summary_fields
analysis_summary_records
customer_interaction_histories
customers
inquiries
relationship_candidates
temporary_obic_customer_basic
visit_reservations

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

Table
Anomaly not detected