Skip to content

Rallly is an open-source scheduling and collaboration tool designed to make organizing events and meetings easier.

3.6 KB
Raw Blame
enum ScheduledEventStatus {
  confirmed
  canceled
  unconfirmed

  @@map("scheduled_event_status")
}

enum ScheduledEventInviteStatus {
  pending
  accepted
  declined
  tentative

  @@map("scheduled_event_invite_status")
}

model ScheduledEvent {
  id            String               @id @default(cuid())
  userId        String               @map("user_id")
  spaceId       String               @map("space_id")
  eventTypeId   String?              @map("event_type_id")
  sheetSlotId   String?              @unique @map("sheet_slot_id")
  title         String
  description   String?
  location      Json?
  conferencing  Json?
  capacity      Int?
  createdAt     DateTime             @default(now()) @map("created_at")
  updatedAt     DateTime             @updatedAt @map("updated_at")
  status        ScheduledEventStatus @default(confirmed)
  /// Venue / anchor timezone for in-person or hybrid events. Null means no fixed venue (e.g. remote-only).
  timeZone      String?              @map("time_zone")
  start         DateTime
  end           DateTime
  allDay        Boolean              @default(false) @map("all_day")
  deletedAt     DateTime?            @map("deleted_at")
  sequence      Int                  @default(0)
  uid           String               @unique
  hideAttendees Boolean              @default(false) @map("hide_attendees")

  user             User                   @relation(fields: [userId], references: [id], onDelete: Cascade)
  space            Space                  @relation(fields: [spaceId], references: [id], onDelete: Cascade)
  eventType        EventType?             @relation(fields: [eventTypeId], references: [id], onDelete: SetNull)
  sheetSlot        SheetSlot?             @relation(fields: [sheetSlotId], references: [id], onDelete: SetNull)
  rescheduledDates RescheduledEventDate[]
  invites          ScheduledEventInvite[]
  polls            Poll[]

  @@index([spaceId])
  @@index([userId])
  @@index([eventTypeId])
  @@index([spaceId, status, start])
  @@map("scheduled_events")
}

model RescheduledEventDate {
  id               String   @id @default(cuid())
  scheduledEventId String   @map("scheduled_event_id")
  start            DateTime @map("start")
  end              DateTime @map("end")
  allDay           Boolean  @default(false) @map("all_day")
  createdAt        DateTime @default(now()) @map("created_at")

  scheduledEvent ScheduledEvent @relation(fields: [scheduledEventId], references: [id], onDelete: Cascade)

  @@index([scheduledEventId])
  @@map("rescheduled_event_dates")
}

model ScheduledEventInvite {
  id               String                     @id @default(cuid())
  uid              String                     @unique
  scheduledEventId String                     @map("scheduled_event_id")
  inviteeName      String                     @map("invitee_name")
  inviteeEmail     String                     @map("invitee_email") @db.Citext
  inviteeId        String?                    @map("invitee_id")
  inviteeTimeZone  String?                    @map("invitee_time_zone")
  inviteeLocale    String?                    @map("invitee_locale")
  status           ScheduledEventInviteStatus @default(pending)
  createdAt        DateTime                   @default(now()) @map("created_at")
  updatedAt        DateTime                   @updatedAt @map("updated_at")

  scheduledEvent ScheduledEvent @relation(fields: [scheduledEventId], references: [id], onDelete: Cascade)
  user           User?          @relation(fields: [inviteeId], references: [id], onDelete: SetNull) // Optional relation to User model

  @@unique([scheduledEventId, inviteeEmail])
  @@index([inviteeId])
  @@index([inviteeEmail])
  @@map("scheduled_event_invites")
}