We are using clarity version 7.5.3. I just need to know if there is any table in database which contains resource's notification status. I mean if a resources EMAIL notification is tick or not.
CLB_NOTIFICATION_PREFS - search on here for that table and you will find some info.
Please refer to the image below as it shows all the Tables related to Notifications. May be your do some further research to get the exact data, as per your requirement. Hope this helps.
Have a great day ahead.
Here is an older thread from 2012 with some extra information.
Disable email notification if a user is added to a project
Retrieving data ...