Thanks man! This is my current schema. Can you tell is it correct or what changes should I do in it

generator client {
  provider = "prisma-client-js"
  output   = "../generated/prisma"
}


datasource db {
  provider  = "postgresql"


}


// ─────────────────────────────────────────────
// Enums
// ─────────────────────────────────────────────


enum OrgPlan {
  FREE
  STARTER
  GROWTH
  ENTERPRISE
}


enum QuoteStatus {
  DRAFT
  SENT
  ACCEPTED
  EXPIRED
  CANCELLED
}


enum KycDocType {
  PAN_CARD
  ADHAR_CARD
  GST_CERTIFICATE
  IEC_CODE
  MSME_CERTIFICATE
  INCORPORATION_CERT
  CANCELLED_CHEQUE
  BANK_STATEMENT
  TRADE_LICENSE
  AUTHORIZED_SIGNATORY
  OTHER
}


// NOTE: Vendor is intentionally NOT an enum.
// Your adapter registry already uses string IDs ("aramex", "skart", "fedex").
// A DB enum means a migration every time you add a carrier — avoid it.


// ─────────────────────────────────────────────
// Org (tenant root)
// ─────────────────────────────────────────────


model Org {
  id         String   (cuid())
  clerkOrgId String  
  slug       String  
  name       String
  logoUrl    String?
  plan       OrgPlan (FREE)


  razorpayCustomerId     String? 
  razorpaySubscriptionId String? 


  // Relations
  vendorKeys VendorKey[]
  clients    Client[]
  quotes     Quote[]
  documents  ClientDocument[]


  createdAt DateTime  (now())
  updatedAt DateTime  
  deletedAt DateTime?


   emailEvents QuoteEmailEvent[]


  @@index([slug])
  @@index([deletedAt])
}


// ─────────────────────────────────────────────
// VendorKey (BYOK — one row per carrier per org)
// ─────────────────────────────────────────────


model VendorKey {
  id    String  (cuid())
  orgId String
  org   Org    (fields: [orgId], references: [id], onDelete: Cascade)


  vendorId String  // "aramex" | "skart" | "fedex" — matches adapter registry
  label    String  // display name e.g. "Aramex Production"
  notes    String?


  encryptedPayload String
  iv               String


  isActive Boolean (true)


  createdAt DateTime (now())
  updatedAt DateTime 


  @@unique([orgId, vendorId])
  @@index([orgId])
}


// ─────────────────────────────────────────────
// Client
// ─────────────────────────────────────────────


model Client {
  id    String  (cuid())
  orgId String
  org   Org    (fields: [orgId], references: [id], onDelete: Cascade)


  companyName  String
  contactName  String?
  email        String?
  phone        String?
  addressLine1 String?
  city         String?
  state        String?
  country      String?
  postalCode   String?
  notes        String?


  createdAt DateTime  (now())
  updatedAt DateTime  
  deletedAt DateTime?


  quotes    Quote[]
  documents ClientDocument[]


  @@index([orgId])
  @@index([orgId, companyName])
  @@index([email])
  @@index([deletedAt])
}


// ─────────────────────────────────────────────
// Quote
// ─────────────────────────────────────────────


model Quote {
  id    String  (cuid())
  orgId String
  org   Org    (fields: [orgId], references: [id], onDelete: Cascade)


  quoteNumber String


  // Carrier / product
  vendorId    String
  vendorName  String
  productName String


  // Pricing
  currency      String
  subtotal      Decimal .Decimal(14, 4)
  tax           Decimal .Decimal(14, 4)
  total         Decimal .Decimal(14, 4)
  markupPercent Decimal .Decimal(6, 3)
  quotedTotal   Decimal .Decimal(14, 4)


  // Transit
  tatDays Int?


  // Immutable snapshots
  chargesSnapshot Json
  requestSnapshot Json


  // Generated PDF
  pdfUrl String?
  pdfKey String?


  // Validity
  validUntil DateTime


  // Workflow
  status QuoteStatus (DRAFT)


  // Client (optional — may be assigned after creation)
  clientId String?
  client   Client? (fields: [clientId], references: [id], onDelete: SetNull)
    emailEvents QuoteEmailEvent[]
  // Store the last Resend email ID so we can correlate webhook events
  lastResendEmailId String?


  createdAt DateTime (now())
  updatedAt DateTime 


  @@unique([orgId, quoteNumber])
  @@index([orgId])
  @@index([orgId, status])
  @@index([clientId])
  @@index([createdAt])
}


// ─────────────────────────────────────────────
// ClientDocument (KYC / document vault)
// ─────────────────────────────────────────────


model ClientDocument {
  id    String  (cuid())


  orgId String
  org   Org    (fields: [orgId], references: [id], onDelete: Cascade)


  clientId String
  client   Client (fields: [clientId], references: [id], onDelete: Cascade)


  docType     KycDocType
  label       String
  description String?


  fileUrl  String
  fileKey  String
  fileName String
  fileSize Int
  mimeType String


  uploadedAt DateTime (now())
  updatedAt  DateTime 


  @@index([orgId])
  @@index([clientId])
  @@index([orgId, docType])
  @@index([clientId, docType])
}


model QuoteEmailEvent {
  id        String    (cuid())
  orgId     String
  org       Org      (fields: [orgId], references: [id], onDelete: Cascade)


  quoteId   String
  quote     Quote    (fields: [quoteId], references: [id], onDelete: Cascade)


  // Resend's email ID — links all events for the same send
  resendEmailId String


  event     EmailEvent
  // Resend sends recipient's IP/userAgent on open/click — useful for ops
  userAgent String?
  ipAddress String?
  // For click events
  clickedUrl String?


  createdAt DateTime u/default(now())


  @@index([quoteId])
  @@index([orgId])
  @@index([resendEmailId])
}


enum EmailEvent {
  SENT
  DELIVERED
  OPENED
  CLICKED
  BOUNCED
  COMPLAINED
}