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
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.
(01-30-2016, 01:17 AM)Diederik Wrote: 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, |
Welcome Guest, Not a member yet? Register Sign In |