Static data table is not static

A table is defined as a static data table, but it has foreign keys pointing to other tables. Static data tables should have no outgoing foreign key relationships.

How to fix

  1. Check your options file - locate the table under staticDataTables
  2. Review the table structure - identify any foreign keys pointing to other tables
  3. Remove from static data tables - delete the table from the staticDataTables array

Understanding static data tables

What they are: Reference tables with no outgoing foreign keys (e.g., Countries, Status codes)

What they're not: Tables that reference other tables through foreign keys

Purpose: Static data tables are included in full, but only their incoming relationships are followed

Common examples

True static data: Countries, StatusCodes, ProductCategories

Not static data: Orders (references Customers), Users (references Departments)



Didn't find what you were looking for?