| usrnotset_id | int(11) | NO | | PRI | auto_increment | |
| usrnotset_usr_id | int(11) | NO | | MUL | | |
| usrnotset_cus_id | int(11) | YES | | MUL | | Notification subscription customer filter |
| usrnotset_cli_id | int(11) | YES | | MUL | | Notification subscription client filter |
| usrnotset_loc_id | int(11) | YES | | | | Notification subscription location filter |
| usrnotset_notcon_id | int(11) | NO | | MUL | | Notification concept group of subscription |
| usrnotset_nottyp_id | int(11) | NO | | MUL | | Notification type - eg: Email or Push Notification |
| usrnotset_disabled | tinyint(1) | NO | 0 | | | 1 indicates user has unsubscribed from this notification |
| usrnotset_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| usrnotset_created | timestamp | YES | CURRENT_TIMESTAMP | | | |