On Fri, Mar 24, 2006 at 06:29:25PM +0100, PFC wrote:
>
>
> >>And I want to link the band to the album, but, if the album is a
> >>compilation it'll be linked to multiple band.ids, so i can't just add
> >>a column like:
>
> For a compilation, you should link a band to a track, not an album.
Todd Kennedy wrote:
They haven't responded me as of yet. There should be a band associated
with each album -- this is handled in code, but other than that this
is the only relational db way I can think of to do it.
But if a band can have songs in many albums and an album can have songs
from mu
On Fri, 24 Mar 2006 13:34:34 -0500
Joe <[EMAIL PROTECTED]> wrote:
> Todd Kennedy wrote:
> > They haven't responded me as of yet. There should be a band associated
> > with each album -- this is handled in code, but other than that this
> > is the only relational db way I can think of to do it.
>
>
We're not concerned with the track info. This is a listing of album
information, hence the one to many relationship between the album and
the artist.
and for the record, i should correct myself. he said it was "bad" not "wrong".
but i hadn't given him all the details.
But. Yes. Thank you all
They haven't responded me as of yet. There should be a band associated
with each album -- this is handled in code, but other than that this
is the only relational db way I can think of to do it.
Thanks!
Todd
On 3/24/06, D'Arcy J.M. Cain wrote:
> On Fri, 24 Mar 2006 11:52:31 -0500
> "Todd Kennedy
And I want to link the band to the album, but, if the album is a
compilation it'll be linked to multiple band.ids, so i can't just add
a column like:
For a compilation, you should link a band to a track, not an album. This
opens another can of worms...
I would use the following t
Child table references a not-existing table:
('band' insted of 'bands')
Error: ERROR: relation "band" does not exist
> CREATE TABLE bands (
> CREATE TABLE bands_on_album (
- - -
> band_id integer REFERENCES band (id),
- - -
Regards,
Milorad Poluga
[EMAIL PROTECTED]
On Fri, 24 Mar 2006 11:52:31 -0500
"Todd Kennedy" <[EMAIL PROTECTED]> wrote:
> So I've got two tables, one for albums and one for bands, for
> simplicity's sake, they look like this:
>
> CREATE TABLE bands (
> id serial PRIMARY KEY,
> name varchar(64) NOT NULL CHECK( name <> ''),
> UNIQUE(name)
>
