model project {
  id           Int     @id @default(autoincrement()) @db.UnsignedInt
  name         String  @db.VarChar(128)
  status       String  @db.VarChar(16)
  desc         String? @db.Text
  date_start   BigInt? @db.UnsignedBigInt
  date_end     BigInt? @db.UnsignedBigInt
  manager_name String? @db.VarChar(64)
}

model project_cmd {
  id         Int     @id @default(autoincrement()) @db.UnsignedInt
  project_id Int     @db.UnsignedInt
  date       BigInt  @db.UnsignedBigInt
  vendeur    String? @db.VarChar(128)
  no_cmd     String? @db.VarChar(64)
  po         String? @db.VarChar(32)
  staff_id   Int     @default(4667) @db.UnsignedInt

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

model project_cmd_item {
  id         Int     @id @default(autoincrement()) @db.UnsignedInt
  cmd_id     Int     @db.UnsignedInt
  product_id Int     @default(0) @db.UnsignedInt
  desc       String  @db.Text
  qte        Float
  price      Float
  usd        Boolean @default(false)
  recu       Int     @default(0) @db.TinyInt
  qte_recu   Float   @default(0)
  date_recu  String? @db.VarChar(64)
  comment    String? @db.VarChar(128)
  eta        String? @db.VarChar(10)
  status     Int     @default(0) @db.UnsignedTinyInt

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

model project_manager_cat {
  id         Int    @id @default(autoincrement()) @db.UnsignedInt
  pos        Int    @db.UnsignedTinyInt
  name       String @db.VarChar(32)
  color      String @default(dbgenerated("(ffffff)")) @db.VarChar(7)
  text_color String @default(dbgenerated("(#000000)")) @db.VarChar(7)
}

model project_manager_checklist {
  id        Int    @id @default(autoincrement()) @db.UnsignedInt
  task_id   Int    @db.UnsignedInt
  ticket_id Int    @db.UnsignedInt
  desc      String @db.VarChar(128)
  poids     Int    @default(1) @db.UnsignedTinyInt
  done      Int    @default(0) @db.TinyInt

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

model project_manager_comment {
  id       Int    @id @default(autoincrement()) @db.UnsignedInt
  task_id  Int    @db.UnsignedInt
  comment  String @db.Text
  staff_id Int    @db.UnsignedInt
  date     String @db.VarChar(16)
  unread   String @db.Text

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

model project_manager_task {
  id             Int     @id @default(autoincrement()) @db.UnsignedInt
  category_id    Int     @db.UnsignedInt
  pos            Int     @db.UnsignedTinyInt
  titre          String  @db.VarChar(255)
  color          String  @default(dbgenerated("(#ffffff)")) @db.VarChar(7)
  text_color     String  @default(dbgenerated("(#000000)")) @db.VarChar(7)
  desc           String  @db.Text
  ticket_id      String? @db.VarChar(16)
  date_start     String? @db.VarChar(16)
  date_deadline  String? @db.VarChar(16)
  deadline_watch Int     @default(1) @db.UnsignedTinyInt
  assign_staff   String? @db.Text
  priority       Int     @default(0) @db.UnsignedTinyInt
  done           Boolean @default(false)
  create_by      Int     @db.UnsignedInt
  date_creation  String? @db.VarChar(16)
  date_update    String? @db.VarChar(16)

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