CREATE TABLE attachments ( id uuid PRIMARY KEY, chat_id uuid NOT NULL, owner_id uuid NOT NULL, filename text NOT NULL, content_type text NOT NULL, size_bytes integer NOT NULL CHECK (size_bytes BETWEEN 1 AND 10485760), sha256 text NOT NULL, ready boolean NOT NULL DEFAULT false, created_at timestamptz NOT NULL DEFAULT clock_timestamp(), updated_at timestamptz NOT NULL DEFAULT clock_timestamp(), FOREIGN KEY (chat_id, owner_id) REFERENCES members (chat_id, user_id) ); CREATE INDEX attachments_pending_idx ON attachments (created_at) WHERE NOT ready; ALTER TABLE messages DROP CONSTRAINT messages_text_check; ALTER TABLE messages ADD COLUMN attachment_ids uuid[] NOT NULL DEFAULT '{}'; ALTER TABLE messages ADD CHECK (char_length(text) <= 4000 AND cardinality(attachment_ids) <= 10 AND (char_length(text) > 0 OR cardinality(attachment_ids) > 0));