DT420 DB schema

Caution

If system customizing changes are made to data tables or data items (e.g. new data items created, data item parameters changed), the menu item Tools → Restart PLANTA service must be executed to make the changes visible.
- Note: If you click on the menu item, all open client connections (sessions) are closed. New client connections are not possible during restart. Changes to I-texts, e.g. changes to the DI designation or adjustments to value ranges (including the VR type), present an exception.
- Before restarting the service, the target directory must be deleted so that it can be created again when the service is restarted to ensure that the POJO classes it contains, which are responsible for the metadata 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 contained in it or the DIs contained in the data tables are automatically deactivated. Schemas which are to be deleted can be deactivated in a first step, e.g. for testing purposes, and then be deleted permanently 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. For all Dis of all data tables of a deactivated schema, the following applies:
- If a deactivated DI is used in a module, it is still displayed in Customizing.
  - If a module is started with a deactivated DI, the behavior differs depending on the DI:
    - If it is a real DI ( Virtual = ), the IE: FATAL ERROR: get_dip: DI 123456 not found error message is displayed.
    - If it is a virtual DI ( Virtual = ), the DI is not loaded, i.e. it is not displayed.

Notes

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 in one of the three parameters mentioned (DI060111, DI060096 or DI060097) is changed and saved, a script is created in the working directory and a message is output 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 is only displayed once in the same session, i.e. only when the DI060111 or DI060097 or DI060096 is changed for the first time.
- After changes to DI060111, DI060096 or DI060097, the system customizing must be updated (e.g. via the corresponding 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 which require a schema update, the corresponding file will be generated for it.
: When saving changes which require a schema update, no file will be generated.

Note

The same applies to the following Python functions for generating the respective SQL commands:

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 initially

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: Pos.

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. date

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.