I have a table for image registration that is used as foreign key for other tables. The problem is that in one of these tables (PROMOCOES) the ratio is 1: N (a promotion for N images), while in the other tables the ratio is 1: 1. My question is how to organize these tables because I can not use foreign key within the table of images. Would it be better for me to create a specific table of promotion images, or create an intermediary table between PROMOCOES and images and continue using a single table of images?