Message database with applications
I can't figure out how to create such a database.
The initial data is as follows:
1. each user belongs to a regional center (RC), and their profile contains the ID of that center
2. several training programs are linked to each RC, meaning there is a table of relationships
3. a training application is created from an external site (not on Drupal) with the specified program ID and RC, and it is sent to the RC's email and several others.
It is required to save these messages in the database as well. The RCs have access to a closed site on Drupal 6.19
and on that site, each RC needs to display a list of incoming messages and a status that they must set themselves (received - not received). Naturally, the administrator or those with access should see the entire list of messages by RC.
I am a programmer myself, but I am still far from Drupal; I work with another system. However, I need to create this feature for the site.
Writing messages to the database is not a problem, but then...