/// ************** DEPRECATED ********************************************
model debug {
  id         BigInt  @id @default(autoincrement())
  autor      String? @db.VarChar(32)
  url        String? @db.VarChar(128)
  date_last  BigInt?
  desc       String? @db.MediumText
  note4autor String? @db.MediumText
  note4dev   String? @db.MediumText
  status     String? @db.VarChar(64)
}

model carte_temps {
  id          Int     @id @default(autoincrement()) @db.UnsignedInt
  week        Int     @db.UnsignedTinyInt
  year        Int?    @db.UnsignedInt
  date        BigInt  @db.UnsignedBigInt
  staff_id    BigInt  @db.UnsignedBigInt
  start_am    BigInt? @db.UnsignedBigInt
  end_am      BigInt? @db.UnsignedBigInt
  start_pm    BigInt? @db.UnsignedBigInt
  end_pm      BigInt? @db.UnsignedBigInt
  start_night BigInt? @db.UnsignedBigInt
  end_night   BigInt? @db.UnsignedBigInt
  relais      Float?
  comment     String? @db.Text
  note_int    String? @db.Text
  conge       Int     @default(0) @db.UnsignedTinyInt
  appr        String? @db.VarChar(8)
  appr_dir    String? @db.VarChar(8)

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

model carte_temps_periode {
  id      Int    @id @default(autoincrement()) @db.UnsignedSmallInt
  debut   String @db.VarChar(16)
  fin     String @db.VarChar(16)
  paid    String @db.VarChar(16)
  periode Int    @db.UnsignedTinyInt
  annee   Int    @db.UnsignedSmallInt
}

model banque_heure_staff {
  id       Int     @id @default(autoincrement()) @db.UnsignedInt
  staff_id Int     @db.UnsignedInt
  week     Int     @db.UnsignedTinyInt
  year     Int     @db.UnsignedSmallInt
  sunday   String? @db.VarChar(16)
  heure    Float

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

model hour_bank {
  id              Int     @id @default(autoincrement()) @db.UnsignedInt
  account_id      BigInt  @db.UnsignedBigInt
  remaining_time  Int     @default(0)
  expiration_date BigInt  @default(0) @db.UnsignedBigInt
  note            String? @db.MediumText
  recurrence      Int     @default(0) @db.UnsignedTinyInt
  reset_value     Int     @default(0) @db.UnsignedSmallInt

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

model hour_bank_detail {
  id            Int     @id @default(autoincrement())
  hour_id       Int
  staff_id      BigInt? @db.UnsignedBigInt
  date_orig     BigInt  @db.UnsignedBigInt
  used_time     Int     @default(0) @db.SmallInt
  ticket_id     BigInt? @db.UnsignedBigInt
  working_order String? @db.VarChar(16)
  detail        String? @db.MediumText

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


model test {
  id   Int    @id @default(autoincrement()) @db.UnsignedInt
  text String @db.Text
  c2   Int    @default(1)
}

//this table is for CSS class only, no other uses
model account_memo_template {
  id     Int    @id @default(autoincrement())
  name   String @db.VarChar(32)
  color  String @db.VarChar(6)
  bcolor String @db.VarChar(6)
  border String @default(dbgenerated("(000000)")) @db.VarChar(6)
}

//not used
model notes {
  id         Int    @id @default(autoincrement())
  account_id Int    @db.UnsignedInt
  notes      String @db.MediumText
}

//NOT USED
model email {
  id         Int     @id @default(autoincrement())
  account_id BigInt?
  email      String? @db.VarChar(128)
  password   String? @db.VarChar(128)
}

//not relevant to ticket module
model client_pwd {
  id         Int     @id @default(autoincrement()) @db.UnsignedInt
  account_id Int     @db.UnsignedInt
  date       BigInt  @db.UnsignedBigInt
  uid        String  @db.VarChar(32)
  used       Boolean @default(false)
}


//NO USES FOR TICKETING PURPOSES
model account_profile {
  id                  Int    @id @default(autoincrement()) @db.UnsignedInt
  account_id          Int    @db.UnsignedInt
  profile_id          String @db.VarChar(64)
  address_id          String @db.VarChar(64)
  card_id             String @db.VarChar(64)
  token               String @db.VarChar(32)
  initial_transaction String @db.VarChar(128)
}


//not relevant to ticket module
model deposit_slip {
  id          Int     @id @default(autoincrement())
  customer_id String? @db.VarChar(32)
  name        String? @db.VarChar(512)
  amount      Float   @default(0)
  type        String  @db.VarChar(32)
  desc        String? @db.VarChar(255)
  date        BigInt? @db.UnsignedBigInt
}

//this table display suspended account
model account_suspension {
  id         Int    @id @default(autoincrement()) @db.UnsignedInt
  account_id Int    @unique(map: "account_id") @db.UnsignedInt
  date_start BigInt @db.UnsignedBigInt
  date_end   BigInt @db.UnsignedBigInt
  note       String @db.VarChar(128)
}