Schema
======

The fresh schema in :download:`schema.sql <../../schema.sql>` stores users,
profiles, email tokens, warnings, reports, servers, members, roles, channels,
invites, server messages, friendships, conversations, conversation messages,
attachments, and reactions.

Foreign keys enforce ownership and membership relationships. Most identifiers
are ``CHAR(36)`` UUID strings. Message and membership tables include indexes
for their common lookup paths, while unique keys prevent duplicate usernames,
server channel names, and per-user/per-message reactions.

Review the SQL file itself for exact column types, defaults, collations, and
constraints before changing a migration.