Property Inspector: Link

This page describes properties listed for a Link 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.

• 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.

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.

• 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.