Is there an appropriate name for a "middle" table that only stores foreign keys of other tables?

Is there an appropriate name for a "middle" table that only stores foreign keys of other tables?

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.

Replay

The proper term is associative table, though most often I've heard it called is a Linker table.

Typically this table is used to support a many-to-many relationship.

As for a naming convention, that would be up to you, though I will usually just pluralize the second name, in your example I would use TransactionMemberships

Category: database design Time: 2016-07-31 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.321 (s). 12 q(s)