Parent-child association among schemas

When you want to apply the referential integrity rules among multiple non-JDBC schemas, you must associate a parent-child relationship among schemas on the Schema Canvas page.

When you want to maintain a logical relationship among multiple schemas, then you must establish a parent-child relationship among those schemas. The parent and child schemas must be related to each other by using common item types. The item type of the parent schema is designated as the Primary key, and the related item type of child schema is designated as the Foreign key.

The referential integrity among the parent and child schemas in HCL® OneTest Data supports the following relations:

  • One-to-one
  • One-to-many
  • Many-to-one
  • Self-reference
Notes:
  • You can establish relationships only among non-JDBC schemas.
  • The item types that relate to parent-child schemas must be of the same data type and size.

You can find information about establishing a parent-child relationship within the different schema groups in the following topic:

Establishing a parent-child relationship within different schema groups