Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleSchema Hierarchies (Parent and Child)

Schema Hierarchies (Parent and Child)

In a parent/child setup, the children get the fields from their parents and can have their own fields too, e.g., parent “product” “controlled vocabulary” with a field: codeterm; child “fruits”“keywords.Picturepark displays the children in a tree-like hierarchy, so you know which schemas belong together.  

Image Removedschemas_hierarchies_parent-child.mp4
  • You cannot remove a field that is on the parent from a child schema.

  • You can only reorder the fields that are on the child directly. You cannot reorder inherited fields. The parent fields are at the top, above and below are the child fields.

  • You can break inheritance for tagboxes but not for other fields, so your tagbox can be required on the parent and not on the child. Other fields like a title or date field are required on parent and child.

Expand
titleSchema Circular References

Schema Circular References

🔖 Picturepark Press Release

Circular references, also known as cyclic dependencies, make it possible to refer from one record to another and vice-versa. 

  1. Connecting lists: Cities and Regions

    1. The city of Aarau is in the Region of Aargau. The capital of Aargau is Aarau. 

  2. Connecting lists: Product and Market

    1. Product A is available in markets D, A, and CH. In Market CH, the best-selling product is A. 

  3. Connecting lists: Employee and Department 

    1. The employee Megan Manager works in the department Marketing. The supervisor of the department Marketing is Megan Manager. 

Entity Relationship

An employee with the Department. & The Department with a Supervisor.

You have a person and department entity. The person is a member of a single department (simplified). The Department has a supervisor who is one of the Employee members. 

...