So if we take the notes table we should be seeing all the relationships that notes are associated with. But is that the case?
When you take a look at the notes table you don't seems find any relationships. Then how is this possible?
In the notes entity we have 2 fields.
- objecttype
- objectid
The first field is the ones keeping the entity which the record is associated with.
The second field keeps the primary key of the record the notes records is associated with (associated entities primary key).
That is how this miracle is happening.