model tele_carte {
  id          Int    @id @default(autoincrement()) @db.UnsignedInt
  delivery_id Int    @unique(map: "delivery_id") @default(0) @db.UnsignedInt
  service_id  Int    @db.UnsignedInt
  channels    String @db.Text
}

model tele_channel {
  id                   Int     @id @default(autoincrement()) @db.UnsignedInt
  proprio              String  @db.VarChar(128)
  poste                String  @db.VarChar(128)
  pack_min             Int     @default(0) @db.UnsignedTinyInt
  pack_redevance       Decimal @default(0.00) @db.Decimal(5, 2)
  pack_prix_vendu      Decimal @default(0.00) @db.Decimal(5, 2)
  carte_percentage     Decimal @db.Decimal(5, 2)
  carte_redevance_min  Decimal @db.Decimal(5, 2)
  carte_prix_vendu     Decimal @db.Decimal(5, 2)
  monthly_min          Decimal @default(0.00) @db.Decimal(5, 2)
  has_penetration_rate Int     @default(0) @db.UnsignedTinyInt
  penetration_actuel   Decimal @default(0.00) @db.Decimal(3, 2)
  is_commercial        Int     @default(0) @db.UnsignedTinyInt
  note                 String  @db.Text
  epgId                Int     @default(0) @db.UnsignedInt
  uptele_no            Int     @db.UnsignedInt
  uptele_code          String  @db.VarChar(32)
  abbr                 String  @db.VarChar(32)
  groupe_id            Int     @default(0) @db.UnsignedInt
  ccsa_packageID       Int     @db.UnsignedInt
  ccsa_desc            String  @db.VarChar(256)
  rapport_bell         Int     @default(0) @db.TinyInt
}

model tele_groupe {
  id         Int    @id @default(autoincrement()) @db.UnsignedInt
  nom        String @db.VarChar(128)
  small_desc String @db.VarChar(128)
}

model tele_network {
  id           Int    @id @default(autoincrement()) @db.UnsignedInt
  network_name String @db.VarChar(128)
  fournisseur  String @db.VarChar(128)
}

model tele_pack {
  id             Int     @id @default(autoincrement())
  product_id     Int     @db.UnsignedInt
  channels       String  @db.Text
  actif          Boolean @default(true)
  ccsa_packageID Int     @db.UnsignedInt
  ccsa_desc      String  @db.VarChar(256)
  rapport_bell   Int     @default(0) @db.TinyInt
  bell_name      String? @db.VarChar(64)
  epgId          Int?    @db.UnsignedInt
}

model tele_penetration {
  id         Int     @id @default(autoincrement()) @db.UnsignedInt
  id_channel Int     @db.UnsignedInt
  percentage Decimal @db.Decimal(3, 2)
  prix       Decimal @db.Decimal(10, 5)
}

model tele_sub_archive {
  id           Int    @id @default(autoincrement())
  date_archive String @db.VarChar(16)
  subs         String @db.Text
}

model tele_wiz {
  id          Int    @id @default(autoincrement()) @db.UnsignedInt
  account_id  Int    @db.UnsignedInt
  delivery_id Int    @db.UnsignedInt
  ticket_id   Int    @db.UnsignedInt
  nb_stb      Int    @db.UnsignedTinyInt
  credit      Int    @db.UnsignedTinyInt
  fbase       Int    @db.UnsignedInt
  fthem       String @db.Text
}

model tv_mac {
  id         Int    @id @default(autoincrement()) @db.UnsignedInt
  service_id Int    @db.UnsignedInt
  mac        String @db.VarChar(12)
}