>I'm just designing a database and have stumbled on a situation where I am
>torn between approaches and I'd like some experienced input ;)
>
>The situation involves the following tables:
>
>Tables:
>----------
>* User
>
>* Show
>* Musical Number
>* CreativePerson (composers, lyricists, etc)
>* Actor
>
>What I would like is the ability for a User to create custom lists, i.e. top
>10 kind of things. Each list would have a title and description and then any
>number of ordered list items. A list can only contain a single kind of item
>(i.e. either shows, musical numbers, creatives or actors). So the thing
>I'm toying with is how to link each list item to its primary key - either a
>single list item table or one for each entity or something else....?!
>
>How would you approach this?
>
>Dominic
Based on my understanding of your requirements, I would do something along the
following line:
>Tables:
>----------
Customer -- who will look for entertainment bits provided by this app...
>
>* Show
>* Musical Number
Need to come up with a {table} that would best describe Entertainment stuff
like 'Show', 'Music' etc.... need more thoughts on this one...
>* CreativePerson (composers, lyricists, actor etc)
Artist
(could be any of the above, and more...)
ArtistTypeID (PK)
-- this fk column would differentiate one type of artist from another...
ArtistType
This lookup table store artist types
This is a start...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296394
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
