nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Schema design to achieve "join table"

jbs_

I'd like a way to design my schema so I can quickly determine relationships between two different types of documents, starting from either type. In traditional DBMS design, this would be done via a "join table" that lists the IDs of the records from each type. How can this be done in Nuxeo?

Find more posts tagged with

Accepted answers

Florent_Guillau

You can use a subtype of Relation. There are two columns (source and target) that are designed to be joined with other documents. In Nuxeo 5.5 when you create a relation between two documents in the Relations tab, a Relation object is created for you.

All comments

Wojciech_Sulejm

To understand how documents are mapped in the database inside the Nuxeo platform please check out the following documentation entry about Nuxeo's VCS (which stands for Visual Content Store):

Nuxeo VCS Architecture. (Note the hierarchy table for your specific scenario)

Please also note the definition of the term schema in Nuxeo EP, and how a specific schema corresponds to a table name in the VCS store database: Document Types and Nuxeo VCS Architecture again.

You also have at your disposal the following two querying systems in Nuxeo EP: CMIS for Nuxeo and: NXQL

Florent_Guillau

jbs_

Thanks for the info. However, I still have a couple of concerns

Florent_Guillau

There's no reason it should take a lot of time. It's a simple operation.