Contains the hierarchy of the inventory items collected by the general inventory component.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| object_uuid | byte(16) | not null | Primary Key. Foreign key to either ca_discovered_hardware, ca_discovered_user, ca_link_hw_user. |
| item_id | integer | not null | Primary Key . Id of the current node |
| item_root_id | integer | with null | ID of the Root node. Points to the item_id that is the root of the component |
| item_parent_id | integer | with null | Id of the parent node. Points to the item_id that is the parent of this tree item. 0 indicates that this is the root. |
| item_parent_name_id | integer | with null | Name id of the parent item. Foreign key to inv_tree_name_id. 0 indicates that this is the root. |
| item_indent | integer | with null | Level for this tree item. 1=Root,2=child to root, etc |
| item_index | integer | with null | Index for this tree item, among those that points to the same mother tree item. |
| item_flag | integer | with null | 1=Simple tree structure. 2=Rows. |
| item_root_name_id | integer | with null | Name id of the root node. Foreign key to inv_tree_name_id |
| domain_uuid | byte(16) | with null | Foreign key to the ca_n_tier table. Can normally also be found in ca_settings table where set_id=1. |
| item_name_id | integer | with null | Name id of the current tree item. Foreign key to inv_tree_name_id. |
| object_type | integer | with null | Type of object |
| auto_rep_version | date | with null | Replication version, will be updated automatically by the DBMS. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| object_uuid item_id |
inv_generalinventory_item | object_uuid item_parent_id |