[ROOT] / doc / toc / ARAdventureWorksOLAP / Enum / DimEmployeeP / ParentEmployeeId / __TOCDet

Key	Value
Assembly	ARAdventureWorksOLAP
DocFragType	EnumMember
Name	ParentEmployeeId
Namespace	ARAdventureWorksOLAP
Type	DimEmployeeP

Key	Value
PKRelAttribute	Describes relationships between entities (between tables in RDBMS terms). Note than in general relationsships are picked up automatically in AgoRapide through standardized naming of keys. For 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. However, 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'. (this is not necessarily limited to self-referencing tables, another example could be 'Transaction' with 'FromAccountId' and 'ToAccountId' both pointing to an 'Account'.) Used by ARCQuery (in QueryExpressionRel and ForeignKey) in order to enable queries like: "Employee/WHERE DepartmentId = 'Sales'/REL Supervisor" (all Supervisors of Employees in Sales) and "Employee/WHERE DepartmentId = 'Sales'/SELECT Name, Supervisor.Name). In addition to explicit stating ForeignEntity, this attribute is also used to EnforceReferentialIntegrity . See also IPRelationsKeysPointingTo and IPRelationsKeysPointingFrom in ARCQuery. EnumMember, EnumType, ForeignEntity, OppositeTerm
PKTypeAttribute	Called 'ParentEmployeeKey' in original sample database BoilerplateCodeProperties, Cardinality, Description, EnumMember, EnumType, IsObligatory, Type

Key

Value

PKRelAttribute

Describes relationships between entities (between tables in RDBMS terms).

Note than in general relationsships are picked up automatically in AgoRapide through standardized naming of keys.

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

However, 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'.
(this is not necessarily limited to self-referencing tables, another example could be 'Transaction' with 'FromAccountId' and 'ToAccountId' both pointing to an 'Account'.)

Used by ARCQuery (in QueryExpressionRel and ForeignKey) in order to enable queries like:
"Employee/WHERE DepartmentId = 'Sales'/REL Supervisor" (all Supervisors of Employees in Sales) and
"Employee/WHERE DepartmentId = 'Sales'/SELECT Name, Supervisor.Name).

In addition to explicit stating ForeignEntity, this attribute is also used to EnforceReferentialIntegrity
.
See also IPRelationsKeysPointingTo and IPRelationsKeysPointingFrom in ARCQuery.

EnumMember, EnumType, ForeignEntity, OppositeTerm

PKTypeAttribute

Called 'ParentEmployeeKey' in original sample database

BoilerplateCodeProperties, Cardinality, Description, EnumMember, EnumType, IsObligatory, Type

Called 'ParentEmployeeKey' in original sample database

Edit

Generated 2024-04-27 15:59:45.101 UTC