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
}

enum CustomerContactType {
  LINE
  PHONE
  EMAIL
}

enum CustomerLineStatus {
  LINKED
  UNLINKED
  INVITED
  KEEP
}

enum CustomerHairLength {
  SHORT
  MEDIUM
  LONG
}

enum CustomerFollowStatus {
  NONE
  NEED_FOLLOW_UP
  SENT
}

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 Customer {
  id            BigInt              @id @default(autoincrement()) @db.UnsignedBigInt
  hairstylistId BigInt              @map("hairstylist_id") @db.UnsignedBigInt
  name          String              @db.VarChar(100)
  kana          String              @default("") @db.VarChar(100)
  phone         String              @db.VarChar(32)
  email         String              @default("") @db.VarChar(100)
  birthday      DateTime?           @db.Date
  avatarUrl     String              @map("avatar_url") @db.VarChar(500)
  contactType   CustomerContactType @default(LINE) @map("contact_type")
  lineStatus    CustomerLineStatus? @map("line_status")
  lastVisitDate DateTime?           @map("last_visit_date") @db.Date
  nextVisitDate DateTime?           @map("next_visit_date") @db.Date
  visitCycle    String              @default("") @map("visit_cycle") @db.VarChar(64)
  hairLength    CustomerHairLength? @map("hair_length")
  hairType      String              @default("") @map("hair_type") @db.VarChar(64)
  hairCondition String              @default("") @map("hair_condition") @db.VarChar(255)
  concern       String?             @db.Text
  desiredImage  String?             @map("desired_image") @db.Text
  formulaNote   String?             @map("formula_note") @db.Text
  allergyNote   String?             @map("allergy_note") @db.Text
  privateNote   String?             @map("private_note") @db.Text
  followStatus  CustomerFollowStatus @default(NONE) @map("follow_status")
  followTiming  String              @default("") @map("follow_timing") @db.VarChar(64)
  followMessage String?             @map("follow_message") @db.Text
  createTime    DateTime            @default(now()) @map("create_time")
  updateTime    DateTime            @updatedAt @map("update_time")
  isDeleted     Int                 @default(0) @map("is_deleted") @db.UnsignedTinyInt

  @@index([hairstylistId], map: "idx_hairstylist_id")
  @@index([phone], map: "idx_phone")
  @@index([nextVisitDate], map: "idx_next_visit_date")
  @@index([followStatus], map: "idx_follow_status")
  @@index([hairLength], map: "idx_hair_length")
  @@index([isDeleted], map: "idx_is_deleted")
  @@index([hairstylistId, isDeleted], map: "idx_hairstylist_is_deleted")
  @@map("customer")
}

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")
}