Laravel与透视表的关系

Question

我有三张桌子：

类别（id、名称）

类别赛（类别赛id，锦标赛id）--

Category是可用类别列表Category_Tornament是管理员配置的类别列表Category_Tornament用户是用户已注册的类别

要获得锦标赛中的所有类别，我可以使用以下工具轻松完成：

    tournament->categories

在竞赛模型中定义归属关系

我不知道如何定义与上一个表的关系。

我需要的是用户单击几个类别，我可以运行如下操作：

    tournament->user_categories->sync($userCategories)

我应该在哪里同步表类别\锦标赛\用户（与类别\ id、锦标赛\ id、用户\ id）

实现这一目标的最佳方式是什么？？？

编辑：

模特大赛：

class Tournament extends Model
{

protected $table = 'tournament';
public $timestamps = true;

protected $fillable = [
    'name',
    'date',
    'type',

];


/**
 * A tournament is owned by a user
 *
 * @return \Illuminate\Database\Eloquent\Relations\BelongsTo
 */
public function owner()
{
    return $this->belongsTo('App\User', 'user_id','id');
}

/**
 * @return \Illuminate\Database\Eloquent\Relations\HasMany
 */

public function categories()
{
    return $this->belongsToMany('App\Category')
                ->withTimestamps();
}

}

型号类别

class Category extends Model
{
protected $table = 'category';
public $timestamps = true;

protected $fillable = [
    'id',
    'name',
];


public function tournaments()
{
    return $this->belongsToMany('App\Tournament');
}
}

模型用户：

class User extends Model implements AuthenticatableContract,  CanResetPasswordContract
{
use Authenticatable, Authorizable, CanResetPassword, HasRole;

/**
 * The database table used by the model.
 *
 * @var string
 */
protected $table = 'users';

/**
 * The attributes that are mass assignable.
 *
 * @var array
 */
 protected $fillable = ['name','firstname','lastname','email', 'password','avatar',country_id','role_id',,'provider','provider_id','verified'];

/**
 * The attributes excluded from the model's JSON form.
 *
 * @var array
 */
protected $hidden = ['password', 'remember_token'];



/**
 * Boot the model.
 *
 * @return void
 */
public static function boot()
{
    parent::boot();
    static::creating(function ($user) {
        $user->token = str_random(30);
    });
}

public function role()
{
    return $this->belongsTo('App\Role');
}

public function settings()
{
    return $this->hasOne('App\Settings');
}

public function invites()
{
    return $this->hasMany('App\Invite', 'email','email');
}

public function country()
{
    return $this->belongsTo('Webpatser\Countries\Countries');
}

/**
 * A user can have many tournaments
 *
 * @return \Illuminate\Database\Eloquent\Relations\HasMany
 */
public function tournaments()
{
    return $this->hasMany('App\Tournament');
}


}

Answer 1

我认为你不需要有Category_Tournament_User表。你不能在Laravel中为它制作Model。你只需要一个表user_tournament。你应该在迁移，像这样：

Schema::create('user_tournament', function(Blueprint $table){
    $table->engine = 'InnoDB';
    $table->increments('id');
    $table->integer('user_id')->unsigned();
    $table->integer('tournament_id')->unsigned();
    $table->unique(['tournament_id', 'user_id']);//You can omit this
    $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade')->onUpdate('cascade');
    $table->foreign('tournament_id')->references('id')->on('tournaments')->onDelete('cascade')->onUpdate('cascade');
    $table->nullableTimestamps();
});

然后你可以使用这个代码：

用户-

Answer 2

您在这里有许多对许多的关系用户和Category_Tournament，您应该在许多对许多中查看留档。