No need for unique keys in this case (unless you change the DB model)
All the tables got 1 to many relations so unique keys wouldn't work.
regards
Thoul De'Seilinn
Wintir
- Programmer/Developer
Jeremy Mueller wrote:
> From: Jeremy Mueller<jmueller@...>
>
> On your data mapping tables, shouldn't you have a unique key? Do you even need a key specified on those tables?
>
> > Data mapping tables
> > =========================================================
> >
> >
> > song_locations (list of songs and locations, one to many relation)
> > --------------
> > song_id
> > location_id [fk guild_locations]
> >
> >
> > song_unstackables (list of songs which don't stack, one to many)
> > ----------------- (this doesnt support 'other' comments, needs work here)
> > song_id
> > unstack_song_id
> >
> >
> > song_comments (list of comments by type)
> > -------------
> > song_id
> > comment_id [fk comment_types]
> > comment_desc
> > comment_author
>
> ------------------------------------------------------------------------
> GET A NEXTCARD VISA, in 30 seconds! Get rates
> as low as 0.0% Intro APR and no hidden fees.
> Apply NOW!
> http://click.egroups.com/1/975/7/_/451022/_/953562891/
> ------------------------------------------------------------------------
>
> Please send submissions for the eqbards newsletter to lol@... with the subject submissions.