Our Work

Understanding Database Relations of Liferay 6.1.2

Updated 1 month and 3 days ago

Liferay Communities     

  • Liferay has 3 different ways of site types with different codes/constants.
  • All Organization Sites would be by default “Private” type. I.e, Users of these will be managed by Site Administrator or Moderator.                                                    
  • Each type represents a different  behavior                                                                                                      
    • Private: Only Site Administrator or Moderator will assign the user to site        
    • Restricted: User can request for site assignment and Moderator or Site Administrator will Accept/Reject the request.      
      • User will not see any of the Site Assets until site assignment Accepted.      
    • Open: User can manage himself to join or leave this type of Communities in Liferay.     
    • Each community row in group_ will be tagging this “type_” to identify community type by Liferay.          


Following are the site related db tables


  • Created site will be stored in the group_  table        
  • Type_=1|2|3                                                                                         
    • Restricted=2  
    • Private=3
    • open=1    
  •  Site=0 Site is in Inactive (not available), will not be displayed in the Dockbar and scope


  •  The relation between sites and orgs will be available in the groups_orgs table



  •  Created teams will be available in team table by based on site wise


  •   Relation between site and permission will be stored in the group_permission


  • Relation between sites and roles will be stored in the groups_roles


The relation between the sites and the associated User Groups    


  • The list of hosts are stored in the Virtualhost (ex: alliance1.com, hq.alliance1.com)


Looking for Liferay Developer?

KTree is the best offshore Liferay development company with extensive experience in Liferay Portal Development services along with Upgrade & Migration. Hire Liferay developers or Liferay development services from LiferayDeveloper.

Request For Quote