Hi all,

Recently i was having a discussion with my development team and design managers regarding one of our application module (say in schema MNT) which seems to have a child table refering to a parent table in different application module (say schema PCH). (We have seperated the application modules into their individual schemas) . Since our construction hasn't started yet, its still in HLD phase, we have the change to fix it.

What i wanted to know is, what will be the impact of having a child and a parent in different application modules (schema) ??

I was thinking that the interdependency should take place at the application level not on the database level.

Any way im not so sure, your thoughts please.