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.
In example, I have this following tables:
Now I want to link multiple features to a table row, with a linked table. Should I call the linking table
restaurant_table_to_feature. I've seen both possibilities in multiple systems, but which one would be the preferred on?
I also could simple rename
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.
What would be the best name to use here?
I guess link table expresses some relationship, for example current feature to table availability or plans to deploy feature or history or all of them (requires more attributes besides just FKs). So it may be
availability#restaurant_table_feature#restaurant_table for the first case or
status#restaurant_table_feature#restaurant_table for the last one.
Seeing that these features would essentially be just additional attributes of a restaurant table, you could view the mapping table as an extension to
restaurant_table. Therefore, consider