Redmine

Hello,

Can anyone explain to me how does the issues relates with the custom fields in the database?
I now that redmine allow us to create custom_fields and when we search the issues we can filter by those fields.
What I want is to do the same but directly in the sql because it is to create some reports.

Thank you