CODEWITHSUNDEEP
databasedatabase-designtheory
user187277
user187277

Reputation:

Is there a general term for a pairing of tables where one has header information and the other has detail lines?

Is there a general term for a pairing of tables where one has header information and the other has detail lines?

For example, a pair of tables describing sales orders, or a pair storing bill of materials data.

Upvotes: 1

Views: 98

Answers (4)

Audrey
Audrey

Reputation: 114

Remember that it is a good practice to use consistent naming conventions in your database for these types of tables. Doesn't really matter what names, consistency is really the key. The goal is to have a general idea of what the table holds based on the name. Some I've seen:

(Assume the table holds Products)

Product -- ProductDetail

ProductHeader -- ProductDetail

Product -- ProductLines

For me, Parent-Child names imply a hierarchical relationship, which is a whole 'nother ball of wax.

Upvotes: 1

Steven Sudit
Steven Sudit

Reputation: 19630

Also, Master-Detail.

Upvotes: 2

KLE
KLE

Reputation: 24169

One-To-Many describes the "numbers".

But one could prefer Parent-Child in some contexts, typically when the Child always has a Parent...

Upvotes: 4

Raj More
Raj More

Reputation: 48034

I think it is called a one-to-many relationship.

Upvotes: 3

Related Questions