使用Prisma向room表插入记录失败问题求助

我在使用Prisma向room模块对应的表插入记录时遇到问题：向user表插入新元素可正常执行，但向room表插入失败。

相关截图：

已在容器和宿主机中执行yarn prisma migrate dev、yarn prisma generate命令，命令执行日志如下：

root@70cfe0072344:/usr/src/api# yarn prisma migrate dev
yarn run v1.22.19
$ /usr/src/api/node_modules/.bin/prisma migrate dev
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": PostgreSQL database "trandandan", schema "public" at "postgres:5432"

Already in sync, no schema change or pending migration was found.

✔ Generated Prisma Client (4.7.1 | library) to ./node_modules/@prisma/client in 99ms


Done in 3.36s.
root@70cfe0072344:/usr/src/api# yarn prisma generate
yarn run v1.22.19
$ /usr/src/api/node_modules/.bin/prisma generate
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma

✔ Generated Prisma Client (4.7.1 | library) to ./node_modules/@prisma/client in 90ms
You can now start using Prisma Client in your code. Reference: https://pris.ly/d/client

import { PrismaClient } from '@prisma/client'
const prisma = new PrismaClient()

Done in 1.64s.
root@70cfe0072344:/usr/src/api#

但问题仍未解决，以下是我的docker-compose配置文件供参考：

version: '3.7'

services:
  api:
    container_name: api
    build:
      context: ./api
      target: development
    volumes:
      - ./api:/usr/src/api
      - /usr/src/api/node_modules
    ports:
      - ${SERVER_PORT}:${SERVER_PORT}
      - 5555:5555 # for prisma studio
      - 9229:9229 # for debugging
    command: yarn start:dev
    networks:
      - webnet
    depends_on:
      - postgres
  postgres:
    container_name: postgres
    image: postgres:14
    networks:
      - webnet
    environment:
      POSTGRES_DB: ${DB_DATABASE_NAME}
      POSTGRES_USER: ${DB_USERNAME}
      POSTGRES_PASSWORD: ${DB_PASSWORD}
      PG_DATA: /var/lib/postgresql/data
    ports:
      - 5432:5432
    volumes:
      - pgdata:/var/lib/postgresql/data
networks:
  webnet:
volumes:
  pgdata:

内容的提问来源于stack exchange，提问作者AMZIL Ayoub