lets say I have table A and table B. Table B is the child table and has a foreign key to table A. I have other mirrored tables, lets say table C(mirror for table A) and table D(mirror for B). Both tables B and D have a foreign key to its respective table. I have created a trigger on table A in order when its inserted on table A, the trigger inserts the same on table C and the same for table B for table D. My doubt is that in the same transaction, I insert on tables A and B, and maybe the trigger for table B could execute first than the trigger for table A causing an error on table D because the parent foreign key is not found yet on table C. Can it happen and how can I fix it?.