aitori-stylist/backend/prisma/schema.prisma

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

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

enum SimulationTaskStatus {
  PROCESSING
  SUCCESSES
  FAILED
}

enum TemplateTaskStatus {
  WAIT
  PROCESSING
  STEP1_SUCCESS
  STEP2_SUCCESS
  FAILED
}

model HairstylistUser {
  id         BigInt   @id @default(autoincrement()) @db.UnsignedBigInt
  username   String   @db.VarChar(50)
  email      String   @db.VarChar(100)
  password   String   @db.VarChar(100)
  createTime DateTime @default(now()) @map("create_time")
  updateTime DateTime @updatedAt @map("update_time")
  isDeleted  Int      @default(0) @map("is_deleted") @db.UnsignedTinyInt

  @@map("hairstylist_user")
}

model CustomerTreatmentRecord {
  id              BigInt   @id @default(autoincrement()) @db.UnsignedBigInt
  customerId      BigInt   @map("customer_id") @db.UnsignedBigInt
  hairstylistId   BigInt   @map("hairstylist_id") @db.UnsignedBigInt
  treatmentTime   DateTime @map("treatment_time")
  treatmentTitle  String   @map("treatment_title") @db.VarChar(200)
  treatmentDetail String?  @map("treatment_detail") @db.Text
  createTime      DateTime @default(now()) @map("create_time")
  updateTime      DateTime @updatedAt @map("update_time")
  isDeleted       Int      @default(0) @map("is_deleted") @db.UnsignedTinyInt

  @@map("customer_treatment_record")
}

model AiHairSimulation {
  id             BigInt   @id @default(autoincrement()) @db.UnsignedBigInt
  customerId     BigInt?  @map("customer_id") @db.UnsignedBigInt
  hairstylistId  BigInt   @map("hairstylist_id") @db.UnsignedBigInt
  originImage    String   @map("origin_image") @db.VarChar(500)
  simulateRemark String?  @map("simulate_remark") @db.Text
  createTime     DateTime @default(now()) @map("create_time")
  updateTime     DateTime @updatedAt @map("update_time")
  isDeleted      Int      @default(0) @map("is_deleted") @db.UnsignedTinyInt

  @@map("ai_hair_simulation")
}

model AiHairSimulationTask {
  id             BigInt               @id @default(autoincrement()) @db.UnsignedBigInt
  simulationId   BigInt               @map("simulation_id") @db.UnsignedBigInt
  templateId     String               @map("template_id") @db.VarChar(100)
  customerId     BigInt?              @map("customer_id") @db.UnsignedBigInt
  taskId         String               @map("task_id") @db.VarChar(200)
  taskStatus     SimulationTaskStatus @map("task_status")
  resultImages   String?              @map("result_images") @db.Text
  taskStartTime  DateTime             @map("task_start_time")
  taskFinishTime DateTime?            @map("task_finish_time")
  errorMsg       String?              @map("error_msg") @db.Text
  createTime     DateTime             @default(now()) @map("create_time")
  updateTime     DateTime             @updatedAt @map("update_time")
  isDeleted      Int                  @default(0) @map("is_deleted") @db.UnsignedTinyInt

  @@map("ai_hair_simulation_task")
}

model HairTemplate {
  id            BigInt   @id @default(autoincrement()) @db.UnsignedBigInt
  templateName  String   @map("template_name") @db.VarChar(100)
  coverUrl      String   @default("") @map("cover_url") @db.VarChar(500)
  status        String   @db.VarChar(32)
  category      String   @db.VarChar(32)
  tags          String   @default("") @db.VarChar(500)
  description   String?  @db.Text
  modelUrl      String   @default("") @map("model_url") @db.VarChar(500)
  clothesUrl    String   @default("") @map("clothes_url") @db.VarChar(500)
  backgroundUrl String   @default("") @map("background_url") @db.VarChar(500)
  refHairUrl    String   @default("") @map("ref_hair_url") @db.VarChar(500)
  createTime    DateTime @default(now()) @map("create_time")
  updateTime    DateTime @updatedAt @map("update_time")
  isDeleted     Int      @default(0) @map("is_deleted") @db.UnsignedTinyInt

  @@map("hair_template")
}

model HairTemplateMakeTask {
  id             BigInt             @id @default(autoincrement()) @db.UnsignedBigInt
  totalTaskId    String             @map("total_task_id") @db.VarChar(200)
  step1TaskId    String             @default("") @map("step1_task_id") @db.VarChar(200)
  step2TaskId    String             @default("") @map("step2_task_id") @db.VarChar(200)
  taskStatus     TemplateTaskStatus @map("task_status")
  templateId     BigInt?            @map("template_id") @db.UnsignedBigInt
  step1Resource  String?            @map("step1_resource") @db.Text
  step2Resource  String?            @map("step2_resource") @db.Text
  refHairUrl     String             @default("") @map("ref_hair_url") @db.VarChar(500)
  modelUrl       String             @default("") @map("model_url") @db.VarChar(500)
  clothesUrl     String             @default("") @map("clothes_url") @db.VarChar(500)
  backgroundUrl  String             @default("") @map("background_url") @db.VarChar(500)
  step1ResultImg String             @default("") @map("step1_result_img") @db.VarChar(500)
  step2ResultImg String             @default("") @map("step2_result_img") @db.VarChar(500)
  createTime     DateTime           @default(now()) @map("create_time")
  updateTime     DateTime           @updatedAt @map("update_time")
  isDeleted      Int                @default(0) @map("is_deleted") @db.UnsignedTinyInt

  @@map("hair_template_make_task")
}