Navigation Menu

Skip to content
utopiazh edited this page May 5, 2012 · 7 revisions

#** Data Model**

Entity

users

  • id: string
  • name: string
  • imagelink: string

events

  • id: string
  • title: string
  • starttime: datetime
  • endtime: datetime
  • where: string
  • location: string

books

  • id: string (subject id in douban)
  • title: string
  • imagelink: string
  • rating: int

movies

  • id: string (subject id in douban)
  • title: string
  • imagelink: string
  • rating: int

musics

  • id: string
  • title: string
  • imagelink: string
  • author: string
  • rating: int

Relations

userevents

  • user_id
  • event_id

userscontacts

  • follower_id: string
  • followee_id: string

userbooks

  • user_id: string
  • book_id: string
  • rating: int

usermovies

  • user_id: string
  • movie_id: string
  • rating: int

usermusics

  • user_id: string
  • music_id: string
  • rating: int

Clustering/Grouping

usergroups

  • group_id: int
  • user_id: string

bookgroups

  • group_id: int
  • book_id: string

moviegroups

  • group_id: int
  • movie_id: string

musicgroups

  • group_id: int
  • music_id: string

eventgroups

  • group_id: int
  • music_id: string
Clone this wiki locally