I am trying to decide whether to use some sort of composite keys or a bridge table. Not sure whether one relationship is many to many or not.
table name- main
Primary key column - code
Names can be repeated, but only with a different address. An address can be repeated but only with a different name. I've used bridge tables before but only between tables not two columns. Do I need composite keys instead that are separate from the primary key??