Re: DB Layout

>>>>> "DR" == Dave Rolsky <[email protected]> writes:

  DR> On Thu, 31 Jan 2002, Uri Guttman wrote:

  >> i don't agree as we want to list reviews separately from other book
  >> links. maybe a link_type that says what kind of link: cover, home page,
  >> review, etc. then we can grab all the review links and our text review
  >> entries and make one listing of reviews.

  DR> You're confusing the schema with the UI.  In the UI, we will certainly
  DR> make a point of grouping 'internal' (in the DB) reviews and external
  DR> (links) reviews.  And those links will be separate from links to cover
  DR> pages, table of contents, sample chapters, etc.

i am not confusing them (i think). i just wasn't sure how we find them
but if there is a link_type field that works for me.

  DR> But that doesn't require that the Review table have a link column.

well, as i said above i agree as we can find review links in the links table.

  DR> I was thinking we'd offer user's the ability to configure how that's
  DR> handled, something like:

  DR>  Friends' book ratings are given:

  DR>  - 3x weighting
  DR>  - 2x weighting
  DR>  - 1.5x weighting
  DR>  - 1.1x weighting
  DR>  - normal weighting

  DR>  Foes' book ratings are given:

  DR>  - normal weighting
  DR>  - 0.9x weighting
  DR>  - 0.5x weighting
  DR>  - 0.1x weighting
  DR>  - the cold shoulder

custom weightings? hmmm...

uri

-- 
Uri Guttman  ------  [email protected]  -------- http://www.stemsystems.com
-- Stem is an Open Source Network Development Toolkit and Application Suite -
----- Stem and Perl Development, Systems Architecture, Design and Coding ----
Search or Offer Perl Jobs  ----------------------------  http://jobs.perl.org