• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Circle in DB

 
avihai marchiano
Ranch Hand
Posts: 342
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey,

As I understand from DBA and it also make sense it�s a bad practice to have DB circle, means that A has FK to B and B has FK to A.

In some case I have in Object A :
1. List of B (OneToMany)
2. Reference to class B (OneToOne)

In this case I will have circle in the DB because A has FK to B due to section 2 above and B has FK to A due to section 1 above.

I will be happy to hear your opinion about this issue.

Thank you
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic