Understanding Index and Type

In general comparison of Elastic Search with Relational Database,

  • Database (Relational Database) is Index (Elastic Search)
  • Table (Relational Database) is Document Type (Elastic Search)

So, a database can have multiple tables.

However, Elastic Search 7.0 doesn't support having multiple types in the same index.

How I can design the database where I have a database (logical host) which have multiple tables?

When you model data in Elasticsearch you need to think about it in terms of what you want to serach and get returned rather than how it might be structured in a relational database. As it is a document store and very different from a relational database this kind of analogies are typically not very useful.