Different tables that are associated with the document data
How To articles are not official guidelines or officially
supporteddocumentation. They are community-contributed content and may
not alwaysreflect the latest updates to Liferay DXP. We welcome your
feedback toimprove How to articles!
While we make every effort to ensure this Knowledge Base is accurate,
itmay not always reflect the most recent updates or official
guidelines.We appreciate your understanding and encourage you to reach
out with anyfeedback or concerns.
Legacy Article
You are viewing an article from our legacy
"FastTrack"publication program, made available for
informational purposes. Articlesin this program were published without a
requirement for independentediting or verification and are provided
"as is" withoutguarantee.
Before using any information from this article, independently verify
itssuitability for your situation and project.
Issue
- How data flows in the database tables after uploading an image.
Resolution
- When the documents have been uploaded via document and media portlet from the Liferay portal, its metadata is saved in database tables with different entries and images are saved in folders with numeric allotted digits, which can be seen inside the data folder.
-
There are different tables that are associated with the document data, below are the details regarding database relations of Liferay 7 Document & Media
-
Dlfileentry
- It stores all document and media files data
- It has its parent folder information, created dates, modified dates, repositoryID, fileEntryTypeId.
- We can also store an external repository.
- When no external repository is used, then repositoryId will be groupId
- It also provides information of the size of the document, read count, an extension of the document, mime type. file entry id, smallimageid, largeimageid, customimageid, etc.
- Here, the title specifies the title of the document, whereas, name specifies folder of the document.
- The 'treePath' column has been added from Liferay 6.2 version, with this searching document hierarchy would become easier.
dlFileEntryMetadata
- This table consists of information about file association with Document Type
- Each file might be associated with a different Document type and relations will be maintained here.
dlFileEntryType
- By default, Liferay documents are associated with a type called 'Basic'
- Liferay allows creating the custom document types by setting up with required fields.
- Custom document type information will be stored in this table.
dlFileversion
- Updating any file in Liferay will lead to create a new version.
- Each version will be stored as an individual file in the file system
- This table maintains all versions of fileentry.
dlFileShortCut
- Users can create a shortcut to file entry.
- It’s a logical link of a file, the file system doesn’t have this info.
- From lportal table, shortcuts would be pointed to the original fileEntry.
dlFileRank
- This table maintains tile rank.
- Ranks can be defined from portal property (Max file rank version)
dl.file.rank.max.size=5
Did this article resolve your issue ?
