Files
pagodera/prisma/items-schema-addon.prisma
Evandro Fonseca Junior ab37b477df feat: implement market page with QueryProvider and dynamic listings
- wrap root layout with QueryProvider for React Query
- replace market UnderConstruction placeholder with MarketClient and real data fetching
- implement search, pagination, and sort via search params using getActiveListings
- add necessary client components and queries
- update dependencies (e.g., prisma, pkg-types)
2025-11-05 01:58:03 -03:00

30 lines
960 B
Plaintext

// Adicionar após o modelo Server no schema.prisma
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")
}