Untitled

model WorkOrderIntervener {
  user_mail    String
  work_order_id Int

  @@id([user_mail, work_order_id])
  @@map("WorkOrderIntervener")
}

model User {
  mail            String   @id @unique
  nom             String?
  prenom          String?
  telephone       String?
  company         String?
  id_group        Int?
  group           Groupe?  @relation(fields: [id_group], references: [id])
  groupsUpdated   Groupe[] @relation("groupsUpdated")
}

model WorkOrder {
  id                                       Int       @id @default(autoincrement())
  identification_information_comments     String?
  incident_description                     String?
  criticity                                Int
  creation_date                            String
  work_order_number                        Int       @unique
  dead_line                                String?
  intervention_frequency                   Int?
  close_with_active_criticality_4_WO       Boolean?
  ubs_intervener_comment                   String?
  external_intervener_comment              String?
  planned_intervention_start_date          String
  planned_intervention_duration            Int?
  planned_intervention_end_date            String
  work_time_since_last_restart             Int?
  intervention_close_date                  String?
  intervention_close_comment               String?
  power_plant_id                           Int       @map("power_plant_id")
  power_plant                              Centrale  @relation(fields: [power_plant_id], references: [id])
  work_order_type_id                       Int       @map("work_order_type_id")
  work_order_type                          WorkOrderType @relation(fields: [work_order_type_id], references: [id])
  reporter_email                           String?
  reporter                                 User?     @relation(fields: [reporter_email], references: [mail])
  fencing_intervener_mail                  String?
  fencing_intervener                       User?     @relation(fields: [fencing_intervener_mail], references: [mail])
  technician_pilots                        User[]    @relation("WorkOrderTechnicianPilot", references: [mail])
  interveners                              User[]    @relation("WorkOrderIntervener")
}

model Centrale {
  id       Int     @id @default(autoincrement())
  nom      String?
  ville    String?
  adresse  String?
  code_postal String?
  workOrders WorkOrder[]
}

model WorkOrderType {
  id              Int    @id @default(autoincrement())
  type            String
  workOrders      WorkOrder[]
}

model Groupe {
  id         Int    @id @default(autoincrement())
  name       String
  members    User[] @relation(fields: [id], references: [id_group])
  updatedBy  User[] @relation("groupsUpdated")
}