Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database Circular Reference

 
Susan
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

could somebody please explain what a database circular reference is, and what design shortcomings it has?

thanks,

Susan
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Table A has an FK to Table B. Table B has an FK to Table A. If I try to delete a record from Table A the delete will fail, because the record is referenced in Table B. If I try to delete a record from Table B the delete will fail because the record is referenced in Table A.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic