NewsCloud Database Structure Documentation
From Newscloud
Primary Tables
Content
ContentTags
User
Tags
SiteTitles
Blogs
The blogs table contains all of the feeds that get read in for the Latest Wire on the cover page as well as the Browse for Stories pages. If isShared=1, then it appears as a Popular Feed on the Browse for Stories page. If blogtype=Wire, then headlines from this feed can appear on the Cover Page's Latest Wires.
FeedStories
Stories from the Blogs' feeds get placed in FeedStories. This table gets purged daily by the Cleanup class.
UserBlogroll
If a Blog feed is owned by a user the user id and the blog id will appear in this table.
UserBlogs
The UserBlogs table stores the account information for NewsCloud readers to post to their blogs at Wordpress, TypePad, LiveJournal or Blogger. It also stores whether to autopost links from the user's journal to their blog.
state and zip_code
Table information for state and zip code look up and distance calculation.
