Data model

Schema messaging is created at database init and migrated only by this service's Flyway scripts in src/main/resources/db/migration.

• messaging.conversations
• messaging.conversation_participants
• messaging.messages
• messaging.message_attachments
• messaging.message_reactions
• messaging.pinned_messages
• messaging.user_chat_settings
• messaging.user_projection
• messaging.event_outbox
• messaging.inbox_messages

Cross-service reads go through HTTP or through a local projection table filled by the inbox. Do not add a foreign key to another schema.