dwldashboard/backend/prisma/schema.prisma

26 lines
627 B
Plaintext

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_v4()")) @db.Uuid
username String
password String @db.VarChar(128)
token String @db.VarChar(128)
}
model Employees {
ID String @id @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
Vorname String
Nachname String
Anstelldatum DateTime? @db.Date
Geburtstag DateTime? @db.Date
}