Files
psalmtafel-webservice/prisma/schema.prisma
Rudi 496a70ffed Update on Songbooksongs number
Number of Song in a Songbook is not number anymore but string
so "3a" would work.
2026-08-27 15:00:04 +02:00

45 lines
912 B
Plaintext

generator client {
provider = "prisma-client"
output = "../lib/generated/prisma"
}
datasource db {
provider = "sqlite"
}
model User {
id Int @id @default(autoincrement())
username String @unique
password String
role String @default("user")
name String?
}
model Song {
id Int @id @default(autoincrement())
title String @unique
songBooks SongBookSongs[]
}
model SongBook {
id Int @id @default(autoincrement())
title String @unique
language String
songs SongBookSongs[]
}
model SongBookSongs {
songBookId Int
songId Int
songNumber String
song Song @relation(fields: [songId], references: [id], onDelete: Cascade)
book SongBook @relation(fields: [songBookId], references: [id], onDelete: Cascade)
@@id([songBookId, songId])
}