Viewing tables with Foreign Key relation

Before you start, you must complete a table search task. See Searching for program.

The CONO and DIVI column keys are used by most of the BE tables. These keys are not included in the unique key comparison.

  1. On the Search Results tab, select a Table name.

    A new search result opens with the header Table Relation Type: Total match.

  2. On the bar at the top, select Foreign Keys to display a list of selection with foreign keys used.

    A new search result opens with this information:

    Column heading Description
    Table Name Name of the table used by your selected program.
    Description Description of the panel used by your selected program.
    Importance Rank

    Total number of programs with semantic importance relation between two tables.

    To view programs of importance rank relation, click the importance rank number.

    See Viewing programs by importance rank.
    Key Info

    An option to view foreign keys.

    To view foreign keys relation, click View Foreign Keys.

    See Viewing Foreign Key.
  3. Use these options to sort and filter your results:

    • To sort the results alphabetically or numerically, click the Sort icon located in one or more column headings.

    • To filter the results, type a dynamic free text filter for each column and select a Filter action.