63 lines
1.4 KiB
Plaintext
63 lines
1.4 KiB
Plaintext
// 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 = "prisma-client-js"
|
|
}
|
|
|
|
datasource db {
|
|
provider = "postgresql"
|
|
url = env("DATABASE_URL")
|
|
}
|
|
|
|
model Organisation {
|
|
id String @id @default(cuid())
|
|
name String @default("")
|
|
tag String @default("")
|
|
type String @default("")
|
|
logo String @default("")
|
|
slug String @default("")
|
|
}
|
|
|
|
model Membre {
|
|
id String @id @default(cuid())
|
|
userId String @default("")
|
|
organisationid String @default("")
|
|
role String @default("")
|
|
slug String @default("")
|
|
}
|
|
|
|
model User {
|
|
id String @id @default(cuid())
|
|
userId String @default("")
|
|
userName String @default("")
|
|
categorie String @default("")
|
|
role String @default("")
|
|
slug String @default("")
|
|
}
|
|
|
|
model GameSession{
|
|
id String @id @default(cuid())
|
|
organisationId String @default("")
|
|
title String @default("")
|
|
date DateTime
|
|
startTime DateTime @db.Time
|
|
endTime DateTime @db.Time
|
|
paf Int @default(0)
|
|
maxPlayer Int @default(0)
|
|
slug String @default("")
|
|
}
|
|
model GameSessionTag{
|
|
id String @id @default(cuid())
|
|
gameSessionId String @default("")
|
|
tagId String @default("")
|
|
slug String @default("")
|
|
}
|
|
model Tag{
|
|
id String @id @default(cuid())
|
|
title String @default("")
|
|
slug String @default("")
|
|
} |