Discussion: How to design a complete plate for receiving and sending notifications?

superzhgg

As the title, I want to be a complete section for receiving and sending notifications. There are many departments within the entire website, and there are groups within the departments. Notifications can be sent to all departments, only to department leaders, or only to groups. Changhe department leaders can also be notices within the department (only people within the department can see), or they can only be issued to someone. After receiving the notification, the person receiving the notification should be prompted accordingly, and do not use a similar form of email. How to design a reasonable one?

养狗的上帝

First, there must be an organizational structure management, such as
01 Head Office
0101 Department 1
010101 User A
010102 User B
0102 Department 2
010201 User C
...

When sending a message, each Msg corresponds to an organization structure number, such as 0101, which means that department 1 can be read by everyone, if the number is 010102, it means that only user B can read.

After a user logs in, he can determine all the notifications he can see through the LIKE statement according to his node number. For example, for user B, the SQL query statement is:
SELECT * FROM Message WHERE
       msgNo LIKE '010102%' OR msgNo = '0101' OR msgNo = '01 '
ORDER BY msgDate

Understand! !

superzhgg

Then I want to send a message to certain people (not just one person). How do I construct the message number?

养狗的上帝

Then a special table records the allowable reading structure number corresponding to each piece of information, such as:
msgID deptNo
1 010102
1 010103
1 0102
1 0104
2 0102
2 0103

superzhgg

Then this is almost the same as the mail system. Ha ha, it ’s not that I ’m embarrassed by you. It ’s the customer ’s request to us. I really do n’t know of any way.

xia_4658

xia_4658

养狗的上帝
-------------------------------------------------- -----
This structure feels good.
msgID deptNo
1 0101; 0102; 0104 01, 02, 04 Department
2 01; everyone sees
3 010102; 010103; 0104; several people and a certain department.

superzhgg

What I thought before was to create a table to store the notification title, content, etc., and then create a table to add everyone, and there is a field to specifically record the notification ID, and then the notification sent to the corresponding in the next table The ID of the notification is added to the field of the notification ID of the person's record. The IDs are separated by commas. The customer says that this is in the form of an email and cannot do this! The above buddies think the same as I think. Seek all methods except this one! Oh, everyone help!