prisma-file.txt

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

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

model User {
  id  String @default(uuid()) @unique @id
  email String  @unique
  password String
  name  String?
  role  Role @default(STUDENT)
  group_membership Group_membership[]
  result Result[]
  response Response[]
  // if he is a student then he can have many results
  // user can have many group membership
}

model Group {
  id String @default(uuid()) @unique @id
  name String
  group_membership Group_membership[]
  quiz Quiz[]
  // can have many members
  // can have many/one admin -> adminId[] -> group admin
  // a group can have many quizes
}

model Group_membership {
  creator Boolean @default(false)
  user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  userId String
  group Group @relation(fields: [groupId], references: [id], onDelete: Cascade)
  groupId String
  @@id([userId, groupId]) // composite
  // id  String @default(uuid()) @unique @id
  // User Id -> one to one
  // group id 
  // user type -> could be enum
}

model Quiz {
  id  String @default(uuid()) @unique @id
  name String
  full_marks Int
  pass_marks Int
  category_name Category_name @default(ACHIEVEMENT) // Enum
  questions Question[]
  answers Answer[]
  result Result[]
  response Response[]
  group Group @relation(fields: [groupId], references: [id], onDelete: Cascade)
  groupId String

  // A quiz has many results
  // has one category
  // can have many result
  // negative marks
  // full marks
  // pass marks
  // a group can many quizes
}


model Question {
  id  String @default(uuid()) @unique @id
  question_text String
  quiz Quiz @relation(fields: [quizId], references: [id], onDelete: Cascade)
  quizId String
  options Option[]
  answer Answer?
}

model Option {
  id  String @default(uuid()) @unique @id
  option String
  txt String
  mark Int
  question Question @relation(fields: [questionId], references: [id], onDelete: Cascade)
  questionId String
}

model Answer {
  id  String @default(uuid()) @unique @id
  answer_text String
  question Question @relation(fields: [questionId], references: [id], onDelete: Cascade)
  questionId String @unique
  quiz Quiz @relation(fields: [quizId], references: [id], onDelete: Cascade)
  quizId String
}

model Response {
  id  String @default(uuid()) @unique @id
  student_response String[]
  user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  userId String
  quiz Quiz @relation(fields: [quizId], references: [id], onDelete: Cascade)
  quizId String
  result Result? // A response can have zero or only one result
}

model Result {
  id  String @default(uuid()) @unique @id
  marks Int
  quiz Quiz @relation(fields: [quizId], references: [id], onDelete: Cascade)
  quizId String
  response Response @relation(fields: [responseId], references: [id], onDelete: Cascade)
  responseId String @unique
  user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  userId String
  // quiz id 
  // student Id -> user Id -> might duplicate
  // Group Id
  // marks -> achieved marks after quiz
  // negativity
  // Before result there must be a response
  // status : pass or fail
}

enum Category_name {
  ACHIEVEMENT
  IQ
  PERSONALITY
  PSYCHOLOGICAL
}

enum Role {
  STUDENT
  TEACHER
}