Static data table is not static
Published 06 March 2025
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
- Check your options file - locate the table under
staticDataTables
- Review the table structure - identify any foreign keys pointing to other tables
- 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)