Quote:
Originally Posted by valrecx
hi guys, what are parent row, child row, parent table, child table, in relational database?
|
a parent row is a row in the parent table
a child row is a row in the child table
there, that takes care of two of them
"parent" and "child" are informal terms applied to two tables which have a
foreign key relationship
the foreign key is defined in the child table, and refers to a primary or unique key in the parent table
the relationship is one-to-many -- each parent row can have multiple child rows, but each child row can have only one parent row
now all you need to look up is
foreign key
