Document library and JCR

[Eskendir Mulugeta，修改在8 年前。]

We configured documents to be stored in jcr tables in postgresql. I'm trying to understand the relationship between jcr tables and the liferay doucment library tables, dlfileentry, dlfilerank, dl fileshortcut, dlfileversion, and dlfolder.

I see both tables updated. so my question is how are those two dbs linked with each other.

[Jan Geißler，修改在8 年前。]

To be honest, you shouldn't.
If you want to know how all the stuff works, take a look in the source code. The database is the most wrong place to look for answers, as all the logic processed before writing to the database is missing in your picture.

[Olaf Kock，修改在8 年前。]

The document store (e.g. JCR) stores the binary data of the uploaded documents. The other tables store the metadata according to the hints from their table names.

[Eskendir Mulugeta，修改在8 年前。]

Thank you Olaf,
how exactly are these metadata used? when lifreay loads the documents on the front end does it use these metadata? I guess my confusion is that I see getting documents uses the jcr HOOk and I don't really see how the information in LR tables and the jcr linked to populate the node or folder structure.

[Jan Geißler，修改在8 年前。]

And this is something the database will not answer. But the code.

[Eskendir Mulugeta，修改在8 年前。]

Thank you so much, you have been very helpful.