Hi! There is here such table:
resources that are present on the planetspeople_planet
- mapping of planets and people who have accessplanet_resource_person
- comparison of the planets resources and people who have access to them
As can be seen from the tables, several people may have access to the same planet, but with possible different access to resources, including a complete lack of access to resources.Note the question)
for a specific person to a list of planets where he has access to at least one resource? For example, Victor has access to Venus and Earth, but access resources only on Venus - that is, the query result should be the row with id=2 from table planet.