schema.prisma

// database
datasource db {
    provider = "mongodb"
    url      = env("DATABASE_URL")
}

// generator
generator client {
    provider             = "prisma-client-py"
    recursive_type_depth = 5
}

// data models
model Template {
    id         String @id @default(auto()) @map("_id") @db.ObjectId
    title      String @unique
    entrypoint String
    created_at DateTime @default(now())

    files  TemplateFile[]
    sample SampleFile?
}

model TemplateFile {
    id          String @id @default(auto()) @map("_id") @db.ObjectId
    filename    String
    template_id String @db.ObjectId
    file_id     String @db.ObjectId @unique

    template Template @relation(fields: [template_id], references: [id])
    file     FileObj  @relation(fields: [file_id], references: [id])
}

model SampleFile {
    id          String @id @default(auto()) @map("_id") @db.ObjectId
    template_id String @db.ObjectId @unique
    file_id     String @db.ObjectId @unique
    data        Json

    template Template @relation(fields: [template_id], references: [id])
    file     FileObj  @relation(fields: [file_id], references: [id])
}

model FileObj {
    id           String @id @default(auto()) @map("_id") @db.ObjectId
    name         String
    content_type String
    content      Bytes

    template TemplateFile?
    sample   SampleFile?
}