forked from mtusi2026/mtusi2026lab2
55 lines
3.5 KiB
Plaintext
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)
|
|
|
|
|