model User {
  id             Int            @id @default(autoincrement())
  createdAt      DateTime       @default(now()) @db.DateTime(0)
  updatedAt      DateTime       @default(now()) @db.DateTime(0)
  //relationships
  followedBy     FollowUser[]   @relation("follower")
  following      FollowUser[]   @relation("following")
}

model FollowUser {
  id          Int      @id @default(autoincrement())
  followerId  Int
  followingId Int
  createdAt   DateTime @default(now()) @db.DateTime(0)
  updatedAt   DateTime @default(now()) @db.DateTime(0)
  //relationships
  follower    User     @relation("follower", fields: [followerId], references: [id])
  following   User     @relation("following", fields: [followingId], references: [id])

  // @@id([followerId, followingId])
}