Where is dynamic field data stored for each ticket?

[RagnaXBL]

Good Day, i'd like to find where dynamic field data is stored for each individual ticket. i need this for reporting purposes.
looking at the otrs database schema i can see a table for dynamic_field and dynamic_field value but which of these actually links the information to each specific ticket. i don't see any dynamic field info stored in the ticket table either.

any idea where this information is stored?

Thanks

[RagnaXBL]

ok i found the information in the table called "dynamic_field_value" and is using the object ID colum to link the info to each ticket.

in case anyone else is looking for this info