psp_api/prisma/schema/shared/customers.prisma

model Customer {
  id             String              @id @default(ulid())
  is_favorite    Boolean?            @default(false)
  type           CustomerType
  created_at     DateTime            @default(now()) @db.Timestamp(0)
  updated_at     DateTime            @updatedAt @db.Timestamp(0)
  deleted_at     DateTime?           @db.Timestamp(0)
  individual     CustomerIndividual?
  legal          CustomerLegal?
  sales_invoices SalesInvoice[]

  @@map("customers")
}

model CustomerIndividual {
  first_name           String?          @db.VarChar(255)
  last_name            String?          @db.VarChar(255)
  national_id          String?          @db.Char(10)
  mobile_number        String?          @db.Char(15)
  postal_code          String?          @db.Char(10)
  economic_code        String?          @db.Char(14)
  customer_id          String           @id
  business_activity_id String
  business_activity    BusinessActivity @relation(fields: [business_activity_id], references: [id])
  customer             Customer         @relation(fields: [customer_id], references: [id], onDelete: Cascade)

  @@unique([business_activity_id, national_id])
  @@unique([business_activity_id, postal_code, national_id])
  @@index([business_activity_id])
  @@map("customer_individuals")
}

model CustomerLegal {
  name                 String?          @db.VarChar(255)
  economic_code        String?          @db.Char(11)
  registration_number  String?          @db.Char(20)
  postal_code          String?          @db.Char(10)
  customer_id          String           @id
  business_activity_id String
  business_activity    BusinessActivity @relation(fields: [business_activity_id], references: [id])
  customer             Customer         @relation(fields: [customer_id], references: [id], onDelete: Cascade)

  @@unique([business_activity_id, economic_code])
  @@unique([business_activity_id, postal_code, registration_number])
  @@index([business_activity_id])
  @@map("customer_legal")
}