Hi,

Actually, it'll never be MTM as each photo predicts a unique indicator. as for the location, i don't store the photos in the DB but on remote storage (Azure) and...

Yes, but what about other entities?

you can't store FKs from difference entities in the same column in Photos, that's the reason why i created the link table from the first...

Hi Leo,

Thanks for your reply.

With your permission i would to explain again approach #1.

Three entities, let's name them all.

Employees, Houses, Cars. lets assume that each one of them should have...

Hi,

Regarding the 3rd approach, I didn't understand why do i need to use 3 link tables if i have 3 Photos tables.

If each entity has a unique Photo table, so...

A single photo can be linked to one entity always.

So if i want to change it, it should get changed in one place, which is linked to one record in...