Switch to: V12V11V10V9V8V7V6V5

Property Inspector: Link

This page describes properties listed for a Link object.

Category "Object"

  • Class - Specifies the class of the selected object.
  • Name - The name of the selected link.
  • ID - The internal ID of the object.
  • Comment - Comment to this link.

Category "Settings" Common

  • Type - Specifies the type of link. One of { Binary Link, ObjectPtr, RDB Link }.
  • Cardinality - Specifies the power of link, thus 1:1, 1:M or M:M.

RDB Link is regular link from Relational Model based on Primary and Foreign keys of two tables. It is able provide 1:1 and 1:M connections between records.

  • Parent Table - The parent table in RDB link. This is ONE table in the 1:M link.
  • Primary Key - The Primary Key field(s) of the parent table.
  • Child Table - The child table. This is MANY table in the 1:M link.
  • Foreign Key - The Foreign Key field(s) of the child table.
  • On Delete - Specifies the action on deletion of the parent record.
  • On Update - Specifies the action on update of primary key of the parent record.

Category "Settings" for ObjectPtr

ObjectPtr-link is based on RecID field of the parent table, so there is no need in primary and foreign keys for this link. It is able provide 1:1 and 1:M connections between records. This is unique feature of Valentina database.

  • Parent Table - The parent table in RDB link. This is ONE table in the 1:M link.
  • Child Table - The child table. This is MANY table in the 1:M link.
  • On Delete - Specifies the action on deletion of the parent record.

Binary-link is based on RecID fields of left and right tables. It is able provide 1:1, 1:M and M:M connections. This is unique feature of Valentina database.

  • Parent Table - The parent table in RDB link. This is ONE table in the 1:M link.
  • Child Table - The child table. This is MANY table in the 1:M link.
  • On Delete - Specifies the action on deletion of the parent record.
  • Owner - Names the owner table of the link. Enabled only for symmetric links as 1:1 and M:M.

Category "Information"

  • Branch Count - Displays the number of branches of the link.
  • Property Count - The size of this link on disk/in RAM.
  • Size - The size of this link on disk/in RAM.