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
tbl_finance_project.[area] tbl_lookup_area.[area]
tbl_finance_project.[fund] tbl_lookup_fund.[fund]
tbl_finance_project_dated_summary.[currency] tbl_currency.[currency]
tbl_finance_project_summary_temp.[currency] tbl_currency.[currency]
tbl_invoice_temp.[tl_currency] tbl_currency.[currency]
tbl_sales_temp.[tl_currency] tbl_currency.[currency]
tbl_slip_exp.[staff_position] tbl_positions.[position]
tbl_staff_lookup.[cost_centre] tbl_cost_centre.[cost_centre]
tbl_staff_lookup.[location] tbl_location.[location]
tbl_tender_episode_data.[department] tbl_lookup_department.[department]
tbl_view_time_sheets_by_day.[cost_centre] tbl_cost_centre.[cost_centre]
tbl_view_time_sheets_by_day.[staff_position] tbl_positions.[position]
tbl_view_time_sheets_by_week.[cost_centre] tbl_cost_centre.[cost_centre]
tbl_view_time_sheets_by_week.[staff_position] tbl_positions.[position]

Tables without indexes

Table Rows
tbl_allocations 1546
tbl_finance_project_summary_temp 29940
tbl_invoice_temp 26490
tbl_project_recost_range 1
tbl_sales_temp 5307
tbl_staff_positions 5710
tbl_tender_episode_data 6014

Tables that contain a single column

Table Column
tbl_lookup_department
tbl_lookup_invoice_type
tbl_lookup_project_type
tbl_markup

Tables with incrementing column names, potentially indicating denormalization

Table
tbl_finance_project_dated_summary
tbl_finance_project_summary
tbl_finance_project_summary_temp

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

Table
Anomaly not detected