BINARY

VARBINARY

TIMESTAMP

JSON

json-bigint

nodejs-snowflake

model task_type {
  id          String  @id @default(uuid())
  name        String     @unique
  tasks       task[]
  notes       String?
  order       Int         @default(0)
  parent_id   String?
  parent      task_type?  @relation(name: "parent", fields: [parent_id], references: [id])
  child_tasks task_type[] @relation(name: "parent")
  deleted     Boolean     @default(false)
  interval    Int         @default(0)
}

model task {
  id           String       @id @default(uuid())
  type         task_type    @relation(fields: [task_type_id], references: [id])
  task_type_id String
  task_events  task_event[]
  notes        String?
  data         Json?
  createdAt    DateTime    @default(now())
  last_work_done  DateTime?
  completedAt  DateTime?
  status       String      @default("started")
  parent_task  task?       @relation(name: "parent", fields: [parent_task_id], references: [id])
  parent_task_id String?
  child_tasks  task[]      @relation(name: "parent")
}

orderBy

.findFirst({
 where: {
    id:  1
  }, {
   select: {
     something: {...},
     somethingElse: {...}
    }
  }
})

orderBy

if (role === Role.admin)
    user = await prisma.user.findUnique({
      where: {
        id,
      },
      select: defaultAdminSelect,
    });
  if (role === Role.student)
    user = await prisma.user.findUnique({
      where: {
        id,
      },
      select: defaultStudentSelect,
    });

__dirname

const members = await prisma.teamMember.findMany({
where: {
      teamId,
    },
  });

  const membersInfo = [];

  members.map(async (e) => {
    const response = await prisma.user.findFirst({
      where: {
        id: e.userId,
      },
    });
    if(response) membersInfo.push(response);
  });

Hello everyone

Hereby I am stuck at one place 

there is 1 model like below

model Channel {
  user_id       Int
  user          User           @relation("user_channels", fields: [user_id], references: [id])
  provider_id   Int
  provider      User           @relation("provider_channels", fields: [provider_id], references: [id])
  created_at    DateTime       @default(now())
  updated_at    DateTime       @updatedAt
  deleted_at    DateTime?
  conversations Conversation[]

  @@id([user_id, provider_id], name: "user_provider_id")
  @@map("channels")
}

now there is a model named Conversation

Conversation {
 channel_id Int
 channel  @relation(fields: [channel_id], references: [id])
...
}

But I am not getting what to write or define relation here as there is no id in channel id

have any idea ?

thank you

Error 429: Quota exceeded for quota metric 'Queries' and limit 'Queries per minute per user' of service '<http://sqladmin.googleapis.com|sqladmin.googleapis.com>' for consumer

export const GroupInvitationStatus: {
  Pending: 'Pending',
  Accepted: 'Accepted',
  Declined: 'Declined'
};

export type GroupInvitationStatus = (typeof GroupInvitationStatus)[keyof typeof GroupInvitationStatus]

import { PrismaClient } from '@prisma/client';

export let prisma: PrismaClient;

if (typeof window === 'undefined') {
  if (process.env['NODE_ENV'] === 'production') {
    prisma = new PrismaClient();
  } else {
    /* eslint-disable @typescript-eslint/ban-ts-comment */
    // @ts-ignore
    if (!global.prisma) {
      // @ts-ignore
      global.prisma = new PrismaClient();
    }
    // @ts-ignore
    prisma = global.prisma;
  }
}

declare global {
  var prisma: PrismaClient
}

Duplicate declaration "prisma" error

type UnwrapTuple<Tuple extends readonly unknown[]>