Alter table from one to many to many to many relationship. but almost 1000 records are filled in the table.

Hi @abdulbazith

you need to create pivot table like so

        Schema::create('assessment_chapters', function (Blueprint $table) {
            $table->unsignedBigInteger('assessment_id');
            $table->unsignedBigInteger('chapter_id');

            $table->foreign('assessment_id')
                ->references('id')
                ->on('assessments');

            $table->foreign('chapter_id')
                ->references('id')
                ->on('chapter_details');

            $table->primary(['assessment_id', 'chapter_id']);
        });

and change your relations in Assessment model to

 public function chapterdetails()
    {
        return $this->belongsToMany('App\ChapterDetails', 'assessment_chapters, 'assessment_id', 'chapter_id');
    }

and in chapter details model to

 public function assessmentdetails()
    {
        return $this->belongsToMany('App\AssessmentCreation', 'assessment_chapters, 'chapter_id', 'assessment_id');
    }

@silencebringer thank you for your response,

but what happens for the 1000 records.??? currently the table is with one to many relationship with 1000 records.. how i can handle that??

@abdulbazith after creating new pivot table you can manually run request in database like:

insert into assessment_chapters (assessment_id, chapter_id) (select id, chapter_id from assessment_creations)

or add this query to the end of your migration

@silencebringer thank you so much ..

i have another small doubt actually i have 3 tables

RequestAssessment and AssessmentCreation

both the tables must share the chapter id with many to many relationship kindly can u suggest please.

what i planned now is t create a pivot table between RequestAssessment and chapter_details -> chapter_details_request_assessment

and

a pivot table between AssessmentCreation and chapter_details -> assessment_creation_chapter_details

is this correct ???

@abdulbazith it depends. You can do it this way or using Polymorphic Many To Many