Language: Deutsch · English
System tables
Reference of the Nuclos system tables – meaning and menu paths of the T_AD_/T_MD_/T_UD_ tables.
REFERENZ DEVELOPER UPDATED: JUL 2026 APPLIES TO NUCLOS 4.2026.X
Reference of the Nuclos system tables with descriptions and – where available – the corresponding menu path in the rich client or web client. Prefixes: T_AD_ (administration/configuration), T_MD_ (metadata), T_UD_ (user/transaction data), T_EO_ (entity objects/data).
As of
Documentation as of Nuclos 4.2022.26. The table structure may change between versions.
Name | Beschreibung | Menüpfad im Richclient | Menüpfad im Webclient |
|---|---|---|---|
| t_ad_action | |||
| t_ad_application | Hier finden sich alle Nuclets aus der Nuclos-Instanz. | Configuration > Nuclet | |
| t_ad_cluster_authstate | Live status of the cluster servers | Administration > Cluster servers | |
| t_ad_cluster_message | all incoming and outgoing messages of the cluster servers | Administration > Cluster servers | |
| t_ad_cluster_server | all configured cluster servers, see Cluster-Betrieb | Administration > Cluster servers | |
| t_ad_cominterface | |||
| t_ad_cominterface_param | |||
| t_ad_comport | |||
| t_ad_comport_param | |||
| t_ad_ldapmapping | Field mapping for Active Directory vs. Nuclos users | Administration > LDAP configuration | |
| t_md_ldapserver | Configuration of LDAP servers when login should run via an Active Directory. The connection to the LDAP servers can be enabled/disabled. | Administration > LDAP configuration | |
| t_ad_login_attempt | fehlgeschlagene Loginversuche mit jeweiliger IP | ||
| t_ad_module_sequentialnumber | |||
| t_ad_news | alle hinterlegten News | Administration > News | |
| t_ad_news_confirmed | alle von den Benutzern bestätigen News | Administration > News | |
| t_ad_news_viewed | alle von den Benutzern gelesenen News | Administration > News | |
| t_ad_parameter | System parameters, see Eintrag im Nuclos-Wiki | Administration > Parameter | |
| t_ad_qrtz_blob_triggers | |||
| t_ad_qrtz_calendars | |||
| t_ad_qrtz_cron_triggers | |||
| t_ad_qrtz_fired_triggers | |||
| t_ad_qrtz_job_details | |||
| t_ad_qrtz_job_listeners | |||
| t_ad_qrtz_locks | |||
| t_ad_qrtz_paused_triggers_grps | |||
| t_ad_qrtz_scheduler_state | |||
| t_ad_qrtz_simple_triggers | |||
| t_ad_qrtz_trigger_listeners | |||
| t_ad_qrtz_triggers | |||
| t_ad_release | History of the Nuclos versions installed so far on this Nuclos instance. | ||
| t_ad_sessions | Benutzersessions | ||
| t_ad_ssoauth | |||
| t_ad_ssouseridentifier | |||
| t_md_businesstest | Hinterlegte Business-Tests | </> > Business-Tests | |
| t_md_calcattribute | Berechnete Attribute als Datenquellen | Configuration > Data sources > Calculated attribute | |
| t_md_calcattributeusage | |||
| t_md_clientcode | |||
| t_md_clientcode_parameter | |||
| t_md_customcomponent | |||
| t_md_data_language | alle eingerichtete Datensprachen, see also on Internationalisierung | Administration > Datensprache | Benutzername > Datensprache |
| t_md_datatype | pre-configured and custom Datentypen for the BO-Editor | Configuration > Other > Data type | |
| t_md_dbobject | Hinterlegte Datenbankobjekte (Funktionen, Views, etc.) | Configuration > Database > Database object | |
| t_md_dbobjecttype | Database object types, see Datenbankobjekte | Configuration > Database > Database object | |
| t_md_dbsource | Stored source code for Datenbankobjekte | Configuration > Database > Database object source code | |
| t_md_dbtype | |||
| t_md_dummy | |||
| t_md_dynamicentity | alle eingerichteten Datenquellen vom Typ dynamisches Businessobjekt | Configuration > Data sources > Dynamic business object | |
| t_md_dynamicentityusage | |||
| t_md_dynamictasklist | alle eingerichten Datenquellen vom Typ dynamische Taskliste | Configuration > Data sources > Dynamic task list | |
| t_md_dynamictasklist_usage | |||
| t_md_entity | all via the BO-Editor angelegten Businessobjekte | Configuration > Business object | |
| t_md_entity_field | all attributes of the ones defined via the BO-Editor angelegten Businessobjekte | Configuration > Business object | |
| t_md_entity_field_custom | |||
| t_md_entity_field_group | alle hinterlegten Attributgruppen | Configuration > Other > Attribute group | |
| t_md_entity_generic_fieldmap | Feldzuordnungen von generischen Implementierungen | Configuration > Rule sets > Generic implementation | |
| t_md_entity_generic_impl | alle eingerichteten generischen Implementierungen | Configuration > Rule sets > Generic implementation | |
| t_md_entity_laf_parameter | alle eingerichteten Look & Feel Parameter | ||
| t_md_entity_menu | action-specific menu entries (see step 5, "Define context and actions" in the BO-Editor) | Configuration > Business object | |
| t_md_entity_subnodes | Baumkonfiguration for reference fields in the BO-Editor | ||
| t_md_entitycontext | |||
| t_md_entity_relation | |||
| t_md_generation | alle hinterlegten Objektgeneratoren | Configuration > Object generator | |
| t_md_generation_attribute | Attributzuordnung in Objektgeneratoren ("Zu übernehmende Attribute") | Configuration > Object generator | |
| t_md_generation_subentity | BO-Zuordnung in Objektgeneratoren ("Zu übernehmende Unterformulare") | Configuration > Object generator | |
| t_md_generation_subentrity_attr | Attributzuordnung je BO-Zuordnung in Objektgeneratoren ("Zu übernehmende Unterformulare") | Configuration > Object generator | |
| t_md_generation_usage | die Verwendungen der hinterlegten Objektgeneratoren | Configuration > Object generator | |
| t_md_import | Strukturdefinitionen for the CSV import | Configuration > Import & Export > Structure definition | |
| t_md_importattribute | Attributzuordnung je Strukturdefinition | Configuration > Import & Export > Structure definition | |
| t_md_importexport | |||
| t_md_importexport_messages | |||
| t_md_importfeidentifier | Identifier for referenced records in a Strukturdefinition | Configuration > Import & Export > Structure definition | |
| t_md_importfile | alle als Objektimport hinterlegten CSV-Importe | Configuration > Import & Export > Object import | |
| t_md_importidentifier | Datensatzidentifizierer je Strukturdefinition bzw. XML structure definition | Configuration > Import & Export > Structure definition Configuration > Import & Export > XML structure definition | |
| t_md_importusage | |||
| t_md_jobcontroller | Hier finden sich die Einträge aus der Jobsteuerung. | Administration > Jobsteuerung | |
| t_md_jobcontroller_param_value | mandantenspezifische Nuclet-Parameter in der Jobsteuerung | Administration > Jobsteuerung | |
| t_md_jobdbobject | for a job of the Jobsteuerung hinterlegte DB-Prozeduren/-Funktionen | Administration > Jobsteuerung | |
| t_md_jobmandator | Mandantenzuordnung in Jobsteuerung | Administration > Jobsteuerung | |
| t_md_jobnotification | |||
| t_md_jobqueue | alle eingerichteten Job queues | Administration > Job queue | |
| t_md_jobrun | all executed job runs (left side in "Log Info" in Job control) | Administration > Jobsteuerung | |
| t_md_jobrun_messages | the log messages from the executed job runs ("Log Info" in Job control, right side) | Administration > Jobsteuerung | |
| t_md_layout | alle hinterlegten Layouts | Configuration > Layout | |
| t_md_layoutusage | Layoutverwendungen je Layouts | Configuration > Layout | |
| t_md_locale | |||
| t_md_localeresource | Menu entries, labels, etc. per application language, see Sprachen/Internationalisierung | ||
| t_md_mandator | all configured mandators, see Mandantenwesen | Administration > Mandant | Benutzername > Mandant |
| t_md_mandator_accessible | |||
| t_md_mandator_level | Hierarchy between mandators in the Mandantenwesen | Administration > Mandant | |
| t_md_mandator_param_value | mandator-specific Nuclet parameters, see Mandantenwesen | Administration > Mandant | |
| t_md_mandator_resource | mandator-specific resources, see Mandantenwesen | Administration > Mandant | |
| t_md_mandator_role_user | Mandantenzuordnung je Benutzergruppe | Administration > Benutzergruppe | |
| t_md_mandator_user | Mandator assignment per user | Administration > Users | |
| t_md_nuclet_integrfield | Attributzuordnungen in den Integrationspunkten | Configuration > Integration point | |
| t_md_nuclet_integrpoint | alle eingerichteten Integrationspunkte | Configuration > Integration point | |
| t_md_nuclet_integrproblem | Errors and problems in the Integrationspunkten | Configuration > Integration point | |
| t_md_nuclet_dependence | Hierarchy between the stored Nuclets, see Nuclet-Management | Configuration > Nuclet | |
| t_md_nuclet_extension | third-party Java libraries included as Nuclet extensions, see Nuclet-Management | Configuration > Nuclet | |
| t_md_nucletimport | History of all Nuclet imports in this Nuclos instance | Configuration > Nuclet | |
| t_md_nucletimport_file | History of all imported Nuclets in this Nuclos instance | Configuration > Nuclet | |
| t_md_nucletparameter | Nuclet parameters per Nuclet, see Nuclet-Management | Configuration > Nuclet | |
| t_md_nucletreleasenote | Release notes per Nuclet version, see Nuclet-Management | Configuration > Nuclet | |
| t_md_passwordhistory | Password history per Nuclos user | ||
| t_md_preference | Column settings per BO, subform and user-defined web-client search filters | Benutzername > Manage settings | |
| t_md_preference_selected | |||
| t_md_process | alle hinterlegten Nuclos-Aktionen | Configuration > Other > Action | |
| t_md_recordgrant | alle eingerichteten Datensatzfreigaben | ||
| t_md_recordgrantusage | Configuration > Data sources > Record sharing | ||
| t_md_relationtype | Beziehungsarten | Configuration > Other > Relationship type | |
| t_md_resource | als Ressourcen hinterlegte Bilddateien, etc. | Configuration > Other > Resource | |
| t_md_role | alle eingerichteten Benutzergruppen | Administration > Benutzergruppe | |
| t_md_role_action | allgemeine Berechtigungen je Benutzergruppe (Tabreiter "Berechtigungen") | Administration > Benutzergruppe | |
| t_md_role_attributgroup | Berechtigungen je Attributgruppe in Statusmodellen | Configuration > State model | |
| t_md_role_generation | Berechtigungen zur Ausführung von Objektgeneratoren | Administration > Benutzergruppe | |
| t_md_role_masterdata | Berechtigungen auf Businessobjekten *ohne* Statusmodell (Tabreiter "Stammdatenrechte") | Administration > Benutzergruppe | |
| t_md_role_module | Berechtigungen auf Businessobjekten mit Statusmodell (Tabreiter "Modulrechte") | Administration > Benutzergruppe | |
| t_md_role_preference | Permissions on column settings and search filters (tab "Settings") | Administration > Benutzergruppe | |
| t_md_role_recordgrant | Zuordung von Datensatzfreigaben (Tabreiter "Datensatzfreigaben") | Administration > Benutzergruppe | |
| t_md_role_report | Permission to run reports and forms (tab "Reports") | Administration > Benutzergruppe | |
| t_md_role_servercode | Permissions on server rules, i.e. REST rules (tab "REST rules") | Administration > Benutzergruppe | |
| t_md_role_subform | Berechtigungen je Unterformular in Statusmodellen | Configuration > State model | |
| t_md_role_subformgroup | Permissions per attribute group for subforms in Statusmodellen | Configuration > State model | |
| t_md_role_transition | Permissions on state transitions, see Statusmodelle | Configuration > State model | |
| t_md_role_user | User-group assignment per user | Administration > Users Administration > Benutzergruppe | |
| t_md_role_workspace | Zuordnung von Arbeitsumgebungen (Tabreiter "Arbeitsumgebungen") | Administration > Benutzergruppe | |
| t_md_servercode | all stored server rules | Configuration > Rule sets > Rules (server-side) | |
| t_md_servercode_comport | Server-rule assignments to connectors ("<System> > Connector") | Configuration > Server rule manager | |
| t_md_servercode_entity | Server-rule assignment per business object, see Server rule manager | Configuration > Server rule manager | |
| t_md_servercode_generation | Server-rule assignment per object generator, see Objektgeneratoren and Server rule manager | Configuration > Object generator Configuration > Server rule manager | |
| t_md_servercode_job | Server-rule assignment per background job, see Jobsteuerung and Server rule manager | Administration > Jobsteuerung Configuration > Server rule manager | |
| t_md_servercode_transition | Server-rule assignment per state transition, see Statusmodelle | Configuration > Server rule manager Configuration > State model | |
| t_md_state | alle Status der hinterlegten Statusmodelle | Configuration > State model | |
| t_md_state_mandatorycolumn | |||
| t_md_state_mandatoryfield | Definition of the status-dependent mandatory fields, see Statusmodelle | Configuration > State model | |
| t_md_state_transition | die Statusübergänge bzw. wechsel in den Statusmodellen | Configuration > State model | |
| t_md_statemodel | alle konfigurierten Statusmodelle | Configuration > State model | |
| t_md_tasklist | alle auf dynamischen Tasklisten basierenden Aufgabenlisten | Administration > Aufgabenlisten | |
| t_md_tasklist_role | User-group assignment for the Aufgabenlisten | Administration > Aufgabenlisten | |
| t_md_user | die Users this Nuclos instance | Administration > Users | Rädchen > Users |
| t_md_user_comaccount | |||
| t_md_user_setting | |||
| t_md_valuelistprovider | die Datenquellen aller hinterlegten Valuelist-Provider | Configuration > Data sources > Value list provider | |
| t_md_webaddon | alle hinterlegten Web-Addons | Configuration > Web add-on | Schraubenschlüssel > Webbadon |
| t_md_webaddon_file | die Dateien der hinterlegten Web-Addons | Configuration > Web add-on | |
| t_md_webaddon_property | die Eigenschaften der hinterlegten Web-Addons | Configuration > Web add-on | |
| t_md_webaddon_resultlist | die Ergebnislisten der hinterlegten Web-Addons | Configuration > Web add-on | |
| t_md_webservice | alle hinterlegten Webservices | Administration > Webservice | |
| t_md_workspace | alle eingerichteten Workspaces bzw. Arbeitsumgebungen | ||
| t_md_xmlimport | Strukturdefinitionen for the XML import | Configuration > Import & Export > XML structure definition | |
| t_md_xmlimportattribute | Attributzuordnung je XML-Strukturdefinition | ||
| t_md_xmlimportfeidentifier | Identifier for referenced records in a XML-Strukturdefinition | ||
| t_md_xmlimportfile | alle als Objektimport hinterlegten XML-Importe | Configuration > Import & Export > XML file import | |
| t_ud_chart | all for Diagramme hinterlegten Datenquellen | Configuration > Data sources > Chart | |
| t_ud_chartusage | |||
| t_ud_datasource | all general ones and those stored for Jasper reporting (reports & forms) Datenquellen | Configuration > Data sources > Report & form | |
| t_ud_datasourceusage | |||
| t_ud_documentfile | All document and file attachments are stored here. | ||
| t_ud_documentfile_link | Junction table between business object and file attachment. | ||
| t_ud_entityobject_relation | |||
| t_ud_genericobject | Zuordnung von Datensätzen aus BOs mit Statusmodell zu ihrem Businessobjekt | ||
| t_ud_go_comment | generische Kommentare zum Einbinden in Unterformulare (BO-übergreifend) | ||
| t_ud_go_document | generische Dokumentenanhänge zum Einbinden in Unterformulare (BO-übergreifend) | ||
| t_ud_go_relation | Vorgänger-/Nachfolger-Beziehungen; resultierend aus Objektgeneratoren ("Zielobjekt mit Quellobjekt verknüpfen"). Can also be set manually. | ||
| t_ud_go_statehistory | State history per record for all business objects with a state model, see Detailmaske or Detailmasken-Detail | ||
| t_ud_history | Here the historized data is stored (for all BOs for which historization is enabled). Die Aktivierung erfolgt im BO-Editor in step 2 "General properties" and at attribute level. | ||
| t_ud_lock | Durch die Locking logic gesperrte Datensätze mit Owner | ||
| t_ud_logbook | |||
| t_ud_printservice | alle eingerichteten Druckdienste | Administration > Druckdienst | |
| t_ud_printservice_tray | alle Einträge aus "Schächte" in den eingerichteten Druckdiensten | Administration > Druckdienst | |
| t_ud_report | Hier finden sich alle definierten Reports and forms, see also under Reporting. | Configuration > Report > Form Configuration > Report > Report | |
| t_ud_reportgroup | alle hinterlegten Reportgruppen zur Gruppierung von Reports | Configuration > Other > Report group | |
| t_ud_reportoutput | all print profiles of reports and forms, see Reports and c | Configuration > Report > Form Configuration > Report > Report | |
| t_ud_reportusage | the defined usages of the stored reports and forms, see Reports and Reporting | Configuration > Report > Form Configuration > Report > Report | |
| t_ud_searchfilter | Here all defined via the rich client Suchfilter stored (see also Create a search filter and Suchfilter in Aufgabenliste) | ||
| t_ud_searchfilter_role | User-group assignment for Suchfilter | Administration > Suchfilter | |
| t_ud_searchfilter_user | User assignment for Suchfilter | Administration > Suchfilter | |
| t_ud_subreport | alle in den reports and forms defined subreports, see also Report | Configuration > Report > Form Configuration > Report > Report | |
| t_ud_timelimittask |
Related pages
Überblick
Inhalte