common joins and facade types