schema.prisma

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

generator client {
  provider = "prisma-client-js"
  output   = "node_modules/.prisma/client"
}

model Action {
  id                     Int          @id @default(autoincrement())
  title                  String?
  datePublished          DateTime?
  image                  Json?
  content                Json?
  relatedSdgs            Sdg[]        @relation("Action_relatedSdgs_Sdg_actions", references: [id])
  categories             Category[]   @relation("Action_categories_Category_actions", references: [id])
  from_Completion_action Completion[] @relation("Completionaction")
}

model Category {
  id      Int      @id @default(autoincrement())
  title   String?
  actions Action[] @relation("Action_categories_Category_actions", references: [id])
}

model Completion {
  id             Int       @id @default(autoincrement())
  completionDate DateTime?
  action         Action?   @relation("Completionaction", fields: [actionId], references: [id])
  actionId       Int?      @map("action")
  user           User?     @relation("Completionuser", fields: [userId], references: [id])
  userId         Int?      @map("user")
  kudos          User[]    @relation("Completion_kudos_many", references: [id])

  @@index([actionId])
  @@index([userId])
}

model Idea {
  id            Int       @id @default(autoincrement())
  title         String?
  body          String?
  dateSubmitted DateTime?
  user          User?     @relation("Ideauser", fields: [userId], references: [id])
  userId        Int?      @map("user")

  @@index([userId])
}

model Sdg {
  id                      Int      @id @default(autoincrement())
  sdgNo                   Int?
  title                   String?
  description             String?
  content                 Json?
  actions                 Action[] @relation("Action_relatedSdgs_Sdg_actions", references: [id])
  from_User_favouriteSdgs User[]   @relation("User_favouriteSdgs_many", references: [id])
}

model User {
  id                      Int          @id @default(autoincrement())
  name                    String?
  email                   String?      @unique
  password                String?
  profilePicture          Json?
  biography               String?
  areasOfInterest         String?
  funFacts                String?
  isAdmin                 Boolean?
  passwordResetToken      String?
  passwordResetIssuedAt   DateTime?
  passwordResetRedeemedAt DateTime?
  favouriteSdgs           Sdg[]        @relation("User_favouriteSdgs_many", references: [id])
  completions             Completion[] @relation("Completionuser")
  from_Completion_kudos   Completion[] @relation("Completion_kudos_many", references: [id])
  from_Idea_user          Idea[]       @relation("Ideauser")
}