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.
Ex: transaction_id
123
contains the purchase of membership_id
100
.
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.