model fibre {
  id                   Int     @id @default(autoincrement()) @db.UnsignedInt
  terrain              String  @db.VarChar(16)
  rue                  String  @db.VarChar(128)
  ville                String  @db.VarChar(128)
  zip                  String  @default(dbgenerated("()")) @db.VarChar(7)
  ontid                Int?    @db.UnsignedInt
  sn                   String? @db.VarChar(32)
  tech                 Int     @default(2) @db.UnsignedSmallInt
  info_connect         String  @default(dbgenerated("(172.17.0.2)")) @db.VarChar(64)
  frame                Int?    @db.UnsignedTinyInt
  slot                 Int?    @db.UnsignedTinyInt
  port                 Int?    @db.UnsignedTinyInt
  vlan_manage          Int?    @db.UnsignedInt
  vlan_internet        Int?    @db.UnsignedInt
  vlan_telephone       Int?    @db.UnsignedInt
  vlan_tele            Int?    @db.UnsignedInt
  manage_service_id    Int?    @db.UnsignedInt
  internet_service_id  Int?    @db.UnsignedInt
  telephone_service_id Int?    @db.UnsignedInt
  tele_service_id      Int?    @db.UnsignedInt
  service_id           Int?    @db.UnsignedInt
  nb_drop              Int     @default(0) @db.UnsignedInt
  placemarks_id        BigInt? @db.UnsignedBigInt
  appartements_id      BigInt? @db.UnsignedBigInt
  latitude             Float?  @db.Float
  longitude            Float?  @db.Float
  boitier_pas_install  Int?    @db.UnsignedTinyInt
  description          String? @db.VarChar(50)
  suite                Int     @default(0) @db.UnsignedTinyInt
  distance             Int?    @db.UnsignedInt
  nb_portees           Int?    @db.UnsignedTinyInt

  @@index([appartements_id, sn], map: "appartements_id")
  @@index([info_connect, appartements_id, sn, slot, port], map: "info_connect")
  @@index([placemarks_id, sn], map: "placemarks_id")
  @@index([service_id], map: "service_id")
}

model fibre_olt {
  id          Int    @id @default(autoincrement()) @db.UnsignedInt
  tech        Int    @db.UnsignedSmallInt
  ip          String @db.VarChar(64)
  description String @db.VarChar(128)
}

model fibre_service_port {
  id              Int @id @default(autoincrement()) @db.UnsignedInt
  last_service_id Int @db.UnsignedInt
}

model fibre_suivi {
  id          Int     @id @default(autoincrement()) @db.UnsignedInt
  customer_id String? @db.VarChar(32)
  first_name  String  @db.VarChar(64)
  last_name   String  @db.VarChar(64)
  address     String  @db.VarChar(128)
  city        String  @db.VarChar(128)
  zip         String  @db.VarChar(7)
  phone       String  @db.VarChar(10)
  email       String? @db.VarChar(64)
  longitude   Decimal @db.Decimal(12, 7)
  latitude    Decimal @db.Decimal(12, 7)
  called      Int     @default(-1) @db.TinyInt
  create_by   Int     @default(0) @db.UnsignedInt
  note        String  @db.Text
}

model fibre_tech {
  id          Int    @id @default(autoincrement()) @db.UnsignedInt
  description String @db.VarChar(128)
}

model fibre_videotron {
  id        Int    @id @default(autoincrement()) @db.UnsignedInt
  date      String @db.VarChar(16)
  download  String @default(dbgenerated("(0)")) @db.VarChar(128)
  upload    String @default(dbgenerated("(0)")) @db.VarChar(128)
  ethernet  String @default(dbgenerated("()")) @db.VarChar(64)
  interface String @default(dbgenerated("()")) @db.VarChar(128)
}