I have three tables user, product and order.
Order table has user_id and product_id in it. one order entry will have exactly one user_id and one product_id.
So how should I design the data model in ES?
- Denormalize the tables [not possible for because of huge data sets]
- Nested objects [also data duplication]
- Parent-child relation [Order can have only one parent ?]
Should I also use one index with three different types of documents or one separate index for each type of document ??
want to return all three entity contents for a particular order using a single query.
Help is very much appreciated.