I think my mind is blankin开发者_StackOverflow中文版g, but what is the correct terminology for the referent of a foreign key relation? Is there a succinct term for this?
i.e., WidgetTypes table contains XYZ and is the XXX of the Widget table's type_id column..
I suggest:
WidgetTypes table contains XYZ and is referenced by the Widget table's type_id column.
or perhaps better
WidgetTypes table contains XYZ and is referred to by the Widget table's type_id column.
because simple plain english is more understandable than terms the reader has to look up in a dictionary.
I would reserve Parent/Child for hierarchical data. It feels weird to be my parent's parent ...
Edit: While Tim is correct in pointing out that the noun "reference" is ambiguous with respect to direction, I have never perceived such ambiguity with the verb "to reference" used by my suggestion. Be that as it may, the direction of "refer to", which my second suggestion relies on, is clear.
The WidgetTypes table contains the types of widgets and is related to Widgets through the Widget table's type_id column.
Parent/Child or Primary/Foreign work.
精彩评论