schema.prisma

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

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider  = "postgresql"
  url       = env("POSTGRES_PRISMA_URL")
  directUrl = env("POSTGRES_URL_NON_POOLING")
}

model User {
  id String @id

  receipts Receipt[]
}

model Item {
  code     String   @id
  name     String
  picture  String
  issuedAt DateTime @default(now()) @map("issued_at")

  displays Display[]
}

model Event {
  code String   @id
  name String
  date DateTime

  // passed to new Function()
  // must be a JavaScript pure function
  // (state: { [K in ItemCode]: { count: number, dedication?: boolean } }) => number
  calculator String @default("return 0") @db.Text

  displays Display[]
  receipts Receipt[]
}

model Display {
  event     Event  @relation(fields: [eventcode], references: [code])
  eventcode String
  item      Item   @relation(fields: [itemcode], references: [code])
  itemcode  String

  records Record[]

  @@id([eventcode, itemcode])
  @@index([eventcode])
  @@index([itemcode])
}

model Receipt {
  id        String   @id // client-generated uuid
  createdAt DateTime
  total     Int

  event     Event  @relation(fields: [eventcode], references: [code])
  eventcode String
  user      User   @relation(fields: [userId], references: [id])
  userId    String

  records Record[]

  @@index([eventcode])
  @@index([userId])
}

model Record {
  receipt   Receipt @relation(fields: [receiptId], references: [id])
  receiptId String  @map("receipt_id")
  display   Display @relation(fields: [eventcode, itemcode], references: [eventcode, itemcode])
  eventcode String
  itemcode  String

  index      Int
  count      Int
  dedication Boolean

  @@id([receiptId, index])
  @@index([receiptId])
  @@index([eventcode])
  @@index([itemcode])
  @@index([eventcode, itemcode])
}