schema.prisma

datasource db {
  provider  = "postgresql"
  url       = env("POSTGRES_PRISMA_URL")
  directUrl = env("POSTGRES_URL_NON_POOLING")
}

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

model User {
  id          String   @id @unique @default(uuid())
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
  secret      String   @unique
  email       String   @unique
  password    String   @default(uuid())
  name        String   @default("New User")
  roles       String[] @default(["member"])
  permissions String[] @default(["default"])
  image       String
}

model Event {
  id          String   @id @unique @default(uuid())
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
  name        String   @default("New Event")
  description String   @default("New Event Description")
  date        String   @default("No date provided")
  location    String   @default("No location provided")
  perks       String[] @default([])
  rsvps       String[] @default([]) // User IDs
  pinned      Boolean  @default(false)
  image       String
}

model Club {
  id          String   @id @unique @default(uuid())
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
  name        String   @default("New Club")
  description String   @default("New Club Description")
  linktree    String
  image       String
}

model Initiative {
  id          String   @id @unique @default(uuid())
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
  name        String   @default("New Initiative")
  description String   @default("New Initiative Description")
  image       String
}

// npx prisma migrate dev --name init
// npx prisma db push
// npx prisma generate