Assets Entries

Assetcategory

• It will store the information of the categories with different site scopes

• It maintains the hierarchy relationship of the categories

• It will also store the values of vocabularies ( under which multiple categories can be added)

Assetentries_assetcategories

• It stores only the relation between assetentries & assetcategories

Assetentries_assettags

• It stores only the relation between assetentries & assettags

Assetentry

• All asset will be stored

• classPK is the primary key of specific asset

• (ex: if asset is document then dl file entry will be classpk)

Assettag

• It will store the value of tags of assets

• The schema will be similar to assetcategories

Assetvocabulary

• It will store the values of vocabulary id’s with respect to site specific

• By default Topic vocabulary will be stored from liferay

Subscription

• All asset subscriptions are stored in this table where each asset can be recognized by class name

• Here classname will be the fully qualified class name of asset

• Ex: com.liferay.portal.model.User

Classname_

• Every asset qualified class name will be stored in this table

• By using this table liferay can get class name id & class name