[NetArt] table

Some about the data we need to keep

User information:

• Id
• nickname
• password
• image
• email
• ...
  

Book information:

• book id
• book name
• ISBN
• cover(image)
• side(image)
• writer
• publisher
  
• pages
• publish time
• ranking
  
• ...
  

Book comments

• who give the comment (user id)
• time
  
• which book (book id)
• content
• ranking
• ...
  

Linking Tables (who have what)

• linking id
  
• user id (owner)
• book id (be owned)
• date (the time the relation happened)
• 要如何表示在書架中的位置
  

Book linkage

• same book, different version
• same book, different cover
• same book, different language
• different book, same ISBN (journal?)
• ...
  

else need to consider

• 擴充性
• different between a user and a 2nd-hand book seller
• the "location of book in the book shelf"
• one people have only one bookshelf or many?
• .... (I am still thinking)

ER model to be shown, where should we keep the database.