/ doc / tocNamespace / ARCCore / PKRelAttribute / __TOCDet / Attribute / Description

Description

Edit keys at this level only

= Describes relationships between entities (between tables in RDBMS terms).0x000D0x000A0x000D0x000ANote than in general relationsships are picked up automatically in AgoRapide through standardized naming of keys.0x000D0x000A0x000D0x000AFor instance, for 'Order', key 'CustomerId' is automatically assumed to point to a -ForeignEntity- of type 'Customer', so this attribute does not have to be specified.0x000D0x000A0x000D0x000AHowever, for 'Employee', key 'SupervisorId' where the supervisor is another 'Employee', -ForeignEntity- has to be explicitly specified in order for the system to understand that 'SupervisorId' is actually a foreign key pointing to another 'Employee'.0x000D0x000A(this is not necessarily limited to self-referencing tables, another example could be 'Transaction' with 'FromAccountId' and 'ToAccountId' both pointing to an 'Account'.)0x000D0x000A0x000D0x000AUsed by -ARCQuery- (in -QueryExpressionRel- and -ForeignKey-) in order to enable queries like:0x000D0x000A"Employee/WHERE DepartmentId = 'Sales'/REL Supervisor" (all Supervisors of Employees in Sales) and0x000D0x000A"Employee/WHERE DepartmentId = 'Sales'/SELECT Name, Supervisor.Name).0x000D0x000A0x000D0x000AIn addition to explicit stating -ForeignEntity-, this attribute is also used to -EnforceReferentialIntegrity-0x000D0x000A.0x000D0x000ASee also -IPRelationsKeysPointingTo- and -IPRelationsKeysPointingFrom- in -ARCQuery-.0x000D0x000A

Edit keys at all sub levels.
NOTE: Edits are always additive. Use 'Invalid' in order to delete keys.

Generated 2025-06-18 18:32:03.721 UTC