psp_api/prisma/schema/shared/service.prisma

model Service {
  id                  String             @id @default(ulid())
  name                String             @db.VarChar(255)
  description         String?            @db.Text
  sku                 String             @unique @db.VarChar(100)
  local_sku           String?            @unique @db.VarChar(100)
  barcode             String?            @unique @db.VarChar(100)
  created_at          DateTime           @default(now()) @db.Timestamp(0)
  updated_at          DateTime           @updatedAt @db.Timestamp(0)
  deleted_at          DateTime?          @db.Timestamp(0)
  category_id         String?
  base_sale_price     Decimal            @default(0) @db.Decimal(15, 0)
  account_id          String
  complex_id          String
  sales_invoice_items SalesInvoiceItem[]
  category            ServiceCategory?   @relation(fields: [category_id], references: [id])

  @@index([category_id])
  @@map("services")
}

model ServiceCategory {
  id          String    @id @default(ulid())
  name        String    @db.VarChar(100)
  description String?   @db.Text
  image_url   String?   @db.VarChar(255)
  account_id  String
  complex_id  String
  created_at  DateTime  @default(now()) @db.Timestamp(0)
  updated_at  DateTime  @updatedAt @db.Timestamp(0)
  deleted_at  DateTime? @db.Timestamp(0)
  services    Service[]

  @@map("service_categories")
}