The scenario involves designing a database schema for a messaging application. The application should support private messages, the ability to attach files such as images and text, and group chats.
2. Create an database diagram (along with all required joins and model details) for a simple messaging app capable of sending messages, attaching files (images and text), and having group chats.