I am having some difficulties to write this django queries. I have the following scenario.
I have three django models
- User
- Visitor
- Participants
For each interaction of a user and a visitor, I add some participants
<code>participant_id entity_type entity_id
1 user 1
2 visitor 1
3 user 1
4 visitor 2
5 user 1
6 visitor 3
</code>
<code>participant_id entity_type entity_id
1 user 1
2 visitor 1
3 user 1
4 visitor 2
5 user 1
6 visitor 3
</code>
participant_id entity_type entity_id
1 user 1
2 visitor 1
3 user 1
4 visitor 2
5 user 1
6 visitor 3
Entity type can be either user or visitor. How can I get related user and visitor data from entity id and entity type?