Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I want to avoid circular reference in my data, by I don't know how to get it.
I have one main table Homes with one row per home, and each row has num_of_appliances field which is an aggregated field as integer. Then, each home (home_id), has N people living on it, so I have a reference 1:N here. Also, each home has N rooms, son here I also have a reference 1:N. As follows:
Homes:
date_1 | home_id | num_of_appliances |
2022-10-17 | 1234 | 3 |
People:
home_id | person |
1234 | Mike |
Rooms:
home_id | room |
1234 | bathroom |
I can't do a left join of A with B and C because that would duplicate values from all tables. The data must be separated.
How can I solve this?
Thanks!
You are not showing us what is causing the circular reference ?
You can just load these three tables as it is without joining,
and there will be not circular reference if the data is as shown in your sample
Have you tried loading the data? can you post a snapshot of your datamodel that shows circular reference?