where to find table for custom field in a custom module?

I created a custom field inside a custom module, The custom field is working as expected and changes were made to its value when I edit it inside the edit part of the module for testing. But what I want to do is to update the value of the custom field using a custom SQL code. I was able to identify the table name for the module but when I checked the fields inside it the custom field I created was nowhere to be found. So I would like to know where exactly is my custom field holding the values saved in it, if not inside the module table. Also, I was able to change the values inside the module table using my custom SQL code but I just can't find where my custom field is placed in the database.

Thank you