Managing Table Supplementary Information

Table supplementary information refers to supplementary information (descriptions, data examples, etc.) registered for tables and columns.

By registering table supplementary information, the Data Aggregation Agent AI can more accurately understand the table structure and perform appropriate data aggregation.

See also

In the table supplementary information management screen, the display and operations of tables are controlled based on the table’s own permissions.

For information about table permissions, please refer to Setting Table Permissions.

Tips for Registering Table Supplementary Information

The quality of table supplementary information directly affects the AI’s query accuracy.

Please register only the necessary information for tables you will use in AI queries. Registering unnecessary information may actually decrease query accuracy.

For both tables and columns, descriptions can be omitted when the content is self-evident.

• Register descriptions for tables whose purpose is unclear from the table name alone

  If the purpose is unclear from the table name alone, such as "t001" or "mst_x", please register a description. It is effective to describe an overview of the data stored in the table and what business operations it is used for.

• Register descriptions for columns whose meaning is unclear from the column name alone

  Like tables, please register a description if the meaning is unclear from the column name alone, such as "Flag1" or "codea".

• Register data examples

  By registering examples of actual data stored, the AI can correctly understand the data format (date format, code system, etc.).

Table Supplementary Information Management Screen

The table supplementary information management screen can be opened from the Generative AI settings screen.

This screen displays a list of tables in the CELF database, and you can register and edit supplementary information for each table.

[1] Table list

Displays a list of tables that the user has read permission for.

Tables with registered supplementary information are highlighted.

You can also filter the list to show only tables with supplementary information by selecting the checkbox.

[2] Table supplementary information

You can view the supplementary information (table description and column information) of the table selected in the table list.

[3] Edit button

Opens the supplementary information edit dialog for the selected table.

Edit permission for the table is required.

[4] Delete button

Deletes the supplementary information registered for the selected table.

Admin permission for the table is required.

Editing Table Supplementary Information

1. Select the table you want to edit in the table supplementary information management screen.

2. Click the 'Edit' button.

   The supplementary information edit dialog is displayed.
   

3. Enter the table description.

   [1] Table name

   The name of the table being edited is displayed. (Cannot be changed.)

   [2] Table description

   Enter a description of the table’s content and purpose.

   This is referenced by the AI when understanding the meaning of the table.

   Example: "A table that manages customer order history. Records order date, product, quantity, and amount."

4. Enter column supplementary information.

   Click the 'Select columns' button to display the column selection dialog.

   Select the columns for which you want to register supplementary information.
   For each selected column, you can enter the following information.

   [3] Column name

   The column name is displayed. (Cannot be changed.)

   [4] Column description

   Enter a description of the column’s content and meaning.

   Can be omitted if the meaning is clear from the column name (e.g., "Order Date", "Product Name").

   Example: "Product category name (major category)" "Contains ID values from the order table"

   [5] Data examples

   Enter examples of data stored in the column.

   This is referenced by the AI when understanding the data format and content.

   Example: "0: Not ordered, 1: Ordered" "Electronics, Food, Clothing"

   [6] Unit / Format

   Enter the unit or format of the column data.

   This is referenced by the AI when understanding the data representation format.

   Example: "JPY" "kg" "yyyy-MM-dd"

5. Click the 'Save' button.

   The entered supplementary information is saved.