Is it possible to have a dynamic relation between one

Question

Is it possible to have a dynamic relation between one

table and some other tables?

For example, Having a table with columns,
First column to specify the relation's other end table, and another column for out foreign key which based on the first column, it's target changes

Like first column specifies if the this row is about a product or service
There are 2 other tables for products and services, if the first column's data is product, then the second column is linked to products table id, if first column's data is service, then the second column is linked to services table id

Is it possible? Is it okey or are there better practices for doing such a thing?

0

31.05.2019

2 ответов

10 просмотров

Fayaz Khan

It's definitely possible. Some ORMs also do it the way you mention it. But if your relation is one-to-one, you can solve it by placing your foreign key on the other tables.

0

01.06.2019

🏳️‍🌈Robby [ Private Message = Spam] O'Connor 🇺🇦 · Accepted Answer

🏳️‍🌈Robby [ Private Message = Spam] O'Connor 🇺🇦

er...this feels very wrong

0

01.06.2019

Похожие чаты

Is it possible to have a dynamic relation between one

2 ответов

Похожие вопросы