Notes

generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}
model Users {
user_id Int @id @default(autoincrement())
name String
email String @unique
password String
role String
created_at DateTime @default(now())
transactions Transactions[]
}

model Products {
product_id Int @id @default(autoincrement())
name String
category String
price Float
discounted_price Float @default(0.0)
description String
stock Int
created_at DateTime @default(now())
updatedAt DateTime @updatedAt
discounts Discounts[]
transactions Transactions[]
}

model Transactions {
transaction_id Int @id @default(autoincrement())
userId Int
productId Int
quantity Int
total_price Float
transaction_date DateTime @default(now())

user Users @relation(fields: [userId], references: [user_id])
product Products @relation(fields: [productId], references: [product_id])
}

model Discounts {
discount_id Int @id @default(autoincrement())
productId Int
discount_percentage Float
start_date DateTime
end_date DateTime

product Products @relation(fields: [productId], references: [product_id])
}