mysqlテーブル設計

[Attsun1031]

• artists
  • id (unsigned integer, auto_increment, primary)
  • name (varchar255)
  • freebase_topic_id (varchar100)
• users
  • id (unsigned integer, auto_increment, primary)
  • name (varchar255)
  • profile (text)
• streams
  • user_id (primary1, foreign to user.id)
  • artist_id (primary2, foreign to artist.id)
• oauth_tokens
  • user_id (unsigned integer, foreign to users.id, primary1)
  • provider_type (unsigned tinyint, primary2)
  • access_token (varchar255)
  • access_secret (varchar255)
• crawl_targets (rss url or twitter id)
  • id (unsigned interger, auto_increment, primary)
  • crawl_type (unsinged interger, ix_crawl_type)
  • source (text)
• crawlers
  • id (unsigned interger, auto_increment, primary)
  • host (varchar255)
  • pid (unsigned integer)
  • last_crawl_date (datetime)
  • status (varchar20)

[Attsun1031]

とりあえず自然な形に設計。indexは実際に発行され得るクエリを見ながら決めていく。