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.
Knowledge Share 
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.
Custom Attributes are stored in Expando* Tables. You can fetch them from there.
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…
Add it in service.xml, regenerate the service again.
Can u please let me know the tables design with communites and UUID design associated wit it
Community data is stored in Group table.
Thanks
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 .
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)
Hi!
I want to fetch details from liferay’s default table -Address based on userId
Address table store className & classNamePK field. To fetch the user’s address you need to provide the following
className – User Model name from ClassName_ table
classNamePK will be the userId
Thanks
Arvind
Thanks a lot Arvind.
hey arvind can u tell me how user is uniquly identified in liferay tables..??
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.
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
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
how to add image from my custom portlet and in which table it will store..pls i m new for liferay so explain briefly…
Depends on Liferay Version. It Could go to Image* tables or DL* Tables