rheinefuerrheine/backend/prisma/schema.prisma

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["postgresqlExtensions"]
}

datasource db {
  provider   = "postgresql"
  url        = env("DATABASE_URL")
  extensions = [uuid_ossp(map: "uuid-ossp")]
}

model users {
  ID       String @id @default(dbgenerated("uuid_generate_v1()")) @db.Uuid
  username String
  password String @db.VarChar(128)
  token    String @db.VarChar(128)
}

model Mitarbeiter {
  ID           String   @id @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
  Vorname      String
  Nachname     String
  Anstelldatum DateTime @db.Date
  Geburtstag   DateTime @db.Date
}