Open ITSM Hub
Deutsch

ERSchema

Free

Adds a visualization of the database schema as an Entity-Relationship (ER) diagram directly within the administrative interface.

This package provides administrators with a visual representation of the underlying database structure. It generates Entity-Relationship diagrams (ERD) based on the current system schema, helping developers and administrators understand table relationships, foreign keys, and data flow. It requires external Perl modules like GraphViz, SQL::Translator, Config::General, and Math::Bezier to render the diagrams. The module is particularly useful for developers writing extensions or optimizing complex SQL queries.

Features

  • ER Diagram Generation

    Automatically generates visual diagrams of the database tables and their relationships based on the current schema.

  • Admin Integration

    The tool is seamlessly integrated into the administrative interface, allowing quick access to the database structure.

  • Relationship Mapping

    Uses SQL::Translator and GraphViz to create precise and readable diagrams of table links.

Categories

DatabaseER-DiagramSchemaVisualizationAdminDeveloper ToolAdministrationDesign & Visual

Related packages

AdminTemplateCopy

Adds a "copy" link to the template management in the admin area.

ZnunyOTRS Community Edition
Free

CLARIN-D Helpdesk OTRS Extension

by Hamburger Zentrum für Sprachkorpora (HZSK)

A collection of custom OTRS modules, configurations, and scripts for the CLARIN-D helpdesk, featuring a SOAP API, a PHP form, and R statistics.

OTRS Community EditionZnuny
Free

ImportExport

by Znuny GmbH

A generic framework for importing and exporting objects such as tickets or configuration items in formats like CSV or XML.

ZnunyOTRS Community Edition
Free