prisma/schema.prisma

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

datasource db {
  provider = "postgresql"
}

model cv_file {
  file_id       String    @id @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
  user_id       String    @db.Uuid
  file_type     String    @db.VarChar
  filename      String    @db.VarChar
  url           String    @db.VarChar
  is_extracted  Boolean
  uploaded_at   DateTime? @default(dbgenerated("timezone('Asia/Jakarta'::text, now())")) @db.Timestamptz(6)
  date_modified DateTime? @default(dbgenerated("timezone('Asia/Jakarta'::text, now())")) @db.Timestamptz(6)
}

model cv_filter {
  criteria_id     String    @id @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
  gpa_edu_1       Float?
  gpa_edu_2       Float?
  gpa_edu_3       Float?
  univ_edu_1      String?   @db.VarChar
  univ_edu_2      String?   @db.VarChar
  univ_edu_3      String?   @db.VarChar
  major_edu_1     String?   @db.VarChar
  major_edu_2     String?   @db.VarChar
  major_edu_3     String?   @db.VarChar
  domicile        String?   @db.VarChar
  yoe             Int?
  hardskills      String[]  @db.VarChar
  softskills      String[]  @db.VarChar
  certifications  String[]  @db.VarChar
  business_domain String[]  @db.VarChar
  created_at      DateTime? @default(dbgenerated("timezone('Asia/Jakarta'::text, now())")) @db.Timestamptz(6)
}

model cv_matching {
  matching_id     String    @id @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
  profile_id      String?   @db.Uuid
  criteria_id     String?   @db.Uuid
  gpa_edu_1       Boolean?
  gpa_edu_2       Boolean?
  gpa_edu_3       Boolean?
  univ_edu_1      Boolean?
  univ_edu_2      Boolean?
  univ_edu_3      Boolean?
  major_edu_1     Boolean?
  major_edu_2     Boolean?
  major_edu_3     Boolean?
  domicile        Boolean?
  yoe             Boolean?
  hardskills      Boolean?
  softskills      Boolean?
  certifications  Boolean?
  business_domain Boolean?
  created_at      DateTime? @default(dbgenerated("timezone('Asia/Jakarta'::text, now())")) @db.Timestamptz(6)
}

model cv_profile {
  profile_id      String    @id @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
  fullname        String    @db.VarChar
  gpa_edu_1       Float?
  univ_edu_1      String?   @db.VarChar
  major_edu_1     String?   @db.VarChar
  gpa_edu_2       Float?
  univ_edu_2      String?   @db.VarChar
  major_edu_2     String?   @db.VarChar
  gpa_edu_3       Float?
  univ_edu_3      String?   @db.VarChar
  major_edu_3     String?   @db.VarChar
  domicile        String?   @db.VarChar
  yoe             Int?
  hardskills      String[]  @db.VarChar
  softskills      String[]  @db.VarChar
  certifications  String[]  @db.VarChar
  business_domain String[]  @db.VarChar
  filename        String    @unique @db.VarChar
  file_id         String?   @db.Uuid
  created_at      DateTime? @default(dbgenerated("timezone('Asia/Jakarta'::text, now())")) @db.Timestamptz(6)
}

model cv_score {
  scoring_id  String    @id @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
  matching_id String?   @db.Uuid
  score       Int?
  created_at  DateTime? @default(dbgenerated("timezone('Asia/Jakarta'::text, now())")) @db.Timestamptz(6)
}

model cv_tenant {
  tenant_id     String    @id @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
  tenant_name   String    @unique @db.VarChar
  created_at    DateTime? @default(dbgenerated("timezone('Asia/Jakarta'::text, now())")) @db.Timestamptz(6)
  date_modified DateTime? @default(dbgenerated("timezone('Asia/Jakarta'::text, now())")) @db.Timestamptz(6)
  notes         String?   @db.VarChar
}

model cv_user {
  user_id         String    @id @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
  username        String    @unique @db.VarChar
  hashed_password String    @db.VarChar
  email           String    @unique @db.VarChar
  full_name       String    @db.VarChar
  role            String    @db.VarChar
  is_active       Boolean
  tenant_id       String?   @db.Uuid
  created_at      DateTime? @default(dbgenerated("timezone('Asia/Jakarta'::text, now())")) @db.Timestamptz(6)
  date_modified   DateTime? @default(dbgenerated("timezone('Asia/Jakarta'::text, now())")) @db.Timestamptz(6)
  notes           String?   @db.VarChar
}

model cv_weight {
  weight_id       String    @default(dbgenerated("uuid_generate_v4()")) @db.Uuid
  criteria_id     String    @db.Uuid
  gpa_edu_1       Float?
  gpa_edu_2       Float?
  gpa_edu_3       Float?
  univ_edu_1      Float?
  univ_edu_2      Float?
  univ_edu_3      Float?
  major_edu_1     Float?
  major_edu_2     Float?
  major_edu_3     Float?
  domicile        Float?
  yoe             Float?
  hardskills      Float?
  softskills      Float?
  certifications  Float?
  business_domain Float?
  created_at      DateTime? @default(dbgenerated("timezone('Asia/Jakarta'::text, now())")) @db.Timestamptz(6)

  @@id([weight_id, criteria_id])
}