在Laravel 4中使用数据透视表时如何分配关系？

Question

Details

I have 3 tables :

• catalog_downloads
• export_frequencies
• export_frequencies_catalog_downloads (Pivot Table)

Diagram

I am not sure if I set the relation between them correctly. Please correct me if I am wrong.

Here is what I did

In CatalogDownload.php

public function export_frequencies(){ 
        return $this->belongsToMany('ExportFrequency','export_frequencies_catalog_downloads','export_frequency_id','catalog_download_id');
    }

In ExportFrequency.php

public function catalog_downloads(){ 
        return $this->belongsToMany('CatalogDownload','export_frequencies_catalog_downloads','export_frequency_id','catalog_download_id');
    }

Questions

• According to my diagram - Did I assign the relationship correctly ? I hope I didn't mix up between hasMany and belongsTo

• Will I need a class or a model for a Pivot Table ?

Thanks

Answer 1

Since export_frequencies is in the CatalogDownload model you have to invert the ID's because the parameters of belongsToMany are as follows:

1. Name of the referenced (target) Model (ExportFrequency)
2. Name of the Pivot table
3. Name of the id colum of the referencing (local) Model (CatalogDownload in this case)
4. Name of the id colum of the referenced (target) Model (ExportFrequency in this case)

what leads to this function:

public function export_frequencies(){ 

        return $this->belongsToMany('ExportFrequency','export_frequencies_catalog_downloads','export_frequency_id','catalog_download_id');
    }

The other function was correct.

If you had some data in your pivot table, for instance a colum with the name someCounter then you will have to tell the relation to load that column when creating the pivot object like this:

public function export_frequencies(){ 

        return $this->belongsToMany('ExportFrequency','export_frequencies_catalog_downloads','export_frequency_id','catalog_download_id')->withPivot('someCounter');
}

That will load the column and make it avalible like this:

$catalogDownload->export_frequencies()->first()->pivot->someCounter;

You will need a separate Pivot Model if you need to do some special handling for the fields or if that pivot itself has a relation of its own but then you might consider using a full blown model instead of a pure Pivot Model.