'int', 'sponsor_id' => 'int', 'record_id' => 'int', 'returned_at' => 'datetime', ]; } public function consultant(): BelongsTo { return $this->belongsTo(User::class, 'consultant_id')->withTrashed(); } public function sponsor(): BelongsTo { return $this->belongsTo(User::class, 'sponsor_id')->withTrashed(); } /** * Noch beim Sponsor liegende Datensätze eines Beraters. * * @param Builder $query * @return Builder */ public function scopeOpenFor(Builder $query, int $consultantId): Builder { return $query->where('consultant_id', $consultantId)->whereNull('returned_at'); } }