Laravel Pivot表的许多关系，没有Laravel惯例

Question

我有2个模型用户和团队，每个团队都可以拥有多个用户，每个用户都可以在任何团队中，因此我想建立许多与许多关系。

我正在尝试自定义某些东西，我不想将Laravel惯例用于枢轴表。

这是我的用户迁移：

 class CreateUsersTable extends Migration
{
    protected $collection = "table_users";
    public function up()
    {
           Schema::create(  $this->collection
             , function (Blueprint $table) {

                    $table->string('_id');
                    $table->string('username')->unique();
                    $table->string('password');
             }
    }

}

这是我的团队迁移：

 class CreateTeamTable extends Migration
{
    protected $collection = "table_team";
    public function up()
    {
           Schema::create(  $this->collection
             , function (Blueprint $table) {

                    $table->string('_id');
                    $table->string('name')->unique();
             }
    }

}

所以我的问题是我想在用户模型和team模型中创建关系的方法。

在团队模型中：

    public function users()
    {
        return $this->belongsToMany(User::class, '??', '??' , '??'); // what should I insert in '??'
    }

在用户模型中：

    public function teams()
    {
        return $this->belongsToMany(Team::class, '??', '??' , '??'); // what should I insert in '??'
    }

以及如何在不使用任何约定的情况下创建枢轴表：

我到目前为止创建的枢轴表：

class CreateUsersTeamTable extends Migration
{
    protected $collection = "team_user_pivot";
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create(  $this->collection
            , function (Blueprint $table) {
            $table->id();
            $table->string('??');  // please help me to fill this field
            $table->string('??');  // please help me to fill this field
            $table->timestamps();
        });
    }

'??'??' in 用户模型和团队模型和枢轴表。帮我填补每个人

Answer 1

它并不像填写字段那样简单，因为您正在为外键使用字符串以及不限制标准的Namig公约。

create_team_user_pivot

protected $collection = "team_user_pivot";

public function up()
{
  Schema::create($this->collection, function (Blueprint $table) {
    $table->id();
    $table->string('team__id')->references('_id')->on('teams');
    $table->string('user__id')->references('_id')->on('users');
    $table->timestamps();
  });
}

您还需要编辑模型：

用户

class User extends Authenticatable
{
    use HasApiTokens, HasFactory, Notifiable;

    public $table = 'table_users';
    public $incrementing = false;
    public $keyType = 'string';
    protected $primaryKey = '_id';

    protected $fillable = [
        "_id",
        "username",
        "password"
    ];

    public function teams()
    {
        return $this->belongsToMany(Team::class, 'team_user_pivot', 'user__id', 'team__id');
    }
}

team

class Team extends Model
{
    use HasFactory;

    public $table = 'table_teams';
    public $incrementing = false;
    public $keyType = 'string';
    protected $primaryKey = '_id';

    protected $guarded = [];

    public function users()
    {
        return $this->belongsToMany(User::class, 'team_user_pivot', 'team__id', 'user__id');
    }
}

Answer 2

您必须

class UserTeam extends Model
{
public $timestamps = false;
protected $table = 'user_has_team';
protected $fillable = ['user_id', 'team_id'];
}

团队模型中创建另一个具有迁移的模型

public function users()
{
    return $this->belongsToMany(User::class, 'user_has_team', 'user_id', 'team_id');
}

在用户模型中的

public function teams()
{
    return $this->belongsToMany(Team::class, 'user_has_team', 'team_id', 'user_id');
}