TABLES
    table_name     
-------------------
 chat_members
 chats
 messages
 schema_migrations
 users
(5 rows)

INDEXES
            indexname            |                                               indexdef                                                
---------------------------------+-------------------------------------------------------------------------------------------------------
 chat_members_pkey               | CREATE UNIQUE INDEX chat_members_pkey ON public.chat_members USING btree (chat_id, user_id)
 chat_members_user_chat_idx      | CREATE INDEX chat_members_user_chat_idx ON public.chat_members USING btree (user_id, chat_id)
 chats_created_at_id_idx         | CREATE INDEX chats_created_at_id_idx ON public.chats USING btree (created_at, id)
 chats_pkey                      | CREATE UNIQUE INDEX chats_pkey ON public.chats USING btree (id)
 messages_chat_created_at_id_idx | CREATE INDEX messages_chat_created_at_id_idx ON public.messages USING btree (chat_id, created_at, id)
 messages_pkey                   | CREATE UNIQUE INDEX messages_pkey ON public.messages USING btree (id)
 schema_migrations_pkey          | CREATE UNIQUE INDEX schema_migrations_pkey ON public.schema_migrations USING btree (version)
 users_pkey                      | CREATE UNIQUE INDEX users_pkey ON public.users USING btree (id)
 users_username_key              | CREATE UNIQUE INDEX users_username_key ON public.users USING btree (username)
(9 rows)

MIGRATIONS
 version  |          applied_at           
----------+-------------------------------
 001_init | 2026-11-06 19:22:16.209767+00
(1 row)

COUNTS
 users | chats | members | messages 
-------+-------+---------+----------
    34 |    11 |      18 |    22635
(1 row)

