How to Build a Business Rules Engine

Tables that are not reference tables may be related to reference tables. If so, the

primary key of the reference table will be migrated into the table. The previous

chapter described ways in which foreign keys can be recognized, including how to

identify the parent table and the parent column for such migrated columns. However,

it is also necessary to know whether a foreign key belongs to a reference table. To

achieve this level of detail it is necessary to add another attribute to the Column

entity:

䊏

Column Reference Table FK Indicator: This indicates whether a foreign key in a

table that is not a reference table is a migrated key from a table that ...