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 | Menu path in the rich client | Menu path in the web client |
|---|---|---|---|
| t_ad_action | |||
| t_ad_application | Here you find all Nuclets from the Nuclos instance. | 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 | failed login attempts with the respective IP | ||
| t_ad_module_sequentialnumber | |||
| t_ad_news | all stored News | Administration > News | |
| t_ad_news_confirmed | all confirmed by the users News | Administration > News | |
| t_ad_news_viewed | all read by the users News | Administration > News | |
| t_ad_parameter | System parameters, see entry in the 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 | Calculated attributes as data sources | Configuration > Data sources > Calculated attribute | |
| t_md_calcattributeusage | |||
| t_md_clientcode | |||
| t_md_clientcode_parameter | |||
| t_md_customcomponent | |||
| t_md_data_language | all configured 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 | all configured data sources of type dynamisches Businessobjekt | Configuration > Data sources > Dynamic business object | |
| t_md_dynamicentityusage | |||
| t_md_dynamictasklist | all configured data sources of type 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 | all stored Attributgruppen | Configuration > Other > Attribute group | |
| t_md_entity_generic_fieldmap | Field assignments of generischen Implementierungen | Configuration > Rule sets > Generic implementation | |
| t_md_entity_generic_impl | all configured generischen Implementierungen | Configuration > Rule sets > Generic implementation | |
| t_md_entity_laf_parameter | all configured 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 | all stored Objektgeneratoren | Configuration > Object generator | |
| t_md_generation_attribute | Attribute assignment in Objektgeneratoren ("Attributes to adopt") | Configuration > Object generator | |
| t_md_generation_subentity | BO assignment in Objektgeneratoren ("Subforms to adopt") | Configuration > Object generator | |
| t_md_generation_subentrity_attr | Attribute assignment per BO assignment in Objektgeneratoren ("Subforms to adopt") | Configuration > Object generator | |
| t_md_generation_usage | the usages of the stored Objektgeneratoren | Configuration > Object generator | |
| t_md_import | Structure definitionen for the CSV import | Configuration > Import & Export > Structure definition | |
| t_md_importattribute | Attribute assignment per Structure definition | Configuration > Import & Export > Structure definition | |
| t_md_importexport | |||
| t_md_importexport_messages | |||
| t_md_importfeidentifier | Identifier for referenced records in a Structure definition | Configuration > Import & Export > Structure definition | |
| t_md_importfile | all as Object import stored CSV imports | Configuration > Import & Export > Object import | |
| t_md_importidentifier | Record identifier per Structure definition resp. XML structure definition | Configuration > Import & Export > Structure definition Configuration > Import & Export > XML structure definition | |
| t_md_importusage | |||
| t_md_jobcontroller | Here you find the entries from the Jobsteuerung. | Administration > Jobsteuerung | |
| t_md_jobcontroller_param_value | mandator-specific Nuclet parameters in the Jobsteuerung | Administration > Jobsteuerung | |
| t_md_jobdbobject | for a job of the Jobsteuerung stored DB procedures/functions | Administration > Jobsteuerung | |
| t_md_jobmandator | Mandator assignment in Jobsteuerung | Administration > Jobsteuerung | |
| t_md_jobnotification | |||
| t_md_jobqueue | all configured 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 | all stored Layouts | Configuration > Layout | |
| t_md_layoutusage | Layout usages per 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 > Mandator | Benutzername > Mandator |
| t_md_mandator_accessible | |||
| t_md_mandator_level | Hierarchy between mandators in the Mandantenwesen | Administration > Mandator | |
| t_md_mandator_param_value | mandator-specific Nuclet parameters, see Mandantenwesen | Administration > Mandator | |
| t_md_mandator_resource | mandator-specific resources, see Mandantenwesen | Administration > Mandator | |
| t_md_mandator_role_user | Mandator assignment per user group | Administration > Benutzergruppe | |
| t_md_mandator_user | Mandator assignment per user | Administration > Users | |
| t_md_nuclet_integrfield | Attribute assignments in the Integrationspunkten | Configuration > Integration point | |
| t_md_nuclet_integrpoint | all configured 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 | all stored Nuclos-Aktionen | Configuration > Other > Action | |
| t_md_recordgrant | all configured Datensatzfreigaben | ||
| t_md_recordgrantusage | Configuration > Data sources > Record sharing | ||
| t_md_relationtype | Beziehungsarten | Configuration > Other > Relationship type | |
| t_md_resource | als Ressourcen stored image files, etc. | Configuration > Other > Resource | |
| t_md_role | all configured Benutzergruppen | Administration > Benutzergruppe | |
| t_md_role_action | general permissions per user group (tab "Permissions") | Administration > Benutzergruppe | |
| t_md_role_attributgroup | Permissions per attribute group in Statusmodellen | Configuration > State model | |
| t_md_role_generation | Permissions to run object generators | Administration > Benutzergruppe | |
| t_md_role_masterdata | Permissions on business objects *without* a state model (tab "Master data rights") | Administration > Benutzergruppe | |
| t_md_role_module | Permissions on business objects with Statusmodell (Tabreiter "Modulrechte") | Administration > Benutzergruppe | |
| t_md_role_preference | Permissions on column settings and search filters (tab "Settings") | Administration > Benutzergruppe | |
| t_md_role_recordgrant | Assignment of record shares (tab "Record shares") | 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 | Permissions per subform 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 | Assignment of workspaces (tab "Workspaces") | 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 | all statuses of the stored 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 | the state transitions or changes in the Statusmodellen | Configuration > State model | |
| t_md_statemodel | all configured Statusmodelle | Configuration > State model | |
| t_md_tasklist | all on dynamischen Tasklisten basierenden Aufgabenlisten | Administration > Aufgabenlisten | |
| t_md_tasklist_role | User-group assignment for the Aufgabenlisten | Administration > Aufgabenlisten | |
| t_md_user | the Users this Nuclos instance | Administration > Users | cogwheel > Users |
| t_md_user_comaccount | |||
| t_md_user_setting | |||
| t_md_valuelistprovider | the data sources of all stored Valuelist-Provider | Configuration > Data sources > Value list provider | |
| t_md_webaddon | all stored Web-Addons | Configuration > Web add-on | wrench > Webbadon |
| t_md_webaddon_file | the files of the stored Web-Addons | Configuration > Web add-on | |
| t_md_webaddon_property | the properties of the stored Web-Addons | Configuration > Web add-on | |
| t_md_webaddon_resultlist | the result lists of the stored Web-Addons | Configuration > Web add-on | |
| t_md_webservice | all stored Webservices | Administration > Webservice | |
| t_md_workspace | all configured workspaces or Workspaces | ||
| t_md_xmlimport | Structure definitionen for the XML import | Configuration > Import & Export > XML structure definition | |
| t_md_xmlimportattribute | Attribute assignment per XML-Structure definition | ||
| t_md_xmlimportfeidentifier | Identifier for referenced records in a XML-Structure definition | ||
| t_md_xmlimportfile | all as Object import stored XML imports | Configuration > Import & Export > XML file import | |
| t_ud_chart | all for Diagramme stored Data sources | Configuration > Data sources > Chart | |
| t_ud_chartusage | |||
| t_ud_datasource | all general ones and those stored for Jasper reporting (reports & forms) Data sources | 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 | Assignment of records from BOs with a state model to their business object | ||
| t_ud_go_comment | generic comments for embedding in subforms (across BOs) | ||
| t_ud_go_document | generic document attachments for embedding in subforms (across BOs) | ||
| t_ud_go_relation | Predecessor/successor relationships resulting from object generators ("Link target object with source object"). 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). Activation takes place in the BO-Editor in step 2 "General properties" and at attribute level. | ||
| t_ud_lock | Through the Locking logic locked records with owner | ||
| t_ud_logbook | |||
| t_ud_printservice | all configured Druckdienste | Administration > Druckdienst | |
| t_ud_printservice_tray | all entries from "Slots" in the configured Druckdiensten | Administration > Druckdienst | |
| t_ud_report | Here you find all defined Reports and forms, see also under Reporting. | Configuration > Report > Form Configuration > Report > Report | |
| t_ud_reportgroup | all stored report groups for grouping 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 Search filters in task list) | ||
| t_ud_searchfilter_role | User-group assignment for Suchfilter | Administration > Suchfilter | |
| t_ud_searchfilter_user | User assignment for Suchfilter | Administration > Suchfilter | |
| t_ud_subreport | all in the reports and forms defined subreports, see also Report | Configuration > Report > Form Configuration > Report > Report | |
| t_ud_timelimittask |
Related pages
Überblick
Inhalte