|
<< Click to Display Table of Contents >> Navigation: Types > RelationType |
A Relation is a relation between aspects used to save combinations, authorizations and group members.
A Relation has got three fields: id1, id2 and RelationType. The RelationType describes the purpose of the relation and the meaning of id1 and id2.
Here you can find the explanation per RelationType used in TimeWriter Standard:
RelationType |
Purpose |
id1 |
id2 |
AUTHORIZATION-IT_MED-IT_AT1 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType IT_AT1 (aspect 1) |
AUTHORIZATION-IT_MED-IT_AT2 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType IT_AT2 (aspect 2) |
AUTHORIZATION-IT_MED-IT_AT3 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType IT_AT3 (aspect 3) |
|
|||
AUTHORIZATION-IT_MED-IT_AT1_ALL |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
-1 (is All aspects with AspectType IT_AT1) 1) |
AUTHORIZATION-IT_MED-IT_AT2_ALL |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
-1 (is All aspects with AspectType IT_AT2) 1) |
AUTHORIZATION-IT_MED-IT_AT3_ALL |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
-1 (is All aspects with AspectType IT_AT3) 1) |
|
|||
COMBINATION-IT_AT1-IT_AT2 |
Combination |
id of a aspect with AspectType IT_AT1 (aspect 1) |
id of a aspect with AspectType IT_AT2 (aspect 2) |
COMBINATION-IT_AT2-IT_AT3 |
Combination |
id of a aspect with AspectType IT_AT2 (aspect 2) |
id of a aspect with AspectType IT_AT3 (aspect 3) |
|
|||
COMBINATION-IT_AT1-IT_AT2_ALL |
Combination |
id of a aspect with AspectType IT_AT1 (aspect 1) |
-1 (is All aspects with AspectType IT_AT2) 1) |
COMBINATION-IT_AT2-IT_AT3_ALL |
Combination |
id of a aspect with AspectType IT_AT2 (aspect 2) |
-1 (is All aspects with AspectType IT_AT3) 1) |
1) The value of id2 is always -1 when the RelationType ends with ALL.
Here you can find the explanation per RelationType used in TimeWriter Pro:
RelationType |
Purpose |
id1 |
id2 |
GROUP_MEMBER-GR_AT1-IT_AT1 |
Group membership |
id of a aspect with AspectType GR_AT1 (aspect group 1) |
id of a aspect with AspectType IT_AT1 (aspect 1) |
GROUP_MEMBER-GR_AT2-IT_AT2 |
Group membership |
id of a aspect with AspectType GR_AT2 (aspect group 2) |
id of a aspect with AspectType IT_AT2 (aspect 2) |
GROUP_MEMBER-GR_AT3-IT_AT3 |
Group membership |
id of a aspect with AspectType GR_AT3 (aspect group 3) |
id of a aspect with AspectType IT_AT3 (aspect 3) |
GROUP_MEMBER-GR_AT4-IT_AT4 |
Group membership |
id of a aspect with AspectType GR_AT4 (aspect group 4) |
id of a aspect with AspectType IT_AT4 (aspect 4) |
GROUP_MEMBER-GR_AT5-IT_AT5 |
Group membership |
id of a aspect with AspectType GR_AT5 (aspect group 5) |
id of a aspect with AspectType IT_AT5 (aspect 5) |
GROUP_MEMBER-GR_MED-IT_MED |
Group membership |
id of a aspect with AspectType GR_MED (employee group) |
id of a aspect with AspectType IT_MED (employee) |
GROUP_MEMBER-GR_AT1-IT_AT1_ALL |
Group membership |
id of a aspect with AspectType GR_AT1 (aspect group 1) |
-1 (is All aspects with AspectType IT_AT1) 1) |
GROUP_MEMBER-GR_AT2-IT_AT2_ALL |
Group membership |
id of a aspect with AspectType GR_AT2 (aspect group 2) |
-1 (is All aspects with AspectType IT_AT2) 1) |
GROUP_MEMBER-GR_AT3-IT_AT3_ALL |
Group membership |
id of a aspect with AspectType GR_AT3 (aspect group 3) |
-1 (is All aspects with AspectType IT_AT3) 1) |
GROUP_MEMBER-GR_AT4-IT_AT4_ALL |
Group membership |
id of a aspect with AspectType GR_AT4 (aspect group 4) |
-1 (is All aspects with AspectType IT_AT4) 1) |
GROUP_MEMBER-GR_AT5-IT_AT5_ALL |
Group membership |
id of a aspect with AspectType GR_AT5 (aspect group 5) |
-1 (is All aspects with AspectType IT_AT5) 1) |
GROUP_MEMBER-GR_MED-IT_MED_ALL |
Group membership |
id of a aspect with AspectType GR_MED (employee group) |
-1 (is All aspects with AspectType IT_MED) 1) |
|
|||
AUTHORIZATION-IT_MED-IT_AT1 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType IT_AT1 (aspect 1) |
AUTHORIZATION-GR_MED-IT_AT1 |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
id of a aspect with AspectType IT_AT1 (aspect 1) |
AUTHORIZATION-GR_MED-GR_AT1 |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
id of a aspect with AspectType GR_AT1 (aspect group 1) |
AUTHORIZATION-IT_MED-GR_AT1 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType GR_AT1 (aspect group 1) |
AUTHORIZATION-IT_MED-IT_AT1_ALL |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
-1 (is All aspects with AspectType IT_AT1) 1) |
AUTHORIZATION-GR_MED-IT_AT1_ALL |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
-1 (is All aspects with AspectType IT_AT1) 1) |
|
|||
AUTHORIZATION-IT_MED-IT_AT2 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType IT_AT2 (aspect 2) |
AUTHORIZATION-GR_MED-IT_AT2 |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
id of a aspect with AspectType IT_AT2 (aspect 2) |
AUTHORIZATION-GR_MED-GR_AT2 |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
id of a aspect with AspectType GR_AT2 (aspect group 2) |
AUTHORIZATION-IT_MED-GR_AT2 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType GR_AT2 (aspect group 2) |
AUTHORIZATION-IT_MED-IT_AT2_ALL |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
-1 (is All aspects with AspectType IT_AT2) 1) |
AUTHORIZATION-GR_MED-IT_AT2_ALL |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
-1 (is All aspects with AspectType IT_AT2) 1) |
|
|||
AUTHORIZATION-IT_MED-IT_AT3 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType IT_AT3 (aspect 3) |
AUTHORIZATION-GR_MED-IT_AT3 |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
id of a aspect with AspectType IT_AT3 (aspect 3) |
AUTHORIZATION-GR_MED-GR_AT3 |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
id of a aspect with AspectType GR_AT3 (aspect group 3) |
AUTHORIZATION-IT_MED-GR_AT3 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType GR_AT3 (aspect group 3) |
AUTHORIZATION-IT_MED-IT_AT3_ALL |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
-1 (is All aspects with AspectType IT_AT3) 1) |
AUTHORIZATION-GR_MED-IT_AT3_ALL |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
-1 (is All aspects with AspectType IT_AT3) 1) |
|
|||
AUTHORIZATION-IT_MED-IT_AT4 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType IT_AT4 (aspect 4) |
AUTHORIZATION-GR_MED-IT_AT4 |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
id of a aspect with AspectType IT_AT4 (aspect 4) |
AUTHORIZATION-GR_MED-GR_AT4 |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
id of a aspect with AspectType GR_AT4 (aspect group 4) |
AUTHORIZATION-IT_MED-GR_AT4 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType GR_AT4 (aspect group 4) |
AUTHORIZATION-IT_MED-IT_AT4_ALL |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
-1 (is All aspects with AspectType IT_AT4) 1) |
AUTHORIZATION-GR_MED-IT_AT4_ALL |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
-1 (is All aspects with AspectType IT_AT4) 1) |
|
|||
AUTHORIZATION-IT_MED-IT_AT5 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType IT_AT5 (aspect 5) |
AUTHORIZATION-GR_MED-IT_AT5 |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
id of a aspect with AspectType IT_AT5 (aspect 5) |
AUTHORIZATION-GR_MED-GR_AT5 |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
id of a aspect with AspectType GR_AT5 (aspect group 5) |
AUTHORIZATION-IT_MED-GR_AT5 |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
id of a aspect with AspectType GR_AT5 (aspect group 5) |
AUTHORIZATION-IT_MED-IT_AT5_ALL |
Authorization |
id of a aspect with AspectType IT_MED (employee) |
-1 (is All aspects with AspectType IT_AT5) 1) |
AUTHORIZATION-GR_MED-IT_AT5_ALL |
Authorization |
id of a aspect with AspectType GR_MED (employee group) |
-1 (is All aspects with AspectType IT_AT5) 1) |
|
|||
COMBINATION-IT_AT1-IT_AT2 |
Combination |
id of a aspect with AspectType IT_AT1 (aspect 1) |
id of a aspect with AspectType IT_AT2 (aspect 2) |
COMBINATION-IT_AT1-GR_AT2 |
Combination |
id of a aspect with AspectType IT_AT1 (aspect 1) |
id of a aspect with AspectType GR_AT2 (aspect group 2) |
COMBINATION-GR_AT1-IT_AT2 |
Combination |
id of a aspect with AspectType GR_AT1 (aspect group 1) |
id of a aspect with AspectType IT_AT2 (aspect 2) |
COMBINATION-GR_AT1-GR_AT2 |
Combination |
id of a aspect with AspectType GR_AT1 (aspect group 1) |
id of a aspect with AspectType GR_AT2 (aspect group 2) |
COMBINATION-IT_AT1-IT_AT2_ALL |
Combination |
id of a aspect with AspectType IT_AT1 (aspect 1) |
-1 (is All aspects with AspectType IT_AT2) 1) |
COMBINATION-GR_AT1-IT_AT2_ALL |
Combination |
id of a aspect with AspectType GR_AT1 (aspect group 1) |
-1 (is All aspects with AspectType IT_AT2) 1) |
|
|||
COMBINATION-IT_AT2-IT_AT3 |
Combination |
id of a aspect with AspectType IT_AT2 (aspect 2) |
id of a aspect with AspectType IT_AT3 (aspect 3) |
COMBINATION-IT_AT2-GR_AT3 |
Combination |
id of a aspect with AspectType IT_AT2 (aspect 2) |
id of a aspect with AspectType GR_AT3 (aspect group 3) |
COMBINATION-GR_AT2-IT_AT3 |
Combination |
id of a aspect with AspectType GR_AT2 (aspect group 2) |
id of a aspect with AspectType IT_AT3 (aspect 3) |
COMBINATION-GR_AT2-GR_AT3 |
Combination |
id of a aspect with AspectType GR_AT2 (aspect group 2) |
id of a aspect with AspectType GR_AT3 (aspect group 3) |
COMBINATION-IT_AT2-IT_AT3_ALL |
Combination |
id of a aspect with AspectType IT_AT2 (aspect 2) |
-1 (is All aspects with AspectType IT_AT3) 1) |
COMBINATION-GR_AT2-IT_AT3_ALL |
Combination |
id of a aspect with AspectType GR_AT2 (aspect group 2) |
-1 (is All aspects with AspectType IT_AT3) 1) |
|
|||
COMBINATION-IT_AT3-IT_AT4 |
Combination |
id of a aspect with AspectType IT_AT3 (aspect 3) |
id of a aspect with AspectType IT_AT4 (aspect 4) |
COMBINATION-IT_AT3-GR_AT4 |
Combination |
id of a aspect with AspectType IT_AT3 (aspect 3) |
id of a aspect with AspectType GR_AT4 (aspect group 4) |
COMBINATION-GR_AT3-IT_AT4 |
Combination |
id of a aspect with AspectType GR_AT3 (aspect group 3) |
id of a aspect with AspectType IT_AT4 (aspect 4) |
COMBINATION-GR_AT3-GR_AT4 |
Combination |
id of a aspect with AspectType GR_AT3 (aspect group 3) |
id of a aspect with AspectType GR_AT4 (aspect group 4) |
COMBINATION-IT_AT3-IT_AT4_ALL |
Combination |
id of a aspect with AspectType IT_AT3 (aspect 3) |
-1 (is All aspects with AspectType IT_AT4) 1) |
COMBINATION-GR_AT3-IT_AT4_ALL |
Combination |
id of a aspect with AspectType GR_AT3 (aspect group 3) |
-1 (is All aspects with AspectType IT_AT4) 1) |
|
|||
COMBINATION-IT_AT4-IT_AT5 |
Combination |
id of a aspect with AspectType IT_AT4 (aspect 4) |
id of a aspect with AspectType IT_AT5 (aspect 5) |
COMBINATION-IT_AT4-GR_AT5 |
Combination |
id of a aspect with AspectType IT_AT4 (aspect 4) |
id of a aspect with AspectType GR_AT5 (aspect group 5) |
COMBINATION-GR_AT4-IT_AT5 |
Combination |
id of a aspect with AspectType GR_AT4 (aspect group 4) |
id of a aspect with AspectType IT_AT5 (aspect 5) |
COMBINATION-GR_AT4-GR_AT5 |
Combination |
id of a aspect with AspectType GR_AT4 (aspect group 4) |
id of a aspect with AspectType GR_AT5 (aspect group 5) |
COMBINATION-IT_AT4-IT_AT5_ALL |
Combination |
id of a aspect with AspectType IT_AT4 (aspect 4) |
-1 (is All aspects with AspectType IT_AT5) 1) |
COMBINATION-GR_AT4-IT_AT5_ALL |
Combination |
id of a aspect with AspectType GR_AT4 (aspect group 4) |
-1 (is All aspects with AspectType IT_AT5) 1) |
1) The value of id2 is always -1 when the RelationType ends with ALL.