DT420 DB schema

Caution

• If system customizing changes are made to data tables or data items (e.g. new data items are created, data item parameters are changed), the Tools → Restart PLANTA service menu item must be executed in order to make the changes visible.
  • Note: If you click on the menu item, all open client connections (sessions) are closed. During restart, new client connections are not possible. This does not apply to changes made to I-texts, e.g. changes to the DI name or adjustment of value ranges (also of the VR type).
  • Before restarting the service, the target directory must be deleted so it can be created anew upon server restart in order to make sure that the POJO classes contained in it, which are responsible for the meta data of the data dictionary, are generated anew.

DI000289 DB schema

ID of the database schema

Details

• Q1B: System
• Q2B: Customizer
• Q3B: Persons
• Q4B: Commercial functions
• Q5B: Project + portfolio management
• Q6B: Request management
• Q7B: Content management
• K[License number]: Customer schema for individual data tables
• For each schema, there may be views that belong to it thematically. However, these views must be created in their own schema with a corresponding name (e.g. Customizer Views in !Q2V).

DI001568 Name

Name of the database schema

DI060096 Activated

Defines whether a schema is (de)activated. If a schema is deactivated, all data tables or DIs contained in it are automatically deactivated. Schemas that are to be deleted can be deactivated in a first step, e.g., for test purposes, and finally be deleted in a second step.

Values

• : The schema is activated.
• : The schema is deactivated. This means, that the schema does not exist in the Data Dictionary of the server. The following applies to all DIs of all data tables of a deactivated schema:
  • If a deactivated DI is used in a module, it will still be displayed in the customizing.
    • If a module is started with a deactivated DI, the behavior will differ according to the DI.
      • If it is a real DI ( virtual = ), the IE: FATAL ERROR: get_dip: DI 123456 not found error message will be displayed.
      • If it is a virtual DI ( virtual = ), the DI will not be loaded, i.e. it will not be displayed.

Note

• If a schema is deactivated (DI060096 Activated = ), all data tables contained in it and the data items contained in the data tables are automatically deactivated (DI060097 Activated = and DI060111 Activated = ), i.e. the setting of the schema overwrites the setting of the data table and the data items.
• As soon as the value is changed and saved in one of the three parameters mentioned (DI060111, DI060096, or DI060097), a script is created in the work directory and a message is displayed at the same time: Due to your changes to DT412, your database must be adjusted. Please select the appropriate ./22*.sql file (depending on the database system) and run the content on your database.
  • The message will only be displayed once in a session, i.e. only upon the first change made to DI060111 or DI060097 or DI060096.
  • After making changes to DI060111, DI060096, or DI060097, the System Customizing must be updated (e.g. via the respective menu item in the Tools menu).

DI060099 Generated

Defines whether the file for schema update is to be generated or not for this schema if changes are made that require a Schema Update.

Values

• : When saving changes that require a schema update, the respective file is generated for the update.
• : When saving changes that require a schema update, no file is generated for the update.

Note

• The same applies to the following Python functions for generating the respective SQL commands:
  • db_schema_create
  • db_custom_schema_create
  • db_custom_lines_create

DI061431 Consistency check

Mode of the database consistency check

Values

• 1: Check I-texts
• 2: Check and write I-texts
• 3: Check hyperlinks
• 4: Check and write hyperlinks
• 5: Check I-texts and hyperlinks
• 6: Check and write I-texts and hyperlinks
• 7: Check relations
• 8: Check object protection
• 9: Check dash records
• 10: Check and write dash records
• 11: Check everything (I-texts, hyperlinks, relation, object protection)

Note

• For a detailed description of the different modi, click here.

DI001554 INR: I-No.

In this parameter, the ID of the I-No. DI from the I-No. xxx data table (xxx = schema) of the respective schema is stored.

DI001642 INR: I-text initial.

In this parameter, the ID of the I-text initial. DI from the I-No. xxx data table (xxx = schema) of the respective schema is stored.

DI001555 ITXT: I-text

In this parameter, the ID of the I-text DI from the I-No. xxx data table (xxx = schema) of the respective schema is stored.

DI023499 ITXT: data table

In this parameter, the ID of the Data table DI from the I-No. xxx data table (xxx = schema) of the respective schema is stored.

DI023500 ITXT: data item

In this parameter, the ID of the Data item DI from the I-text xxx data table (xxx = schema) of the respective schema is stored.

DI023501 ITXT: Record ID

In this parameter, the ID of the Record ID DI from the I-text xxx data table (xxx = schema) of the respective schema is stored.

DI008149 ZÄHLER: DI

In this parameter, the ID of the DI DI from the Counter xxx data table (xxx = schema) of the respective schema is stored.

DI008075 HLINK: hyperlink

In this parameter, the ID of the Hyperlink DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI040983 HLINK: Item*

In this parameter, the ID of the Pos DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI040994 HLINK: data item

In this parameter, the ID of the Data item DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI024537 HLINK: flag

In this parameter, the ID of the Flag DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI040981 HLINK: text

In this parameter, the ID of the Text DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI040973 HLINK: storage modif. on

In this parameter, the ID of the Storage: modif. on DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI040974 HLINK: Size

In this parameter, the ID of the Size DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI040970 HLINK: storage

In this parameter, the ID of the Storage DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI040975 HLINK: created on

In this parameter, the ID of the Created at DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI040976 HLINK: modified at

In this parameter, the ID of the Modified on DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI040982 HLINK: URL

In this parameter, the ID of the URL DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI059198 HLINK: CRC

In this parameter, the ID of the CRC DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI001911 Owner license

In this parameter, the ID of the Owner license DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.

DI001908 rwdu

In this parameter, the ID of the rwdu DI from the Hyperlink xxx data table (xxx = schema) of the respective schema is stored.