[pdb-discuss] Re: updated db plan

Sat Feb 25 18:45:51 UTC 2006

I've set up a mailing list for pd burn stuff:

pdb-discuss at lists.okfn.org

To use for these kind of discussions as well as to make it easier for 
others to get involved. You both should have got the subscriptions 
emails. If not let me know.

~rufus

Rob Myers wrote:
> That looks very good.
> 
> Some incredibly minor questions:
> 
> I see that genre on pdb_work_data is a varchar(20), should it be a  
> reference to a genre table row index?
> 
> Do work data and medium data reflect the copyrighted work of the  score 
> and the recording respectively? If so is it worth making this  explicit?
> 
> For countries should we use country code or have a list of countries?  
> That said, what if a work was composed in Austria-Hungary or  
> Yugoslavia? So country names as strings are probably best.
> 
> For artist first and last names we may need to be careful to make  clear 
> which are given and family names with for example Japanese  composers :-).
> 
> - Rob.