Here is my MySQL database design
Table 1 (Foregion Key refernce)
All these fields are referred from other table where I kept User, Device, Group - names and other info. Im trying to move that data into Elastisearch and perform search. As per ES 6.0 we need to keep reference data in same Index.
- Can I keep more than references in same document
- When I search and retrieve I would like to get Details of User, Device, Group like name, status etc.