| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | PFC <lists(at)peufeu(dot)com> |
| Cc: | "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>, Todd Kennedy <todd(dot)kennedy(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Question about One to Many relationships |
| Date: | 2006-03-27 13:52:19 |
| Message-ID: | 20060327135219.GL80726@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
> This opens another can of worms...
>
> I would use the following tables :
BTW, if you're going to be writing code to manage stuff like this, you
should absolutely check out the source for http://musicbrainz.org/,
which uses PostgreSQL as it's backend.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-03-27 13:56:29 | Re: Find min and max values across two columns? |
| Previous Message | Jim C. Nasby | 2006-03-27 13:49:43 | Re: SQL Query Newbie Help |