$ docker compose logs --no-log-prefix api | grep -E 'миграци|Схема БД'
2026-10-11 14:40:39.798 | INFO     | infrastructure.dependencies.database:apply_migrations:156 - Схема БД в актуальной версии
2026-10-11 14:40:48.046 | INFO     | infrastructure.dependencies.database:apply_migrations:156 - Схема БД в актуальной версии

$ docker compose exec -T postgres sh -c 'psql -X -U "$POSTGRES_USER" -d "$POSTGRES_DB" -c "SELECT * FROM schema_migrations"'
 version |   name    |          applied_at           
---------+-----------+-------------------------------
       1 | 0001_init | 2026-10-04 13:01:32.330387+00
(1 row)


$ docker compose exec -T postgres sh -c 'psql -X -U "$POSTGRES_USER" -d "$POSTGRES_DB" -c "\d+ messages"'
                                                    Table "public.messages"
   Column   |           Type           | Collation | Nullable | Default  | Storage  | Compression | Stats target | Description 
------------+--------------------------+-----------+----------+----------+----------+-------------+--------------+-------------
 id         | uuid                     |           | not null | uuidv7() | plain    |             |              | 
 chat_id    | uuid                     |           | not null |          | plain    |             |              | 
 sender_id  | uuid                     |           | not null |          | plain    |             |              | 
 text       | text                     |           | not null |          | extended |             |              | 
 created_at | timestamp with time zone |           | not null |          | plain    |             |              | 
Indexes:
    "messages_pkey" PRIMARY KEY, btree (id)
    "messages_chat_id_created_at_id_idx" btree (chat_id, created_at, id)
Check constraints:
    "messages_text_len" CHECK (char_length(text) >= 1 AND char_length(text) <= 4000)
Foreign-key constraints:
    "messages_sender_member_fkey" FOREIGN KEY (chat_id, sender_id) REFERENCES chat_members(chat_id, user_id) ON DELETE CASCADE
Not-null constraints:
    "messages_id_not_null" NOT NULL "id"
    "messages_chat_id_not_null" NOT NULL "chat_id"
    "messages_sender_id_not_null" NOT NULL "sender_id"
    "messages_text_not_null" NOT NULL "text"
    "messages_created_at_not_null" NOT NULL "created_at"
Access method: heap


$ docker compose exec -T postgres sh -c 'psql -X -U "$POSTGRES_USER" -d "$POSTGRES_DB" -c "\di"'
                                   List of indexes
 Schema |                Name                | Type  |   Owner   |       Table       
--------+------------------------------------+-------+-----------+-------------------
 public | chat_members_pkey                  | index | messenger | chat_members
 public | chat_members_position_key          | index | messenger | chat_members
 public | chat_members_user_id_chat_id_idx   | index | messenger | chat_members
 public | chats_pkey                         | index | messenger | chats
 public | messages_chat_id_created_at_id_idx | index | messenger | messages
 public | messages_pkey                      | index | messenger | messages
 public | schema_migrations_pkey             | index | messenger | schema_migrations
 public | sessions_pkey                      | index | messenger | sessions
 public | sessions_user_id_idx               | index | messenger | sessions
 public | users_pkey                         | index | messenger | users
 public | users_username_key                 | index | messenger | users
(11 rows)


