Right now I am designing a new database for our family business. I have a few tables like in the image above, where the table only contains two foreign keys in order to represent an association between two records in two different tables.
123 contains the purchase of
Is there a proper naming convention or a word for tables like this? For now I have been using the word "index" as a placeholder, but I am not sure if this word is appropriate.