You would need another table for that one to many. But I think this discussion has split.
One thought for the album license is a license on the album itself no matter that not even one of the songs on the license has that license. And another thought is for an album license that indicates the license(s) of the songs on the album no matter if the license on the album as opposed to the songs is something else. (Even if this is technically less correct. As I say, I could care less if the "album is licensed BY-SA when every song on it is licensed BY-NC-ND. To me, this is not a Free album even if the license on the "album" is Free.) I think we should concern ourselves with the latter if we are going to use the album as the "atom"? Otherwise, give up on the album/license and store a license for each song and do the queries per song and not per album? drew On Tue, Apr 21, 2009 at 12:47 AM, Ryan Prior <[email protected]> wrote: > On Mon, Apr 20, 2009 at 4:29 PM, drew Roberts <[email protected]> wrote: >> Fine except there is no such beast as SA-ND as those are mutually >> exclusive terms. Will doing that cause more confusion? The idea does >> have some merit though. Perhaps store two licenses in the case of >> multi licensed albums? The most Free (argument) and the most non-Free >> (another argument) ??? >> >> drew > > Perhaps a reasonable approach would be to say "licenses used" instead > of "license" -- then you just have to check the "licenses used" for an > unsuitable license to know you don't want to look at the album. > "select all from albums where licenses_used contains only CC-0 or > CC-BY or CC-BY-SA" for example. > > Is that a one-to-many relationship? Is that something relational > databases doesn't do? Surely it could be made to work. > _______________________________________________ > Libre-fm mailing list > [email protected] > http://lists.autonomo.us/mailman/listinfo/libre-fm > -- http://zotzbro.blogspot.com/ _______________________________________________ Libre-fm mailing list [email protected] http://lists.autonomo.us/mailman/listinfo/libre-fm
