Here i am starting with details for liferay tables. List is updated upto 5.2.3 community release. Will keep updating this as i will get more time. In case you want the tables for some specific functionality , please comment on Post.
User Contact Etc
User_ - User data. Organization_ - Stores Liferay Organization Entries. Users_Orgs - Maps UserId with Organization id. Role_ - Stores Liferay Role Entries. Users_Roles - Maps UserId with RoleId. UserGroup - Stores Liferay User Group Entries. Users_UserGroups - Maps UserId with UserGroupId.
BlogsEntry - Blogs entry data. BlogsStatsUser - Stores the view count/stats for blog entries. BlogsCategory - Stores blogs categories.
JournalArticle - Stores the Journal Article(WCM Article) JournalArticleImage - Stores image attached with an article. JournalFeed - Stores the data for external feeds. JournalStructure - Stores the data for Journal Structures. JournalTemplate - Stores the data for Journal Templates.