psp_api/prisma/schema/admin/permissions.prisma

model PermissionConsumer {
  id                   String               @id @default(ulid())
  consumer_account_id  String               @unique
  business_permissions PermissionBusiness[]
  complex_permissions  PermissionComplex[]
  consumer_account     ConsumerAccount      @relation(fields: [consumer_account_id], references: [id], onDelete: Cascade)
  pos_permissions      PermissionPos[]

  @@map("permission_consumers")
}

model PermissionPos {
  id            String             @id @default(ulid())
  role          POSRole
  pos_id        String
  permission_id String
  permission    PermissionConsumer @relation(fields: [permission_id], references: [id], onDelete: Cascade)
  pos           Pos                @relation(fields: [pos_id], references: [id], onDelete: Cascade)

  @@unique([permission_id, pos_id])
  @@index([pos_id], map: "permission_poses_pos_id_fkey")
  @@map("permission_poses")
}

model PermissionComplex {
  id            String             @id @default(ulid())
  role          ComplexRole
  complex_id    String
  permission_id String
  complex       Complex            @relation(fields: [complex_id], references: [id], onDelete: Cascade)
  permission    PermissionConsumer @relation(fields: [permission_id], references: [id], onDelete: Cascade)

  @@unique([permission_id, complex_id])
  @@index([complex_id], map: "permission_complexes_complex_id_fkey")
  @@map("permission_complexes")
}

model PermissionBusiness {
  id            String             @id @default(ulid())
  role          BusinessRole
  business_id   String
  permission_id String
  business      BusinessActivity   @relation(fields: [business_id], references: [id], onDelete: Cascade)
  permission    PermissionConsumer @relation(fields: [permission_id], references: [id], onDelete: Cascade)

  @@unique([permission_id, business_id])
  @@index([business_id], map: "permission_business_activities_business_id_fkey")
  @@map("permission_business_activities")
}