[Question] It possible to create a multiple schema files?

[Prashant4900]

I'm currently working on a Dart backend project where I need to create multiple tables approx 15 or more but the problem is that when I generate my schema which is just 2 tables it already generates 4500+ lines of code with the file size (100kb) so I'm worried about what happen if I create more and more tables?

Also, it keeps storing every single model in the same files even though there is a high chance there are some models which different from each other and have no relation between them.

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

// Looking for ways to speed up your queries, or scale easily with your serverless or edge functions?
// Try Prisma Accelerate: https://pris.ly/cli/accelerate-init

generator client {
  provider = "dart run orm"
  output   = "../lib/gen/orm/"
}

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

model Users {
    id Int @id @default(autoincrement())
    firstName String
    lastName String
    email String
    password String

    isActive Boolean
    isSuperAdmin Boolean

    createdAt DateTime @default(now())
    updatedAt DateTime

    @@unique([email])

    @@map("users")
}

model Admins {
    id Int @id @default(autoincrement())
    firstName String
    lastName String
    email String
    password String

    isActive Boolean
    isSuperAdmin Boolean

    createdAt DateTime @default(now())
    updatedAt DateTime

    @@unique([email])

    @@map("admins")
}

*Describe the solution you'd like
Is it possible to split or in a different directory and create a different file for every schema?

For example: if I have 2 modules in my application admin and users I can able to define 2 different schema files admin.prisma and user.prisma in their respective modules and all the files will generate in their respective modules only while maintaining one single database connection.

[medz]

I have tried to write each model into a separate file. But in the end, it was too scattered. Therefore, it is now assigned to three files according to the type. This is a huge restructuring work.

[Prashant4900]

Yes, i understand if user doesn't have a proper architecture it will create project cluster fill with generate files but if there is option to provide a little bit flexibility like users have a options to set wether they want single schema or multiple.

Also one thing which I doesn't get it (first time to use this orm maybe I'm wrong) i see it generates 3 files client, model and type safe connector. But my question why we have a model here i mean it a simple data file which can user create themselves This might help to reduce extra unwanted code also about the other 2 files rather than generate whole code on client side we can abstract some of on package side or might create some generic base class which handle all the basis stuff and if user wants to create themselves they can write their own

Example

class AdminController extends BaseController {

@override
get by id

do something 
}

final adminController = AdminController():

adminController.get()

adminController.post()

adminController.doSomething();

Idk whether it good idea or not but it might help to reduce the number of lines of code and might also possible to merge whole Code in one single generated file.