...
Field Name | Description |
---|---|
Default Parent Relation: | Logical flag indicating if this relation is the default parent relation (e.g. GetParentDescriptionOf method in the Consultingwerk.SmartFramework.IRelationService service) |
Description: | A description for the relation |
Parent Table: | The name of the parent table (lookup on the imported database tables) |
Parent Table Cardinality: | Cardinality of the parent table |
Parent Role Description: | Label of the parent record relation from the child record (e.g. “Order is header of OrderLine”) |
Child Table: | The name of the child table (lookup on the imported database tables) |
Child Table Cardinality: | Cardinality of the child table |
Child Role Description: | Label of the child record relation from the parent record (e.g. “Orderline belongs to Order) |
Relation Field Pair(s): | The comma delimited list of field pairs that manifest the relation (equality matching fields) |
On Parent Delete: | Referential Integrity Rule for deleting the Parent Record |
Inactive: | Allows to disable the relation without deleting it completely. When the relation is disabled it will not be used for referential integrity validation or other related functions |
Info | ||
---|---|---|
| ||
After modifying the relation definition it's required to restart all AppServer agents/sessions or self-service clients as the relations are cached at runtime. |
On Parent Delete rules
Do nothing | No action is performed when the parent is deleted |
Cascade | Automatically delete child records of a parent record that is deleted |
Nullify | When the parent is deleted, assign the childs relation fields to ? |
Restrict | When the parent is deleted and at least one child record exists, reject the deletion of the parent |
...