schema.prisma

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

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

// Define your own datamodels here and run `yarn redwood prisma migrate dev`
// to create migrations for them and apply to your dev DB.
model User {
  id                  Int       @id @default(autoincrement())
  email               String    @unique
  hashedPassword      String
  salt                String
  resetToken          String?
  resetTokenExpiresAt DateTime?
  confirmed           Boolean   @default(false)
}

model Partner {
  id               Int           @id @default(autoincrement())
  name             String
  slug             String        @unique
  logo             String?
  avatar           String?
  virtualCode      String?
  virtualDiscount  Int?
  virtualEndDate   DateTime?
  inPersonCode     String?
  inPersonDiscount Int?
  inPersonEndDate  DateTime?
  inPersonUrl      String?
  Participants     Participant[]
  createdAt        DateTime      @default(now())
  PartnerType      PartnerType   @relation(fields: [partnerTypeId], references: [id])
  partnerTypeId    Int
  ogImage          String?
}

model Participant {
  id        Int      @id @default(autoincrement())
  name      String?
  email     String   @unique
  company   String?
  avatar    String?
  githubId  Int?
  location  String?
  twitter   String?
  partner   Partner  @relation(fields: [partnerId], references: [id])
  partnerId Int
  createdAt DateTime @default(now())
  ogImage   String?
}

model PartnerType {
  id        Int       @id @default(autoincrement())
  name      String
  createdAt DateTime  @default(now())
  Partners  Partner[]
}