Can Query Model Pivot Custom Table without field id?
I'm trying to create a Custom Table with the Pivot Model
Enrollment
Enrollment
, but I encountered an error. I don't have the
id
id
field in the
enrollments
enrollments
pivot table. How can I modify the query without using
ORDER BY id
ORDER BY id
? Should I add the id field to the pivot table?
- Error: SQLSTATE[42703]: Undefined column: 7 ERROR: column enrollments.id does not exist LINE 1: select * from "enrollments" order by "enrollments"."id" asc ... ^
SELECT * FROM "enrollments" ORDER BY "enrollments"."id" ASC limit 10 OFFSET 0
SELECT * FROM "enrollments" ORDER BY "enrollments"."id" ASC limit 10 OFFSET 0