Timeline for Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 2, 2012 at 22:44 | vote | accept | ypercubeᵀᴹ | ||
| May 15, 2012 at 20:04 | comment | added | A-K | @ypercube When you delete a tag, you do need to check and possibly switch to another tag linking the same Book and Aspect. When you insert new tags, however, there is no need to do any checks until you need to insert a rating. | |
| May 15, 2012 at 19:50 | comment | added | ypercubeᵀᴹ |
Oh nice. The only issue I can think is the complexity introduced in inserting/deleting BookTags and TagAspects. Every time a new BookTag (or TagAspect) is removed for example, a search has to be done to remove corresponding rows in this table and/or change the TagID to another Tag that is related to the same BookAspect combination. And similar search would have to be done for inserting into those 2 tables. But complex rules require complex procedures, so this looks really good.
|
|
| May 15, 2012 at 16:58 | history | edited | A-K | CC BY-SA 3.0 |
added 72 characters in body
|
| May 15, 2012 at 16:08 | history | answered | A-K | CC BY-SA 3.0 |