📞chats

These models support group chats, personal chats, messages, and file attachments in a project collaboration environment.

🧑‍🤝‍🧑 GroupChat

Represents a group conversation, optionally with a display image.

🧩 Fields:

• 🆔 id: Primary key.

• 🖼️ image_id: Optional foreign key to an image file.

• 💬 chat_name: Group chat name (required).

• 📅 creation_date: Timestamp when the chat was created (required).

• 📝 description: Optional description of the chat.

🔗 Relationships:

• image: Connects to a File representing the group image.

• group_chats (on File side): Should be declared in the File model (back_populates='image').

---

👥 PersonalChat

Handles 1-on-1 direct messages between two users, optionally linked to a project.

🧩 Fields:

• 🆔 id: Primary key.

• 👤 user1_id: First user in the chat (required).

• 👤 user2_id: Second user in the chat (required).

• 📂 project_id: Optional link to a related project.

🔗 Relationships:

• user1 / user2: Two User relationships with custom joins.

• project: Linked to a Project.

---

💌 ChatLog

Represents an individual message inside a chat (either group or personal).

🧩 Fields:

• 🆔 id: Primary key.

• 💬 perschat_id: FK to PersonalChat (nullable).

• 💬 groupchat_id: FK to GroupChat (nullable).

• ✉️ sender_id: User who sent the message (required).

• 🕒 date_sent: Timestamp of the message (required).

• 📬 state: Message status enum type ("sent" , "delivered" , "read") (required).

• 📝 message_cont: Optional message text.

🔗 Relationships:

• perschat: Reference to PersonalChat.

• groupchat: Reference to GroupChat.

• sender: Reference to User.

---

📎 ChatLogsFile

Links a file attachment to a chat message.

🧩 Fields:

• 🆔 id: Primary key.

• 💌 chat_logs_id: The chat message this file belongs to (required).

• 📁 files_id: The actual file uploaded (required).

🔗 Relationships:

• chat_logs: Link to the ChatLog message.

• files: Link to the File model.