I have a fairly classic Parent/Child mapping relationship that I'm using to manage "media" (child) for individual "providers" (parent). Each "provider" parent will have one or more "media" children, and the media can be transient in nature.
Here's the problem -- I really want another parent table to maintain a "master" index of media information (things like title, artist, album, genre, etc.). Example: any number of "provider" parents could have the same "media" entries, and I'd like to maintain some "master" index to catalog this information in a central/persistent location.
So, if I add a new provider or update an existing one to the system, I'd like to:
1. Add/update all "media" children for the "provider".
2. Add any unique/new media records in another "master" parent table.
The parent-child relationship between "provider" and "media" is very simple and works beautifully, but I'm not even sure where to start with the "master" table.
Any ideas?
|