#Database Overview

Firmiana uses an embedded H2 database with Micronaut Data JDBC for data access.

#Entity Summary

#User & Auth

#Room & Events

#E2EE

#Media

#Push & Notifications

#Presence & Typing

#Federation

#Relationships

User ──1:N──> UserAccessToken
User ──1:N──> UserDevice
User ──1:N──> UserPassword
Room ──1:N──> RoomMember ──N:1──> User
Room ──1:N──> Event
Event ──1:N──> EventRelations
Room ──1:N──> RoomAlias

#Indexes

Key indexes for performance (added via Flyway migrations V21–V22):

• event(room_id, stream_ordering) — Event timeline queries
• room_user(room_id, user_id) — Membership lookups
• device_inbox(created_at) — To-device message cleanup
• notification(created_at) — Notification queries
• event_search(content) — Full-text search (B-tree fallback)