ok, i made it working on my machine. and i will provide step by step guide. if it still does not works, then please let me know.

i use prisma 6.13.0 with new prisma typescrpt compiler. and also used prisma.config.ts

here is my prisma.schema main block. i used nextjs to test & did not generated src/ directory here.

generator client {
  provider = "prisma-client"
  output   = "../app/generated/prisma"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

here is my prisma.config.ts

import "dotenv/config";
import path from "node:path";
import type { PrismaConfig } from "prisma";

export default {
    schema: path.join("prisma", "schema.prisma"),
    migrations: {
        path: path.join("prisma", "migrations"),
    },
    views: {
        path: path.join("prisma", "views"),
    },
    typedSql: {
        path: path.join("prisma", "queries"),
    },
} satisfies PrismaConfig;

Please note that, when used prisma.config.ts, you need to install dotenv package by npm install dotenv . otherwise prisma won't be able to read database_url*
*
here look at my simple multi-schema.
prisma schema sub module image*
*
and then look at prisma.config.ts at schema block. since my prisma.schema was directly inside prisma/ i had it like this path.join("prisma", "schema.prisma")

i just noticed you had two prisma.schema which is a no-go. from official docs, they had only one prisma.schema.
so, first you need to update this duplicated prisma.schema.
have only one prisma.schema under schema/ and then

update prisma.config.ts schema block to path.join("prisma", "schema", "schema.prisma")

i hope this will be enough

here is the official docs . hope it helps.