The other-appearance element is a subelement of the appearance element, and has a direct many-to-one join to the defaults table, foreign key defaults_id. There is no intermediate appearance table.