Entity Reference

All entities use Lombok annotations (@Data, @Getter, @Setter) and are mapped to H2 tables via @MappedEntity.

Note

Entities with @Id that go through CrudRepository.update() must use explicit getters/setters instead of Lombok @Getter/@Setter. Lombok hides the @Id annotation from the Micronaut Data annotation processor, causing "No identity is present" errors. Currently, EventRelations and Room follow this pattern.

User

Table: users

Field	Type	Description
`id`	String (PK)	User ID (`@alice:localhost`)
`passwordHash`	String	Password hash
`displayName`	String	Display name
`avatarUrl`	String	Avatar MXC URI
`createdAt`	Long	Creation timestamp

UserAccessToken

Table: user_access_tokens

Field	Type	Description
`id`	String (PK)	Token ID
`userId`	String	Owner user ID
`deviceId`	String	Device identifier
`token`	String	Opaque token string (`syt_...`)
`createdAt`	Long	Creation timestamp

Room

Table: rooms

Field	Type	Description
`id`	String (PK)	Room ID (`!room:localhost`)
`name`	String	Room name
`topic`	String	Room topic
`creatorId`	String	Creator user ID
`roomType`	String	Room type (`m.space` for spaces)
`createdAt`	Long	Creation timestamp

Event

Table: event

Field	Type	Description
`id`	String (PK)	Event ID
`roomId`	String	Room ID
`type`	String	Event type
`sender`	String	Sender user ID
`stateKey`	String	State key (null for non-state events)
`content`	String	JSON content
`streamOrdering`	Long	Stream position
`originServerTs`	Long	Origin server timestamp
`depth`	Long	DAG depth

RoomMember

Table: room_user

Field	Type	Description
`id`	String (PK)	Composite ID
`roomId`	String	Room ID
`userId`	String	User ID
`membership`	String	join/invite/leave/ban
`eventMembership`	String	Membership event ID

EventRelations

Table: event_relations

Field	Type	Description
`id`	Long (PK)	Auto-increment ID
`eventId`	String	Source event ID
`relatesToId`	String	Related event ID
`relationType`	String	m.thread, m.annotation, m.replace, m.reference
`eventType`	String	Related event type
`roomId`	String	Room ID

MediaMetadata

Table: media_metadata

Field	Type	Description
`id`	String (PK)	Media ID
`contentType`	String	MIME type
`contentLength`	Long	File size in bytes
`fileName`	String	Original filename
`uploadName`	String	Upload name

ServerSigningKey

Table: server_signing_key

Field	Type	Description
`id`	String (PK)	Key record ID
`serverName`	String	Server name
`keyId`	String	Key identifier
`publicKey`	String	Base64 public key
`privateKey`	String	Base64 private key
`algorithm`	String	Signing algorithm
`createdAt`	Long	Creation timestamp
`expiresAt`	Long	Expiration timestamp

UserPushRule

Table: user_push_rules

Field	Type	Description
`id`	String (PK)	Rule ID
`userId`	String	Owner user ID
`ruleId`	String	Rule identifier
`kind`	String	override/room/sender/content/underride
`enabled`	Boolean	Rule enabled
`actions`	String	JSON actions array
`conditions`	String	JSON conditions array

DeviceInbox

Table: device_inbox

Field	Type	Description
`id`	String (PK)	Message ID
`userId`	String	Target user ID
`deviceId`	String	Target device ID
`content`	String	JSON message content
`createdAt`	Long	Creation timestamp

#Entity Reference

#User

#UserAccessToken

#Room

#Event

#RoomMember

#EventRelations

#MediaMetadata

#ServerSigningKey

#UserPushRule

#DeviceInbox