/ doc / tocInheritance / IP / BaseAttribute / EnumMemberAttribute / BasePKAttribute / PKRelAttribute

PKRelAttribute

Edit keys at this level only

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

__TOCDet/Assembly = ARCCore
__TOCDet/Description = 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
__TOCDet/DocFragType = Class
__TOCDet/Name = PKRelAttribute
__TOCDet/Namespace = ARCCore
__TOCDet/Type = PKRelAttribute
__TOCDet/Attribute/AssemblyName = ARCCore
__TOCDet/Attribute/BaseTypes = Attribute0x003BBaseAttribute0x003BEnumMemberAttribute0x003BBasePKAttribute
__TOCDet/Attribute/ClassNamespace = ARCCore
__TOCDet/Attribute/ClassType = PKRelAttribute
__TOCDet/Attribute/CorrespondingEnumType = PKRelAttributeP
__TOCDet/Attribute/Description = 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
__TOCDet/Attribute/Interfaces = IP0x003BIEnumerable0xoooo003CIKIP0xoooo003E0x003BIEnumerable

Edit single sub keys only: __TOCDet

Generated 2025-06-20 07:49:34.837 UTC