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 Event {
  id                  String            @id @default(uuid())
  // key public metadata
  name                String
  description         String?
  timezone            String            @default("America/New_York")
  startAt             DateTime
  endAt               DateTime
  // location info
  venueType           EventVenueType    @default(IN_PERSON)
  venueName           String?
  address             String?
  country             String?
  city                String?
  stateOrProvince     String?
  postalCode          String?
  // registration fields
  registrationStartAt DateTime
  registrationEndAt   DateTime
  currency            String            @default("USD")
  capacity            Int?
  // general timestamps
  createdAt           DateTime          @default(now())
  updatedAt           DateTime          @default(now()) @updatedAt
  // relationships
  sessions            EventSession[]
  speakers            EventSpeaker[]
  registrants         EventRegistrant[]
}

model EventRegistrant {
  id             String         @id @default(uuid())
  // metadata
  email          String
  firstName      String
  lastName       String
  displayName    String?
  jobTitle       String?
  company        String?
  profilePicture String?
  dateOfBirth    DateTime       @db.Date
  language       String         @default("en-US")
  // internal admin fields
  ipAddress      String
  notes          String?
  // general timestamps
  createdAt      DateTime       @default(now())
  updatedAt      DateTime       @default(now()) @updatedAt
  cancelledAt    DateTime?
  checkedInAt    DateTime?
  // relationships
  event          Event          @relation(fields: [eventId], references: [id])
  eventId        String
  sessions       EventSession[]
  speaker        EventSpeaker?
}

model EventSession {
  id             String            @id @default(uuid())
  // key public metadata
  name           String
  description    String?
  startAt        DateTime
  endAt          DateTime
  capacity       Int?
  // general timestamps
  createdAt      DateTime          @default(now())
  updatedAt      DateTime          @default(now()) @updatedAt
  // relationships
  event          Event             @relation(fields: [eventId], references: [id])
  eventId        String
  speaker        EventSpeaker?     @relation(fields: [eventSpeakerId], references: [id])
  eventSpeakerId String?
  registrants    EventRegistrant[]
}

model EventSpeaker {
  id             String           @id @default(uuid())
  firstName      String
  lastName       String
  jobTitle       String?
  company        String?
  profilePicture String?
  bio            String
  dateOfBirth    DateTime         @db.Date
  language       String           @default("en-US")
  // internal admin fields
  ipAddress      String
  // general timestamps
  createdAt      DateTime         @default(now())
  updatedAt      DateTime         @default(now()) @updatedAt
  // relationships
  event          Event            @relation(fields: [eventId], references: [id])
  eventId        String
  sessions       EventSession[]
  registrant     EventRegistrant? @relation(fields: [registrantId], references: [id])
  registrantId   String?          @unique
}

enum EventVenueType {
  IN_PERSON
  ONLINE
  HYBRID
}