topic Re: Schema design to achieve "join table" in Nuxeo Forum

Schema design to achieve "join table"

jbs_ — Mon, 05 Mar 2012 23:45:40 GMT

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?

Re: Schema design to achieve "join table"

Wojciech_Sulejm — Tue, 06 Mar 2012 00:51:22 GMT

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

Re: Schema design to achieve "join table"

Florent_Guillau — Tue, 06 Mar 2012 11:42:16 GMT

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.

Re: Schema design to achieve "join table"

jbs_ — Fri, 23 Mar 2012 18:41:34 GMT

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

Re: Schema design to achieve "join table"

Florent_Guillau — Thu, 29 Mar 2012 16:02:24 GMT

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