5 Replies Latest reply: Jan 3, 2013 11:03 AM by user5631283 RSS

    Cross model foreign keys?

      We are planning a project to reverse engineer our (rather old) database using SQLDeveloper DM. We see this as key to improving our data management. I have however an issue. When doing the reverse engineering exercise, I want to split the data model into more or less logical units (these units will become very relevant for future projects). I can choose from two options I think:

      1) Import the complete DD. This will be a bit messy since we don't have many FKs. Objects can than be selected into 'views' that represent these logical units.
      2) Create a separate model for each logical unit.

      Option 2 has some benefits for me (like a smaller model, more relevant for dedicated offshore development teams) but has an issue, foreign key constraints between models. Is it possible to create those using DM?