Hierarchy ERD

HIERARCHY

This table record hierarchy name defined for a specific hierarchy

HIERARCHY_DESC

This table defines specific levels of a hierarchy. For example, a hierarchy may use countries, provinces. This table does not describe a specific instance of a hierarchy but what level type is used.

HIERARCHY_LEVEL

This table places specific instances at a specific level of a hierarchy. Note that more than one object may exist at any given level.

HIERARCHY_TEMPLATE

This table is used to record hierarchy structure name used for assign hierarchy.

HIERARCHY_TEMPLATE_DESC

This table defines specific levels of a hierarchy template. For example, a hierarchy may use countries, provinces. This table does not describe a specific instance of a hierarchy but will be used as a template for creating new valid hierarchies.

ORG_UNIT

Record the geographical area and organizational unit.

R_ORG_UNIT_TYPE

The reference type of organization unit. For example: country, province, state, or company.

FIELD_ORG_UNIT

This table is used to record the field historical relationship with org units.

WELL_ORG_UNIT

This table is used to record the well historical relationship with org units.

FACILITY_ORG_UNIT

This table is used to record the facility historical relationship with org units.

R_ORG_UNIT_CATEGORY

The reference of unit category, such as area unit or business unit.