﻿// Adicionar apÃ³s o modelo Server, antes do modelo Listing

model Item {
  item_id            Int      @id @default(autoincrement())
  source_table_id    Int
  source_table_name  String   @db.VarChar(50)
  item_name          String   @db.VarChar(255)
  category           String   @db.VarChar(50)
  image_local_path   String?  @db.Text
  image_url          String?  @db.Text
  rarity             String?  @db.VarChar(20)
  level              Int?
  weight             Decimal? @db.Decimal(10, 2)
  slots              Int?
  skill              String?  @db.VarChar(50)
  metadata           Json?    @default("{}")
  created_at         DateTime @default(now())
  updated_at         DateTime @default(now()) @updatedAt

  listings           Listing[] @relation("ListingItem")
  tradeListings      Listing[] @relation("TradeItem")

  @@unique([source_table_name, source_table_id])
  @@index([item_name])
  @@index([category])
  @@index([rarity])
  @@map("items")
}

