Foreign keys referencing partitioned tables are not supported. Joins are absolutely fine.