magnusandy / 355DatabaseSQL

0 stars 1 forks source link

Trigger: on update to t_item_locations, possibly update exhibition items. #30

Open RyanLaForge opened 9 years ago

RyanLaForge commented 9 years ago

Event: Update to t_item_locations, to the enddate for an item in that location. Condition: The item is part of an exhibition in that location. Action: If the item is no longer a part of that exhibition pull it out. else extend the date for the item to be in that exhibition.

***Discussion: What if we have no new location for that item?