php - Eloquent belongsToMany关系与非标准列名

Question

我有一个问题。我有一个database image我想与非标准列名建立belongsToMany 关系。我有表顺序作为关系表，订单详细信息作为详细信息，但是当我建立关系时

User.php(模型)

    {
        return $this->belongsToMany('App\Models\OrderDetail', 'orders','user_id','id');
    }

但我收到错误

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'order_details.id' in 'on clause' (SQL: select order_details.*, orders.user_id as pivot_user_id, orders.id as pivot_id from order_details inner join orders on order_details.id = orders.id where orders.user_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) and order_details.deleted_at is null)

在 order_detail id 列中 Eloquent 搜索，但我有 order_id。

Eloquent 有改变这一点的工具吗？

通过belongsToMany我想接收来自order_detail的所有数据。这是真的吗？

Answer 1

文档提到:Laravel doc. many-to-many

return $this->belongsToMany('App\Models\OrderDetail', 'orders','user_id','order_id');