Data Model

wujayway edited this page May 5, 2012 · 7 revisions
Clone this wiki locally

Entity

doubanusers

  • id: integer
  • data: blob(json)
  • gender: varchar(45)

events

  • id: integer
  • data: blob(json)

books

  • id: integer (subject id in douban)
  • data: blob(json)

movies

  • id: integer(subject id in douban)
  • data: blob(json)

musics

  • id: integer
  • data: blob(json)

Relations

userevents

  • user_id integer
  • event_id integer

userscontacts

  • follower_id: integer
  • followee_id: integer

userbooks

  • user_id: integer
  • book_id: integer

usermovies

  • user_id: integer
  • movie_id: integer

usermusics

  • user_id: integer
  • music_id: integer

Clustering/Grouping

usergroups

  • group_id: integer
  • user_id: integer

bookgroups

  • group_id: integer
  • book_id: integer

moviegroups

  • group_id: integer
  • movie_id: integer

musicgroups

  • group_id: integer
  • music_id: integer