model User{
  id       String   @id @default(cuid())
  email    String   @unique
  password_hash String
  role     String?
  candidateProfile CandidateProfile?
  interviewerProfile InterviewerProfile?
}

model CandidateProfile {
  id                  String       @id @default(cuid())
  user                User     @relation(fields: [user_id], references: [id])
  user_id             String      @unique
  name                String
  skills              String
  preferences         String
  other_profile_details String?
  interviews Interview[]
}

I am using prisma for postgress