Using Metadata for Table Relationships in Laravel

[matuskm]

Is it possible to utilize meta for a relationship with another table? For example, I have a "products" table and metadata where the "key" is "mistake" and the value is "1". So, if I want to retrieve the meta "mistake", then based on the key with "1", I want to retrieve data from the "mistakes" table where mistakes.id=1. Something similar to what Laravel has for hasOne()... Thank you.

[frasmage]

By all means. For something high volume, you may find native columns with proper indexing a bit more performant, but for occasional relationships, tables that are difficult to modify or something particularly polymorphic, this approach can work

[matuskm]

Can you provide me with an example of how to do it? Thank you.