psp_api/prisma/schema/good_service/sku.prisma

model StockKeepingUnits {
  id          String   @id @default(ulid())
  code        String   @unique
  name        String
  VAT         Decimal  @db.Decimal(5, 2)
  is_public   Boolean  @default(true)
  is_domestic Boolean  @default(false)
  guild_id    String
  created_at  DateTime @default(now()) @db.Timestamp(0)
  updated_at  DateTime @updatedAt @db.Timestamp(0)
  goods       Good[]
  guild       Guild    @relation(fields: [guild_id], references: [id])

  @@index([code])
  @@index([guild_id], map: "stock_keeping_units_guild_id_fkey")
  @@map("stock_keeping_units")
}