Teachers, Students and Parents must be able to send messages

[josepostiga]

Scenario

As a Teacher or Student
I must be able to send and receive messages
So that I can communicate with other Teachers or Students

As a Parent
I must be able to send and receive messages
So that I can communicate with Headteachers

As a Headteacher
I must be able to send and receive messages
So that I can communicate with other teachers, Students, or Parents

Description

Messages are simple blocks of text with a sender and one, or many, receivers. To safeguard the students' identity, only teachers and other students can communicate with each other. In the same way, Parents can only communicate with headteachers.

Messages can only be seen, added, or deleted. Deletes, however, are soft, meaning no actual message is removed from the system.

Database and schema information

Create a new topic table to be used as an aggregator of messages. It'll hold information about who first created the topic and the usual timestamps.

Create a new topic_user table to hold a topic and user foreign keys, associating who has access to all messages from that topic.

Create a new topic_message table that holds a topic foreign key, the actual message, and the usual timestamps.

Additional requirements

No additional requirements.