3 replies

Prisma 2 relations to the same model

Hi, I'm working with Prisma for the first time, and I'm having trouble with a relation:

I have a Transfer and a Deposit model, but the Transfer has a from and a to relation both relating to the Deposit how can I implement this?

schema.prisma:

model User {
    id            String     @id @default(cuid())
    name          String?
    email         String?    @unique
    emailVerified DateTime?
    image         String?
    accounts      Account[]
    sessions      Session[]
    deposits      Deposit[]
    labels        Label[]
    expenses      Expense[]
    revenues      Revenue[]
    transfers     Transfer[]
}

model Deposit {
    id           String       @id @default(cuid())
    uerId        String
    deposit_type depositTypes
    name         String
    description  String?
    balance      Float
    created_at   DateTime     @default(now())
    updated_at   DateTime     @default(now()) @updatedAt
    user         User         @relation(fields: [uerId], references: [id], onDelete: Cascade)
    expenses     Expense[]
    revenues     Revenue[]
    Transfer     Transfer[] // from ???
    Transfer     Transfer[] // to ???
}

model Transfer {
    id              String   @id @default(cuid())
    uerId           String
    from_Deposit_id String
    to_Deposit_id   String
    label_ids       Label[]
    name            String
    description     String?
    amount          Float
    fee             Float
    date            DateTime
    created_at      DateTime @default(now())
    updated_at      DateTime @default(now()) @updatedAt
    user            User     @relation(fields: [uerId], references: [id], onDelete: Cascade)
    from_Deposit    Deposit  @relation(fields: [from_Deposit_id], references: [id])
    to_Deposit      Deposit  @relation(fields: [to_Deposit_id], references: [id])
}

model User {
    id            String     @id @default(cuid())
    name          String?
    email         String?    @unique
    emailVerified DateTime?
    image         String?
    accounts      Account[]
    sessions      Session[]
    deposits      Deposit[]
    labels        Label[]
    expenses      Expense[]
    revenues      Revenue[]
    transfers     Transfer[]
}

model Deposit {
    id           String       @id @default(cuid())
    uerId        String
    deposit_type depositTypes
    name         String
    description  String?
    balance      Float
    created_at   DateTime     @default(now())
    updated_at   DateTime     @default(now()) @updatedAt
    user         User         @relation(fields: [uerId], references: [id], onDelete: Cascade)
    expenses     Expense[]
    revenues     Revenue[]
    Transfer     Transfer[] // from ???
    Transfer     Transfer[] // to ???
}

model Transfer {
    id              String   @id @default(cuid())
    uerId           String
    from_Deposit_id String
    to_Deposit_id   String
    label_ids       Label[]
    name            String
    description     String?
    amount          Float
    fee             Float
    date            DateTime
    created_at      DateTime @default(now())
    updated_at      DateTime @default(now()) @updatedAt
    user            User     @relation(fields: [uerId], references: [id], onDelete: Cascade)
    from_Deposit    Deposit  @relation(fields: [from_Deposit_id], references: [id])
    to_Deposit      Deposit  @relation(fields: [to_Deposit_id], references: [id])
}

model User {
    id            String     @id @default(cuid())
    name          String?
    email         String?    @unique
    emailVerified DateTime?
    image         String?
    accounts      Account[]
    sessions      Session[]
    deposits      Deposit[]
    labels        Label[]
    expenses      Expense[]
    revenues      Revenue[]
    transfers     Transfer[]
}

model Deposit {
    id           String       @id @default(cuid())
    uerId        String
    deposit_type depositTypes
    name         String
    description  String?
    balance      Float
    created_at   DateTime     @default(now())
    updated_at   DateTime     @default(now()) @updatedAt
    user         User         @relation(fields: [uerId], references: [id], onDelete: Cascade)
    expenses     Expense[]
    revenues     Revenue[]
    Transfer     Transfer[] // from ???
    Transfer     Transfer[] // to ???
}

model Transfer {
    id              String   @id @default(cuid())
    uerId           String
    from_Deposit_id String
    to_Deposit_id   String
    label_ids       Label[]
    name            String
    description     String?
    amount          Float
    fee             Float
    date            DateTime
    created_at      DateTime @default(now())
    updated_at      DateTime @default(now()) @updatedAt
    user            User     @relation(fields: [uerId], references: [id], onDelete: Cascade)
    from_Deposit    Deposit  @relation(fields: [from_Deposit_id], references: [id])
    to_Deposit      Deposit  @relation(fields: [to_Deposit_id], references: [id])
}

model User {
    id            String     @id @default(cuid())
    name          String?
    email         String?    @unique
    emailVerified DateTime?
    image         String?
    accounts      Account[]
    sessions      Session[]
    deposits      Deposit[]
    labels        Label[]
    expenses      Expense[]
    revenues      Revenue[]
    transfers     Transfer[]
}

model Deposit {
    id           String       @id @default(cuid())
    uerId        String
    deposit_type depositTypes
    name         String
    description  String?
    balance      Float
    created_at   DateTime     @default(now())
    updated_at   DateTime     @default(now()) @updatedAt
    user         User         @relation(fields: [uerId], references: [id], onDelete: Cascade)
    expenses     Expense[]
    revenues     Revenue[]
    Transfer     Transfer[] // from ???
    Transfer     Transfer[] // to ???
}

model Transfer {
    id              String   @id @default(cuid())
    uerId           String
    from_Deposit_id String
    to_Deposit_id   String
    label_ids       Label[]
    name            String
    description     String?
    amount          Float
    fee             Float
    date            DateTime
    created_at      DateTime @default(now())
    updated_at      DateTime @default(now()) @updatedAt
    user            User     @relation(fields: [uerId], references: [id], onDelete: Cascade)
    from_Deposit    Deposit  @relation(fields: [from_Deposit_id], references: [id])
    to_Deposit      Deposit  @relation(fields: [to_Deposit_id], references: [id])
}

full schema.prisma: https://pastecord.com/upuxegexeg.prisma

Prisma 2 relations to the same model

Similar Threads

Similar Threads

Similar Threads