Databricks supports primary and foreign key constraints on Unity Catalog Delta tables, but these are informational and not enforced; queries do not depend on them to be able to join tables .
To query all related data from multiple tables you will need to use join between all the related tables with right join condition .