How to create a model when the database table contains hyphens?

Question

I have tables with hyphens in my database, for example "user-cars". I can't change the name to "user_cars". Is there a way to name the model "user_cars" but have it reference the "user-cars" table? I tried @@map("user_cars") but it didn't work.

P粉520545753 · Answer

According to the documentation, you need to map the model to the underlying table name. You tried user_cars, but did you try user-cars? If your table name is user-cars, then you should map it to your model like this:

model UserCar {
  // Fields

  @@map("user-cars")
}

model UserCar {
  // Fields

  @@map("user-cars")
}