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

Delete entity, good way to unwire/unassociate from another entity

 
Theodore David Williams
Ranch Hand
Posts: 102
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Given the following 2 tables:
Car
- Id
- Name
- Engine_Id

Engine
- Id
- Type


The relationship is a one to one for car to engine and the car table has a foreign key to engine table.

When I delete an engine:


I will run into problems if I do not remove the association to the car so i need


I was hoping that I could use a PreRemove to make this a little more clean, but I do not think it works with the foreign key in Car


Is there anything I can do that would 'automatically remove the engine_id foreign key in the car table when I delete and engine?

Thanks.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic