DB Layout

 From Dave
 >>
Here's a basic outline:

   Book
   -------
   book_id
   ISBN
   title
   edition
   copyright_year
   page_count
   link
   publisher_id
   UNIQUE( ISBN )
   UNIQUE( title, edition )

   Category
   --------
   category_id
   category
   parent_category_id -- whee, self-joins!

   BookCategory
   --------
   book_id
   category_id

   BookLink
   --------
   book_link_id
   book_id
   book_link_type_id
   link

   BookLinkType
   --------
   book_link_type_id
   type -- cover, external reviews, excerpt, etc

   Author
   --------
   author_id
   name

   Publisher
   --------
   publisher_id
   name
   link

   User  -- may not be necessary, see below
   --------
   user_id
   username
   password

   UserBookRating
   --------
   user_id  - PK
   book_id  - PK
   rating -- 1-10

   UserBookComment
   --------
   user_id  - PK
   book_id  - PK
   comment


UserBookComment could also include reviews, or we could somehow
distinguish between comments ("OO Perl rocks") vs. longer reviews.




- it'd be nice to be able to tag books you're interested in and come back
and see them later.

- links to online sellers?  partner programs?  I hate Amazon but maybe we
could link to multiple sellers.

- use use Perl's friend/foe info to prioritize reviews ("I want to see
what Damian thinks...") or change the weight of rankings ("I want all my
foes rankings to count at 10% of other rankings").
<<

from uri
 >>

we have the domain already and ask bjorn hansen will host us with most
of the rest of perl.org so that is covered. we have access to mod_perl,
a DBI database, etc. no issues with power.

<<