Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 6 Procedure Management : proc_mgt_hierarchy

proc_mgt_hierarchy
The proc_mgt_hierarchy table stores a set of hierarchy records, which define the hierarchical structure of the Procedure Management library. Each record defines the location of a procedure object in the library.
Structure
The proc_mgt_hierarchy table has the following structure:
TABLE proc_mgt_hierarchy(
parent_guid VARCHAR(36) NOT NULL,
object_guid VARCHAR(36) NOT NULL,
is_shortcut SMALLINT NOT NULL)
Note: If is_shortcut is 1, this value is the identifier of the procedure object pointed to by the shortcut.
Primary Key
The following primary key is defined for this table.
Triggers
None.
Indexes
The following index is defined for this table.
Table Activity
The proc_mgt_hierarchy table contains one row for every procedure object in the Procedure Management library (except for the root Procedure Management library).
Rows are added, updated and deleted in the following situations.
 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved