Document toolboxDocument toolbox

sp401_component_hierarchy

This table records the hierarchy between Monitored Components (processes). There may be multiple entries for each component_no. A component_no can appear multiple times in the is_client_of column, but each row should have a unique pair.


 

Table Definition

Field
Type
Default
Nullable
component_nonumber (error)
is_client_ofnumber (error)

Keys

unique (component_no, is_client_of) 
foreign key (component_no) references sp400_components (component_no) 
foreign key (is_client_of) references sp400_components (component_no)

Column Descriptions

FieldDescription
component_noComponent identifier (the client).
is_client_ofComponent identifier (the server).