Basic Concepts: Parent Table and Child Table

Some concepts of PD(PowerDesigner) are different from others, like parent/child table.

If two table are related by foreign key, the table whose PK(primary key) is pointed by the FK(foreign key) is parent table, and the other is child table.

e.g., there are two tables:

  • t_student(student_id, student_name, student_age, class_id)
  • t_class(class_id, class_name)

The two tables are related by a foreign key class_id of t_student.

As the above, t_student is the child table and t_class is the parent table. This is a simplest sample of parent and child table.