Rallly is an open-source scheduling and collaboration tool designed to make organizing events and meetings easier.
TypeScript i18nextnext-authnextjspostgresqlprismareact-emailt3-stacktailwindcsstrpcturborepotypescriptzod
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")
}