Information about Database Structure (Database Dictionary or Schema)

Version 9

    Verified Product Versions

    Service Desk 7.6Service Desk 7.7.xService Desk 7.8.xService Desk 2016.xAsset Manager 2016.xService Desk 2017.x

    Question

    Need to know the database structure via dictionary or schema diagrams.

    Answer

    Attached are some of the most useful parts of the database shown diagramatically with full descriptions.

    Environment

    Service Desk

     

    Additional

    You may also find these documents useful:

    Advice on writing Crystal reports against a Service Desk database

    How to find database table and columns names for your Service Desk data

    List of modules / table prefixes