New returns a new instance of AppDatabase based on the SQLite connection `db`.

Conversation represents a conversation between users.

Message represents a message in a conversation.

Reaction represents an emoji reaction to a message.

User represents a user in the system.

AppDatabase is the high level interface for the DB.