Hi,

On your OTRS installation, the 'doc' folder contains a .png image of the database ERD and also it contains the base .mwb file for use in MySQL Workbench.
You can also see the image of the ERD here:
http://source.otrs.org/viewvc.cgi/otrs/doc/OTRSDatabaseDiagram.png?revision=1.2&view=co

Hope this helps!

--
Mike

On Wed, Jun 20, 2012 at 2:55 AM, Soporte Informatica PGJE <ddmi@pgje.michoacan.gob.mx> wrote:
Where is the flow lines? U_u
https://dl.dropbox.com/u/6443236/otrs/otrs%20design.png

This is a screenshoot from Mysql workbench, model section.

=====
De: dev-bounces@otrs.org [mailto:dev-bounces@otrs.org] En nombre de Soporte
Informatica PGJE
Enviado el: viernes, 15 de junio de 2012 08:42 p.m.
Para: dev@otrs.org
Asunto: [dev] hierarchy of tickets

Hi everyone,

OTRS: 3.1.2
Problem: I need to classify tickets using a hierarchical tree and have
statistics on the number of tickets in each level tree.

PROPOSED SOLUTION:
1. I have a very functional implementation with multi ID for customers,  the
problem here is that  the stat module only find specific IDS, but does not
search the customers_ids  field. in this context as I can show the tickets
assigned to an ID and tickets hierarchically below the?

2. I have dynamic fields of each hierarchical level, I want to create a
relationship herarquical including Choosing a level and sublevel only in its
child nodes are displayed. I can create this relationship as?

Where i can ER diagram of Database otrs? Can I to use mysql workbench for
this?

regards
--
Martin Edmundo

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev