Data model

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

• social.user_projection
• social.friendships
• social.friend_requests
• social.user_blocks
• social.qr_identities
• social.groups
• social.group_members
• social.group_invitations
• social.group_qr_codes
• social.close_friends
• social.user_notes
• social.custom_emojis
• social.user_discovery_prefs
• social.user_location_presence
• social.search_history
• social.inbox_messages
• social.event_outbox

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.