Files
mtusi2026lab2/evidence/migrations.txt

55 lines
3.5 KiB
Plaintext

$ 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)