psp_api/prisma/schema/admin/license.prisma

model LicenseChargeTransaction {
  id                    String    @id @default(ulid())
  activation_expires_at DateTime
  tracking_code         String    @unique
  purchased_count       Int
  created_at            DateTime  @default(now()) @db.Timestamp(0)
  updated_at            DateTime  @updatedAt @db.Timestamp(0)
  partner_id            String
  partner               Partner   @relation(fields: [partner_id], references: [id])
  licenses              License[]

  @@index([partner_id])
  @@map("license_charged_transactions")
}

model License {
  id                    String                   @id @default(ulid())
  accounts_limit        Int                      @default(2)
  created_at            DateTime                 @default(now()) @db.Timestamp(0)
  updated_at            DateTime                 @updatedAt @db.Timestamp(0)
  charge_transaction_id String
  charge_transaction    LicenseChargeTransaction @relation(fields: [charge_transaction_id], references: [id])
  activation            LicenseActivation?

  @@index([charge_transaction_id])
  @@map("licenses")
}

model LicenseActivation {
  id                   String                     @id @unique @default(ulid())
  starts_at            DateTime
  expires_at           DateTime
  created_at           DateTime                   @default(now()) @db.Timestamp(0)
  updated_at           DateTime                   @updatedAt @db.Timestamp(0)
  license_id           String                     @unique
  business_activity_id String                     @unique
  account_allocations  LicenseAccountAllocation[]
  license_renews       LicenseRenew[]
  business_activity    BusinessActivity           @relation(fields: [business_activity_id], references: [id])
  license              License                    @relation(fields: [license_id], references: [id])

  @@map("licenses_activated")
}

model LicenseRenewChargeTransaction {
  id                    String         @id @default(ulid())
  activation_expires_at DateTime
  tracking_code         String         @unique
  purchased_count       Int
  created_at            DateTime       @default(now()) @db.Timestamp(0)
  updated_at            DateTime       @updatedAt @db.Timestamp(0)
  partner_id            String
  license_renews        LicenseRenew[]
  partner               Partner        @relation(fields: [partner_id], references: [id])

  @@index([partner_id])
  @@map("license_renew_charge_transaction")
}

model LicenseRenew {
  id                    String                        @id @default(ulid())
  expires_at            DateTime
  created_at            DateTime                      @default(now()) @db.Timestamp(0)
  updated_at            DateTime                      @updatedAt @db.Timestamp(0)
  charge_transaction_id String
  activation_id         String?
  activation            LicenseActivation?            @relation(fields: [activation_id], references: [id])
  charge_transaction    LicenseRenewChargeTransaction @relation(fields: [charge_transaction_id], references: [id])

  @@index([activation_id])
  @@index([charge_transaction_id])
  @@map("license_renew")
}

model PartnerAccountQuotaChargeTransaction {
  id                    String                      @id @default(ulid())
  activation_expires_at DateTime
  tracking_code         String                      @unique
  purchased_count       Int
  created_at            DateTime                    @default(now()) @db.Timestamp(0)
  updated_at            DateTime                    @updatedAt @db.Timestamp(0)
  partner_id            String
  partner               Partner                     @relation(fields: [partner_id], references: [id])
  credits               PartnerAccountQuotaCredit[]

  @@index([partner_id])
  @@map("partner_account_quota_charge_transaction")
}

model PartnerAccountQuotaCredit {
  id                    String                                @id @default(ulid())
  created_at            DateTime                              @default(now()) @db.Timestamp(0)
  updated_at            DateTime                              @updatedAt @db.Timestamp(0)
  charge_transaction_id String?
  allocation            LicenseAccountAllocation?
  charge_transaction    PartnerAccountQuotaChargeTransaction? @relation(fields: [charge_transaction_id], references: [id])

  @@index([charge_transaction_id])
  @@map("partner_account_quota_credit")
}

model LicenseAccountAllocation {
  id                    String                     @id @default(ulid())
  created_at            DateTime                   @default(now()) @db.Timestamp(0)
  updated_at            DateTime                   @updatedAt @db.Timestamp(0)
  license_activation_id String?
  account_id            String?                    @unique
  credit_id             String?                    @unique
  account               ConsumerAccount?           @relation(fields: [account_id], references: [id])
  credit                PartnerAccountQuotaCredit? @relation(fields: [credit_id], references: [id])
  license_activation    LicenseActivation?         @relation(fields: [license_activation_id], references: [id])

  @@index([license_activation_id])
  @@map("license_account_allocation")
}