Join implementation for multiple master data


(Siv) #1

Hi

Here is my MySQL database design

Table 1 (Foregion Key refernce)

  • userId
  • deviceId
  • groupId

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.

Any reference?


(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.