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?