// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model Users {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  username     String  @unique
  role         String  @default("user")
  emailAddress String?
  firstName    String
  lastName     String
  phoneNumber  String?
  sellerName   String?

  hash     String
  hashedRt String?

  @@map("users")
}

model Products {
  id          Int     @id @default(autoincrement())
  name        String
  gender      String
  category    String
  subcategory String
  color       String?
  season      String?
  usage       String?
  image       String?
  price       Int
  Cart        Cart[]

  @@map("products")
}

model Cart {
  productId Int
  userId    Int
  quantity  Int
  product   Products @relation(fields: [productId], references: [id])

  @@id([productId, userId])
  @@unique([productId, userId])
  @@map("cart")
}