model product {
  id                    Int     @id @default(autoincrement())
  date_orig             BigInt?
  sku                   String? @db.VarChar(32)
  active                Int?    @db.TinyInt
  price                 Float?
  price_recurr_type     Int?    @db.TinyInt
  price_recurr_weekday  Int?
  price_recurr_week     Int?
  price_recurr_schedule Int?    @db.TinyInt
  download_speed        BigInt?
  upload_speed          BigInt?
  night_package         Int     @default(0) @db.TinyInt
  quota_day             BigInt? @db.UnsignedBigInt
  quota_night           BigInt? @db.UnsignedBigInt
  category              Int?    @db.TinyInt
  uniq_charge           Int     @default(0) @db.TinyInt
  commercial            Boolean @default(false)
  portal_hidden         Boolean @default(false)
  inv_keep              Boolean @default(false)
  inv_tag               String? @db.VarChar(255)
  inv_threshold         Int     @default(0) @db.UnsignedInt
  inv_qte               Int     @default(0) @db.UnsignedInt
  emplacement           String  @default(dbgenerated("()")) @db.VarChar(16)
  list_tech             Int     @default(0) @db.UnsignedTinyInt
  type                  Int     @default(0) @db.UnsignedTinyInt
  combo_ready           Int     @default(0) @db.UnsignedTinyInt
  fibre_lineprofile     String? @db.VarChar(8)
  fibre_serviceprofile  String? @db.VarChar(8)

  @@index([sku], map: "sku")
}

model product_cat {
  id          Int     @id @default(autoincrement())
  name        String? @db.VarChar(255)
  notes       String? @db.VarChar(255)
  status      Int?    @db.TinyInt
  num_compte  BigInt?
  combo_dispo Int     @default(0) @db.UnsignedTinyInt
}

model product_format {
  id          BigInt  @id @default(autoincrement())
  date_orig   BigInt?
  name        String? @db.VarChar(255)
  type        Int?    @db.TinyInt
  product_idx String? @db.MediumText
  description String? @db.MediumText
}

model product_fournisseur {
  id              Int     @id @default(autoincrement()) @db.UnsignedInt
  product_id      Int     @db.UnsignedInt
  nom_fournisseur String  @db.VarChar(255)
  prix_us         Boolean @default(false)
  prix_achat      Float   @default(0.00)
  prix_livr       String  @default(dbgenerated("()")) @db.VarChar(16)
  delais_livr     String  @default(dbgenerated("()")) @db.VarChar(128)
  comment         String  @default(dbgenerated("()")) @db.VarChar(128)

  @@index([product_id], map: "product_id")
}

model product_profile {
  id              Int    @id @default(autoincrement()) @db.UnsignedInt
  product_id      Int    @db.UnsignedInt
  device_type     String @db.VarChar(64)
  line_profile    Int    @db.UnsignedInt
  service_profile Int    @db.UnsignedInt
}

model product_speciaux {
  id              BigInt  @id @default(autoincrement())
  product_zone_id BigInt
  product_id      BigInt
  price           Float?
  price_install   Float?
  exp_timestamp   BigInt?
  duree_contrat   Int?    @db.UnsignedTinyInt

  @@index([product_zone_id], map: "product_zone_id")
}

model product_translate {
  id                Int     @id @default(autoincrement())
  product_id        Int?
  language_id       String? @db.VarChar(16)
  name              String? @db.VarChar(512)
  description_short String? @db.LongText
  description_full  String? @db.LongText

  @@index([language_id], map: "language_id")
  @@index([product_id], map: "product_id")
}

model product_zone {
  id          BigInt  @id @default(autoincrement())
  zoneNumber  Int     @db.UnsignedInt
  description String? @db.VarChar(255)

  @@index([zoneNumber], map: "zoneNumber")
}

model product_zone_placemarks {
  id              BigInt @id @default(autoincrement())
  product_zone_id BigInt @db.UnsignedBigInt
  placemarks_id   BigInt @db.UnsignedBigInt

  @@index([placemarks_id], map: "placemarks_id")
}

model inventaire_log {
  id        Int    @id @default(autoincrement()) @db.UnsignedInt
  prod_tag  String @db.VarChar(255)
  staff_id  Int    @db.UnsignedInt
  action    String @db.VarChar(1)
  qte       Int    @db.UnsignedInt
  timestamp String @db.VarChar(10)

  @@index([prod_tag], map: "prod_tag")
}