Data model

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

• posts and audience tables
• feed.comments
• feed.reactions
• feed.comment_reactions
• feed.feed_activities
• post reports and hides
• feed.app_releases
• feed.sticker_favorites
• feed.streak_recovery_state
• feed.user_streak_leaderboard
• feed.user_timezones
• feed.inbox_messages
• feed.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.