: How to find the link btw ticket and dynamic_field value ?

Hi
I migrated from otrs 3.0.9 to 3.1.5.
All sounds fine, after I migrated the DB (postgres 8.4), but I didn't find
how the ticket are linked to the dynamic fields created.

This information are vital for me, because I have many automated reports
using specific sql select.

So before to migrate the production installation I have to modify any
select to output the right informations.

I just saw to the OTRSDatabaseDiagram.png, but no link relation is depicted
btw ticket and dynamic_field or dynamic_field_value tables.

I suspect, after a very brief cross analysis, that object_id column into
dynamic_field_value table contains the ticket id reference, but an
extensive check is a very  time consuming job.

So anyone can help me on this information?

best regards

-- 
 *
Stefano Boccanera*

_______________________________________________
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