From: email@...
Date: 2006-11-14T02:50:05+09:00
Subject: Modelling Unique Collections in Rails/SQL

I'm puzzelling over how to model *for want of a better description*
unique collections in Rails and SQL

Heres my Domain Specific Example:

I start with...

class Band
 has_many :line_ups     # ?
end

class LineUp
   belongs_to :band  #?
end

class Recording
 belongs_to :line_up      # ?
end

class Tour
 belongs_to :line_up      # ?
end

But I'm struggling to fully model the relationship between Bands,
LineUps and People in Rails and SQL

LineUps are defined/distinct/unique from one another by the collection
of People in them.

Any ideas ?

Tony