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

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

model Property {
  id            String   @id @default(cuid())
  title         String
  description   String?
  propertyType  String   // "Agricultural", "Commercial", "Residential"
  
  price         Float
  area          Float
  areaUnit      String   // "Bigha", "Acre", "SqYrd", "SqFt"
  
  // Location Data
  address       String
  city          String?
  district      String?
  state         String?
  latitude      Float
  longitude     Float

  // Media
  photos        String[] @default([])
  videos        String[] @default([])
  documents     String[] @default([])

  // Availability & Features
  status        String   @default("Available") // "Available", "Sold", "Reserved"
  features      String[] @default([]) // e.g. "Road Facing", "Garden Facing"

  isVerified    Boolean  @default(false)
  isTrending    Boolean  @default(false)

  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt
}