This dashboard contains three tables to enable you to better understand how your environment is structured.

Tables details

This table shows all the tables present in the environment and is composed of the following columns:

  • Table ID: the unique id of the table

  • Table type: the type of the table. Can be one of these:

    • Log

    • List

    • Workflow

    • Document

    • Email Generation

    • User

    • Transformation

    • Other

    • Structure

    • Stream

  • Nb lines: number of lines in the table

  • Active: True if the table is not archived, false otherwise

  • Scope: when applicable, the scope of the table, can be

    • global

    • teams (multiple)

    • single team

    • mobile users (multiple)

    • single mobile user

This table shows the relationships between the tables. It is composed of the following columns:

  • Table 1 ID: unique ID of the table

  • Table 2 ID: unique ID of the table

  • Link variable Table 1: the variable used in table 1 to do the link between the two tables

  • Link variable Table 2: the variable used in table 2 to do the link between the two tables

Variables

This table lists all the variables present across all the tables in the environment, it is composed of the following columns:

  • Table ID: the unique id of the table

  • Tag / Attribute: the unique tag of the workflow variable / list attribute in the table

  • Tag / Attribute type: the type of tag / attribute

  • Variable Name: the unique variable name

  • Variable Label: the unique variable label

  • Variable Type: the type

  • Options Tag: the unique tag of each options for single / multiple choice variables

  • Options Label: the label of the options

  • Is mandatory: true if the variable is mandatory

  • Is SQL: true if the variable is updated by an SQL query

  • Has condition: true if the variable has conditions attached to it

  • Active: true if not archived, false otherwise