I was wondering what the best name for a linked table in this situation (or any) would be. I've searched for this, but could not find any concrete examples.
For example, I have the following tables (where 'table in the name refers to tables in a restaurant):
A table can have all kind of features and also multiple. Think of rounded tables, tables near the window, ground-floor tables, tables near entrance. It really depends on the type of restaurant, so it needs to be customizable. Arrangements are not permanent, since tables can be moved around for various reasons. Usually, the smallest possible combination of a table has a table number, if tables are combined for a group, multiple table numbers are used.
I want to link multiple features to a table row, with a linked table. Should I call the linking table restaurant_table_feature_table or restaurant_table_to_feature.
I've seen both possibilities in multiple systems, but which one would be the preferred one?
I also could simply rename restaurant_table_feature to restaurant_feature, and create a restaurant_table_feature table as link table. However if I also have a restaurant_location table for which I would have features (which differ from the table features) I would run into problems.
To be clear, my question is what the best name would be (for the many-to-many tables) in any situation with multiple many-to-many tables.