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?

[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 · Accepted solution]

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.

[jbs_]

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

[Florent_Guillau]

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