How do I setup CRUD list operation when the table doesn't have an ID column?

[cvassios-eibach]

It looks like it defaults to always ordering by the ID, but in this case, my table doesn't have an ID column so it throws an error:
Column not found: 1054 Unknown column 'id' in 'order clause'

SELECT
  *
FROM
  `product_release_product`
ORDER BY
  `product_release_id` DESC,
  `id` DESC
limit
  10

[karandatwani92]

If your table doesn't have id as the primary key, You should set one in your Model. Example:

protected $primaryKey = 'barcode';
public $incrementing = false;
protected $keyType = 'string';

[cvassios-eibach]

My table is a n-n pivot table, so I'm not using a primary key. Is there a way to make it work with a composite primary key?

[karandatwani92]

"Composite" primary keys are not supported by Eloquent models.

You have to add the id incrementing column to the pivot table.

[cvassios-eibach]

Thank you! @karandatwani92