Entity CustomRelation

Description of Entity CustomRelation

Using relationships to link queries within a query folder.


List of all Dependencies of the Entity CustomRelation

Name

Code

Class Name

Relation_166859

Relation_166859

Reference


List of Attributes of the Entity CustomRelation

Name

Code

RelationSysId

RelationSysId

Detail Table ID

DetailTableID

Detail Attribute ID

DetailAttributeID

Master Table ID

MasterTableID

MasterAttributeID

MasterAttributeID


Entity Attribute RelationSysId of the Entity CustomRelation

Card of Attribute RelationSysId of the Entity CustomRelation

Name

RelationSysId

Code

RelationSysId

Data Type

integer

Mandatory

Yes


Description of Attribute RelationSysId of the Entity CustomRelation

A system generated identity. It is blind to the user. It is also the primary key for the CustomRelation table.


Entity Attribute Detail Table ID of the Entity CustomRelation

Card of Attribute Detail Table ID of the Entity CustomRelation

Name

Detail Table ID

Code

DetailTableID

Data Type

char(20)

Mandatory

No


Description of Attribute Detail Table ID of the Entity CustomRelation

Shows the identity of the detail table.
Example: Employee / Personal etc


Entity Attribute Detail Attribute ID of the Entity CustomRelation

Card of Attribute Detail Attribute ID of the Entity CustomRelation

Name

Detail Attribute ID

Code

DetailAttributeID

Data Type

char(20)

Mandatory

No


Description of Attribute Detail Attribute ID of the Entity CustomRelation

Shows the identity of the detail attribute.
Example: EmployeeSysId / PersonalSysId etc


Entity Attribute Master Table ID of the Entity CustomRelation

Card of Attribute Master Table ID of the Entity CustomRelation

Name

Master Table ID

Code

MasterTableID

Data Type

char(20)

Mandatory

No


Description of Attribute Master Table ID of the Entity CustomRelation

Shows the identity of the master table.
Example: ConfirmedEmp etc


Entity Attribute MasterAttributeID of the Entity CustomRelation

Card of Attribute MasterAttributeID of the Entity CustomRelation

Name

MasterAttributeID

Code

MasterAttributeID

Data Type

char(20)

Mandatory

No


Description of Attribute MasterAttributeID of the Entity CustomRelation

Shows the identity of the master attribute.
Example: EmployeeSysId / PersonalSysId etc


Previous
Home
Next