Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

qTylok's avatar

Indexing 3 tables with elasticsearch

Hi, I have a question. I have 3 tables with a common index and some that are not the same. For example I have 3 tables: books, magazines, cars and I would like to index 3 tables in an elasticsearch instance. That's my question How can I index 3 tables in an elasticsearch instance? This is possible as long as I have no relationship between them and I would like to index all this with an id, the one in mysql. Can you give me examples of how I could make an instance with 3 tables? I use this as a bookstore https://github.com/elastic/elasticsearch-php Do you have a project on github or an example of how I could do an elastic search instance?

Schema::create('rooms', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->integer('number_of_offered_rooms')->nullable();
            $table->timestamps();
        });

Schema::create('properties', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->integer('number_of_offered_rooms')->nullable();
            $table->timestamps();
        });

 Schema::create('wanteds', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('existing_genders')->nullable();
            $table->string('looking_for')->nullable();
            $table->boolean('buddy_up_interested')->default(0);
            $table->timestamps();
        });

and for example for these 3 tables, how can I proceed?

0 likes
0 replies

Please or to participate in this conversation.