Creating metamodel issue

Question

Hi Team,

I'm creating metamodel using meta-web. I am able to select some of the tables used for both physical model and business model. After that I suppose that the foreign key should be detected correctly. However only partial of them are detected: I select 5 tables for physical model but 4 of them showing no FK, though i'm sure the FK is set (checked by mysql workbench). And no error log related to the case is found.

Is there anyone know the possible reason? What should I do to fix this issue? Thanks in advance.

Comments

Did you check that the four tables that don't have the FK are pointing to tables that are NOT included in the physical table?

---

Say I select table A, B, C, D, E for business and physical model. Table E have 9 FKs in total and 7 of them pointing to A/B/C/D, thus metaweb detected 7 FKs. I suppose that some of the A,B,C,D tables' FKs which are pointing to tables A-E should be detected (similar to table E), but none appears in FK tab.