Getting table name using Eloquent Relationship

Question

class SampleELoq extends Model
{
    use SoftDeletes;

    public function conditionFields() {
       return $this->belongsToMany('App\EloquentModel\ConditionField');
    }
}

nameSpace is the name space of the SampleELoq

$Eloq = $nameSpace::find(1);

$table = with(new $nameSpace->conditionFields)->getTable();

print_r(Schema::getColumnListing($table));

How can i able to get the table name of the conditionFields?

Answer 1

To get table from conditionFields you need return relation model, then you can get table by getTable method. Some like this

Model::first()->conditionFields()->getRelated()->getTable()

Answer 2

You don't have to retrieve a model from the database like in Catain Fail's answer: you can obtain the related table name in any situation as follows:

$relation = (new MyModel)->myRelationship(); // Returns a Relations subclass like BelongsTo or HasOne.
$relatedModel = $relation->getRelated(); // Returns a new empty Model
$tableName = $relatedModel->getTable();

Or in short:

$tableName = (new MyModel)->myRelationship()->getRelated()->getTable();

Answer 3

After digging hard I found a solution. It can be achieved like this.

$tableName = (new SampleELoq)->conditionFields()->getTable();

In General

$tableName = (new MODELCLASS)->RELATIONSHIP()->getTable();

Answer 4

you have two ways :-

     dd(Model::$table);

or inside your model :-

 dd($this->table());