Keep relational data nested in one document

Elastic Stack Logstash
1

Hi,

Hope someone can help. I've looked all over Google and this forum without finding the answer.

Lets say I have three tables -

PRODUCT
Columns - productid, productName (productId is unique)

COLOUR
Columns - colourId, productId, colour (colourId is unique)

SIZE
Columns - sizeId, productId, colourId, size (sizeId is unique)

The relationship is 1:M:M

How do I build the configuration within Logstash so I can get the tables into Elasticsearch so the Colour & Size values are nested within the document of Product and keep their own relationships at the same time?

Thanks for any help.

2

check these 2 links. Related problem.