Liferay DB tables


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.

Blogs

 BlogsEntry - Blogs entry data.
 BlogsStatsUser - Stores the view count/stats for blog entries.
 BlogsCategory - Stores blogs categories.

WCM

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.
Advertisements

17 thoughts on “Liferay DB tables

  1. Hi Arvind,

    I need your help. As U explain good about data tables used by liferay portal. I would like to know that from which data table we can make liferay portal “Just single click login” concept that get the employee ID and domain name from custom attributes from Liferay control panel…..???? Please reply ASAP.

  2. hai i want to how to add a extra column in table ….and i doing to employee table now i finished to two column employee id and employee name .. now i want to add employee salary column so what i will do…please reply me…

  3. Thanks a lot Arvind do you have a reverse enginerring database layout design which you can share and help me one thing as i am really findign it difficult to solve is the add application portlet doesnot work after some database corruption any idea how to fix it .

  4. Thanks a lot Arvind . need one more help do you have any idea if add application is showing blank anywhere to fix it .

    2011-11-10 21:11:36,808 [catalina-exec-5] ERROR com.liferay.taglib.util.IncludeTag – Current URL /c/portal/render_portlet generates exception: java.lang.NullPointerException
    2011-11-10 21:11:36,808 [catalina-exec-5] ERROR com.liferay.taglib.util.IncludeTag – java.lang.NullPointerException
    at org.apache.jsp.html.portlet.layout_005fconfiguration.view_jsp._getRelevantPortletCategory(view_jsp.java:218)
    at org.apache.jsp.html.portlet.layout_005fconfiguration.view_jsp._jspService(view_jsp.java:950)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
    at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
    at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
    at com.liferay.taglib.util.IncludeTag.doEndTag(IncludeTag.java:67)
    at org.apache.jsp.html.common.themes.portlet_jsp._jspService(portlet_jsp.java:1728)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)

    • User_ table has USERID, thats the unique identifier for the user. To get the User based on Email/Username from API, you will have to pass Company ID also. Becasue Liferay supports Portal Virtual Instance, Users with same email/username can exist in Multiple companies.

  5. Arvind please solve my problem too, I want to update table with the help of custom sql is it possible or not?. I will wait for your reply.
    thanks asif aftab

  6. Hi Arvind,
    Thanks for the post. I would like to know is there any table with the modified user details. Like an admin user assigns a user to a particular community. I want to see the details of the admin user, assigned user, community and the assigned time.

    Thanks
    Siby V

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s