User Tools

Site Tools

:: Latest version ::

latest:admin:browsing_the_data_model

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

latest:admin:browsing_the_data_model [2019/06/06 15:42] (current)
Line 1: Line 1:
 +====== Browsing the Data Model ======
 +
 +Depending on the modules installed during the setup, the data model of iTop (also called the objects schema) can vary. You can view the current data model used by iTop by clicking on the link “Data Model” in the “Admin Tools” menu.
 +
 +{{:​2_6_0:​admin:​datamodelviewer-1.png|iTop Data Model viewer structure}}
 +
 +<note tip>Use the middle handle to resize left/right panes, or to close left pane.</​note>​
 +
 +===== Selecting a class =====
 +
 +
 +On the left explorer tree-view allows you to navigate through the hierarchy of classes (in alphabetical order). Each entry contains, according to the display granularity parameter, the display name of the class (label parameter), its internal OQL/PHP name (code parameter), or both (label and code parameter).
 +
 +To quickly find the link to a specific class in the data model, use the autcomplete filter above classes list and press enter in the filter or click on a class name to display the details for this class.
 +
 +{{:​2_6_0:​admin:​datamodelviewer-2.png|iTop Data Model viewer class tree view filter}}
 +
 +===== Class details =====
 +
 +Once a class has been selected, you'll be able to see details about this class in different tabs (Attributes,​ Related classes, Child classes, Lifecycle and Triggers).
 +
 +==== Attributes tab ====
 +
 +On the Attributes tab, multiple informations about this class attributes are available (also depends on the display granularity parameter), and more information can be displayed by hovering cells.
 +
 +Attributes tab definition:
 +
 +^  Tab  ^  Description ​ ^ Hover description ^
 +|Attribute code|Attribute internal code used to idenfiy this class attribute| Attribute definition/​link to other class|
 +|Type|Data type of  this attribute| Type definition`|
 +|Allowed values|Restriction on the possible values for this attribute| If this field is a filter, display the raw OQL to get these values |
 +|More info|More information about the field defined in the database| If a default null is provided, display this information|
 +|Origin|The base class in which this attribute is defined (This information is also shown in the first column with a color code)| |
 +
 +{{:​2_6_0:​admin:​datamodelviewer-3.png|iTop Data Model viewer class details on the attribute tab}}
 +
 +==== Related classes tab  ====
 +
 +On the Related classes tab you'll be able to see the curent classes attributes that are external key (single arrow pointing another class), n-1 key (single arrow pointing to current class attribute), 1-n & n-n  (double arrow with dot in the middle) and other classes external key pointing to our current class (single arrow pointing to current class).
 +The origin of each attributes is shown with a color code (same one as Attribute tabs' first column) on the left of each attribute
 +
 +{{:​2_6_0:​admin:​datamodelviewer-4.png|iTop Data Model viewer class details on the attribute tab}}
 +
 +This graphical view allows to click on different class names in order to navigate through the datamodel and to see when the current class is linked to another class through a linkset (1-n or n-n). To get more details about this linkset, hover the dot between 2 classes.
 +
 +{{:​2_6_0:​admin:​datamodelviewer-5.png|iTop Data Model viewer class details on the attribute tab}}
 +
 +On classes with one (or more) hierarical key attribute, you can find a bowed arrow on top of  the class rectangle and also a bowed arrow next to each hierarical key attribute.
 +
 +{{:​2_6_0:​admin:​datamodelviewer-6.png|iTop Data Model viewer class details on the attribute tab}}
 +
 +
 +==== Lifecycle tab  ====
 +
 +On the Lifecycle tab, if a lifecycle has been set up, a graph build with graphviz will be displayed along with related information about different relationship between states, transitions and attributes options (Read-only, mandatory or hidden).
 +
 +{{:​2_6_0:​admin:​datamodelviewer-7.png|iTop Data Model viewer class details on the attribute tab}}
 +
 +==== Triggers tab  ====
 +
 +Displays the lifecycle graph for the class and some related information.
  
latest/admin/browsing_the_data_model.txt · Last modified: 2019/06/06 15:42 (external edit)

";