Spaces:

Abhises
/

backlinks-api

Paused

added rejection limit

80917de 5 months ago

4.21 kB

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

datasource db {
  provider = "postgresql"
}

model User {
  id             String        @id @default(uuid())
  name           String
  email          String        @unique
  hashedPassword String?
  role           String        @default("CLIENT") // ADMIN | CLIENT
  createdAt      DateTime      @default(now())

  teamMemberships TeamMember[]
  sentMessages    ChatMessage[]
}

model Workspace {
  id             String   @id @default(uuid())
  domain         String   @unique
  websiteName    String
  description    String
  niche          String?
  country        String?
  language       String?
  monthlyTraffic Int?
  createdAt      DateTime @default(now())

  teamMembers            TeamMember[]
  giverThreads           ExchangeThread[] @relation("GiverWorkspace")
  receiverThreads        ExchangeThread[] @relation("ReceiverWorkspace")
  giverLinkPlacements    LinkPlacement[]  @relation("GiverLinkPlacements")
  receiverLinkPlacements LinkPlacement[]  @relation("ReceiverLinkPlacements")
  notifications          Notification[]
}

model TeamMember {
  id          String    @id @default(uuid())
  userId      String
  workspaceId String
  role        String    // OWNER | EDITOR | VIEWER

  user        User      @relation(fields: [userId], references: [id], onDelete: Cascade)
  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)

  @@unique([userId, workspaceId])
}

model ExchangeThread {
  id                  String    @id @default(uuid())
  giverWorkspaceId    String
  receiverWorkspaceId String
  stage               String    @default("NEW")   // NEW | CHAT | PLACED
  status              String    @default("PENDING") // PENDING | ACCEPTED | REJECTED
  giverAccepted       Boolean   @default(false)
  receiverAccepted    Boolean   @default(false)
  rejectedByWorkspaceId String?
  createdAt           DateTime  @default(now())
  updatedAt           DateTime  @updatedAt

  giverWorkspace      Workspace     @relation("GiverWorkspace", fields: [giverWorkspaceId], references: [id])
  receiverWorkspace   Workspace     @relation("ReceiverWorkspace", fields: [receiverWorkspaceId], references: [id])
  messages            ChatMessage[]
  linkPlacement       LinkPlacement?
}

model ChatMessage {
  id           String   @id @default(uuid())
  threadId     String
  senderUserId String
  messageText  String
  timestamp    DateTime @default(now())

  thread       ExchangeThread @relation(fields: [threadId], references: [id], onDelete: Cascade)
  sender       User           @relation(fields: [senderUserId], references: [id])
}

model LinkPlacement {
  id                  String    @id @default(uuid())
  threadId            String?   @unique
  giverWorkspaceId    String
  receiverWorkspaceId String
  sourceUrl           String
  targetUrl           String
  anchorText          String
  linkType            String    // GUEST_POST | NICHE_EDIT | IMAGE | OTHER
  status              String    @default("LIVE") // LIVE | REMOVED | DEPARTED
  datePlaced          DateTime  @default(now())

  thread              ExchangeThread? @relation(fields: [threadId], references: [id])
  giverWorkspace      Workspace       @relation("GiverLinkPlacements", fields: [giverWorkspaceId], references: [id])
  receiverWorkspace   Workspace       @relation("ReceiverLinkPlacements", fields: [receiverWorkspaceId], references: [id])
}

model AdminNotification {
  id          String   @id @default(uuid())
  title       String
  description String
  createdAt   DateTime @default(now())
}

model Notification {
  id          String   @id @default(uuid())
  workspaceId String
  type        String
  title       String?
  body        String?
  link        String?
  read        Boolean  @default(false)
  createdAt   DateTime @default(now())
  payload     String?  

  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
}

model SystemSettings {
  id              String   @id @default("singleton")
  cronExpression  String   @default("*/10 * * * *")
  matchAmount     Int      @default(2)
  rejectLimit     Int      @default(5)
  updatedAt       DateTime @updatedAt
}

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

	datasource db {
	provider = "postgresql"
	}

	model User {
	id String @id @default(uuid())
	name String
	email String @unique
	hashedPassword String?
	role String @default("CLIENT") // ADMIN \| CLIENT
	createdAt DateTime @default(now())

	teamMemberships TeamMember[]
	sentMessages ChatMessage[]
	}

	model Workspace {
	id String @id @default(uuid())
	domain String @unique
	websiteName String
	description String
	niche String?
	country String?
	language String?
	monthlyTraffic Int?
	createdAt DateTime @default(now())

	teamMembers TeamMember[]
	giverThreads ExchangeThread[] @relation("GiverWorkspace")
	receiverThreads ExchangeThread[] @relation("ReceiverWorkspace")
	giverLinkPlacements LinkPlacement[] @relation("GiverLinkPlacements")
	receiverLinkPlacements LinkPlacement[] @relation("ReceiverLinkPlacements")
	notifications Notification[]
	}

	model TeamMember {
	id String @id @default(uuid())
	userId String
	workspaceId String
	role String // OWNER \| EDITOR \| VIEWER

	user User @relation(fields: [userId], references: [id], onDelete: Cascade)
	workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)

	@@unique([userId, workspaceId])
	}

	model ExchangeThread {
	id String @id @default(uuid())
	giverWorkspaceId String
	receiverWorkspaceId String
	stage String @default("NEW") // NEW \| CHAT \| PLACED
	status String @default("PENDING") // PENDING \| ACCEPTED \| REJECTED
	giverAccepted Boolean @default(false)
	receiverAccepted Boolean @default(false)
	rejectedByWorkspaceId String?
	createdAt DateTime @default(now())
	updatedAt DateTime @updatedAt

	giverWorkspace Workspace @relation("GiverWorkspace", fields: [giverWorkspaceId], references: [id])
	receiverWorkspace Workspace @relation("ReceiverWorkspace", fields: [receiverWorkspaceId], references: [id])
	messages ChatMessage[]
	linkPlacement LinkPlacement?
	}

	model ChatMessage {
	id String @id @default(uuid())
	threadId String
	senderUserId String
	messageText String
	timestamp DateTime @default(now())

	thread ExchangeThread @relation(fields: [threadId], references: [id], onDelete: Cascade)
	sender User @relation(fields: [senderUserId], references: [id])
	}

	model LinkPlacement {
	id String @id @default(uuid())
	threadId String? @unique
	giverWorkspaceId String
	receiverWorkspaceId String
	sourceUrl String
	targetUrl String
	anchorText String
	linkType String // GUEST_POST \| NICHE_EDIT \| IMAGE \| OTHER
	status String @default("LIVE") // LIVE \| REMOVED \| DEPARTED
	datePlaced DateTime @default(now())

	thread ExchangeThread? @relation(fields: [threadId], references: [id])
	giverWorkspace Workspace @relation("GiverLinkPlacements", fields: [giverWorkspaceId], references: [id])
	receiverWorkspace Workspace @relation("ReceiverLinkPlacements", fields: [receiverWorkspaceId], references: [id])
	}

	model AdminNotification {
	id String @id @default(uuid())
	title String
	description String
	createdAt DateTime @default(now())
	}

	model Notification {
	id String @id @default(uuid())
	workspaceId String
	type String
	title String?
	body String?
	link String?
	read Boolean @default(false)
	createdAt DateTime @default(now())
	payload String?

	workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
	}

	model SystemSettings {
	id String @id @default("singleton")
	cronExpression String @default("/10 * * *")
	matchAmount Int @default(2)
	rejectLimit Int @default(5)
	updatedAt DateTime @updatedAt
	}