| Database Table OrgUnitLineage |
[This is preliminary documentation and is subject to change.]
The OrgUnitLineage table is a helper table. The main purpose is to make it easier to find descendants and ancestors to a given oganizational unit. This can be accomplished by using the table in JOIN statements.
Each row in the table corresponds to a ancestor/descendant relationship.
FieldsField name | Type | Note | Description |
|---|---|---|---|
AncestorType | VARCHAR(20) | The type of the ancestor organizational unit in this ancestor/descendant relationship | |
AncestorCode | VARCHAR(20) | The code for the ancestor organizational unit in this ancestor/descendant relationship | |
DescendantType | VARCHAR(20) | The type of the descendant organizational unit in this ancestor/descendant relationship | |
DescendantCode | VARCHAR(20) | The code for the descendant organizational unit in this ancestor/descendant relationship |
RelationsTable | Relation |
|---|---|
AncestorType/AncestorCode refers to an organizational unit in the OrgUnitCurrent view | |
DescendantType/DescendantCode refers to an organizational unit in the OrgUnitCurrent view | |
AncestorType is a 0..1 relation to OrgUnitType | |
DescendantType is a 0..1 relation to OrgUnitType |