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
crm_companies.[company_id] crm_meeting.[id]
crm_companies.[crm_owner_id] crm_meeting.[id]
crm_contacts.[contact_id] crm_meeting.[id]
crm_deals.[crm_owner_id] crm_meeting.[id]
crm_deals.[deal_id] crm_meeting.[id]
crm_email_engagements.[email_id] crm_meeting.[id]
crm_note_engagements.[associated_external_calendar_id] crm_meeting.[id]
crm_note_engagements.[associated_meeting_source_id] crm_meeting.[id]
crm_note_engagements.[note_id] crm_meeting.[id]
crm_owners.[owner_id] crm_meeting.[id]
crm_rep.[rep_id] crm_meeting.[id]
customer_integration.[zoom_recall_id] crm_meeting.[id]
device.[device_id] crm_meeting.[id]
integration_settings_salesforce.[user_id] crm_meeting.[id]
share_activity_data.[generated_note_id] crm_meeting.[id]
user_integration.[zoom_recall_id] crm_meeting.[id]

Tables without indexes

Table Rows
campaign_group_association -1
temp_calendar_event 327

Tables that contain a single column

Table Column
alembic_version version_num

Tables with incrementing column names, potentially indicating denormalization

Table
Anomaly not detected

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

Table
Anomaly not detected