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
Button.[ButtonGroupID] ButtonGroup.[ButtonGroupID]
ButtonGroup.[ToolbarID] Toolbar.[ToolbarID]
CategoryTemplate.[OrganisationID] Organisation.[OrganisationID]
CategoryTextHistory.[CategoryTextID] CategoryTextzzz.[CategoryTextID]
DropboxImages.[DropboxIntegrationID] DropboxIntegration.[DropboxIntegrationID]
DropboxImportHistory.[DropboxIntegrationID] DropboxIntegration.[DropboxIntegrationID]
DropboxImportHistory.[OrganisationID] Organisation.[OrganisationID]
DropboxIntegration.[OrganisationID] Organisation.[OrganisationID]
ElefantTemplate.[OrganisationID] Organisation.[OrganisationID]
ExportHistory.[OrganisationID] Organisation.[OrganisationID]
ExportHistoryOLD.[OrganisationID] Organisation.[OrganisationID]
FeaturePackageLink.[FeatureID] Feature.[FeatureID]
InviteUserToken.[organisationID] Organisation.[OrganisationID]
LoginTracker.[OrganisationID] Organisation.[OrganisationID]
PopupCampaignItem.[PopupCampaignID] PopupCampaign.[PopupCampaignID]
PopupCampaignItem.[PopupContentID] PopupContent.[PopupContentID]
Product.[OrganisationID] Organisation.[OrganisationID]
ProductBlobs.[OrganisationID] Organisation.[OrganisationID]
ProductInstance.[ProductID] Product.[ProductID]
ProductsLog.[OrganisationID] Organisation.[OrganisationID]
Report.[ReportCategoryID] ReportCategory.[ReportCategoryID]
sessions.[panelGUID] Pairing.[panelGUID]
Subscription.[OrganisationID] Organisation.[OrganisationID]
telescope_entries.[batch_id] notifications.[id]
TextBlock.[OrganisationID] Organisation.[OrganisationID]
Unit.[OrganisationID] Organisation.[OrganisationID]
User.[OrganisationID] Organisation.[OrganisationID]
UserCampaign.[PopupCampaignID] PopupCampaign.[PopupCampaignID]
UserOrganisation.[OrganisationID] Organisation.[OrganisationID]
UserOrganisation.[RoleID] Role.[RoleID]
WP_Integration.[OrganisationID] Organisation.[OrganisationID]

Tables without indexes

Table Rows
telescope_monitoring 0

Tables that contain a single column

Table Column
telescope_monitoring tag

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