How Design Handle Notification with diffrent notification

Hello guys, well i have been building cms which has 2 type notification.

1. Notification for each users based on id_user in table
2. Notification for all users

for more design is here
http://prntscr.com/9wn5pq

as you can see at table cu_cuti has cu_id_employee which is refers to cu_id_user table cu_user so i can count how many notifacition and mark the announcement already read or not yet by users ?

but please see at table cu_announcement i don't know how to count if admin post announcement and signs users already read or not, so my issue is

1. How can i count announcement which already read or not yet !
2. how can i make more clean table if users already read or not !


should i make another table for this, if yes please your refference for this, thanks


i also post image bellow ya

Attached Files

Thumbnail(s)
   

Yes, I would create a seperate table for this. Lets call it "cu_announcement_read" and just add two columns in there: "cu_anoun_id" and "cu_id_user". Then just fill it as some user reads some announcement.

Yes, I would create a seperate table for this. Lets call it "cu_announcement_read" and just add two columns in there: "cu_anoun_id" and "cu_id_user". Then just fill it as some user reads some announcement.

Hey sorry slow respond cause yesterday was weekend and sunday so i didn't online ?
my question is how can i query to count is user read or not read ? i didn't get idea about this,