prisma/schema.prisma

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

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

model User {
  id                  Int                  @id @default(autoincrement())
  email               String               @unique
  password            String
  firstName           String
  lastName            String
  phone               String
  createdAt           DateTime             @default(now())
  updatedAt           DateTime             @updatedAt
  instagramConnection InstagramConnection?
  automations         Automation[]
}

model InstagramConnection {
  id              String   @id @default(uuid())
  userId          Int      @unique
  pageId          String   // Facebook Page ID connected
  pageAccessToken String   // Access Token for Graph API calls
  instagramId     String   // Instagram Business Account ID
  instagramName   String?
  createdAt       DateTime @default(now())
  updatedAt       DateTime @updatedAt
  user            User     @relation(fields: [userId], references: [id])
}

model Automation {
  id             String   @id @default(uuid())
  userId         Int
  name           String
  triggerKeyword String   // Comma separated e.g. "price,link"
  replyText      String
  buttonText     String?
  buttonUrl      String?
  isActive       Boolean  @default(true)
  createdAt      DateTime @default(now())
  updatedAt      DateTime @updatedAt
  user           User     @relation(fields: [userId], references: [id])
}