Table detail has a ForeignKey to table master.

How to call the back relation?

master has ??? to table detail

I could not find a canonical word in wikipedia or other resources.

  • master is a parent to detail?
    – Vérace
    Jan 13 '16 at 14:23
  • master is referenced in/by detail? Jan 13 '16 at 16:02

In the terminology used to to talk about conceptual design of database, this is called inverse relationship. So you could say:

master has an inverse relationship with table detail.

See for instance: Fundamentals of database systems, by R. Elmasri, S. Navathe, Addison Wesley, ISBN: 978-0-13-608620-8, Chapter 11, Object and Object Relational Databases.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.