prisma model
model Users {
userNo Int @id @default(autoincrement()) @map("userNo")
userId String @unique @map("userId")
userPw String @map("userPw")
userName String @map("userName")
Characters Characters[]
@@map("Users")
}
prisma model
model Characters {
characterNo Int @id @unique @default(autoincrement())
userNo Int
characterName String @unique
health Int @default(500)
power Int @default(100)
money Int @default(10000)
user Users @relation(fields: [userNo], references: [userNo], onDelete: Cascade)
inventory Inventories?
equip Equips?
@@map("Characters")
}
prisma model
model Items {
itemNo Int @id @default(autoincrement())
itemName String
itemStat Json
itemPrice Int
@@map("Items")
}
prisma model
model Inventories {
inventoryNo Int @id @unique
items Json
character Characters @relation(fields: [inventoryNo], references: [characterNo])
@@map("Inventories")
}
prisma model
model Equips {
equipNo Int @id @unique
items Json
character Characters @relation(fields: [equipNo], references: [characterNo])
@@map("Equips")
}