generator client {
  provider      = "prisma-client-js"
  binaryTargets = ["native", "debian-openssl-1.1.x", "debian-openssl-3.0.x"]
}

datasource db {
  provider = "mysql"
  url      = env("DB_URL")
}

model UserGroup {
  groupId     String    @id @map("group_id") @db.VarChar(32)
  name        String    @map("name") @db.VarChar(512)
  description String?   @map("description") @db.VarChar(512)
  iconImg     String?   @map("icon_img") @db.VarChar(512)
  createdOn   DateTime  @default(now()) @map("created_on") @db.Timestamp(0)
  createdBy   String    @map("created_by") @db.VarChar(32)
  modifiedOn  DateTime? @map("modified_on") @db.Timestamp(0)
  modifiedBy  String?   @map("modified_by") @db.VarChar(32)
  status      String    @map("status") @db.VarChar(64)

  users  User[]
  rights GroupRight[]

  @@map("user_groups")
}

model User {
  userId       String    @id @map("user_id") @db.VarChar(32)
  groupId      String    @map("group_id") @db.VarChar(32)
  position     String    @map("position") @db.VarChar(512)
  fullName     String    @map("full_name") @db.VarChar(512)
  username     String    @unique @map("username") @db.VarChar(512)
  userHash     String    @unique @map("user_hash") @db.VarChar(64)
  emailAddress String    @unique @map("email_address") @db.VarChar(512)
  emailHash    String    @unique @map("email_hash") @db.VarChar(64)
  phoneNumber  String    @unique @map("phone_number") @db.VarChar(512)
  phoneHash    String    @unique @map("phone_hash") @db.VarChar(64)
  asSuper      String    @default("N") @map("as_super") @db.Char(1)
  password     String    @map("password") @db.VarChar(512)
  profileImg   String?   @map("profile_img") @db.VarChar(512)
  createdOn    DateTime  @default(now()) @map("created_on") @db.Timestamp(0)
  createdBy    String    @map("created_by") @db.VarChar(32)
  modifiedOn   DateTime? @map("modified_on") @db.Timestamp(0)
  modifiedBy   String?   @map("modified_by") @db.VarChar(32)
  status       String    @map("status") @db.VarChar(64)

  group UserGroup @relation(fields: [groupId], references: [groupId])

  @@map("user_profiles")
}

model GroupRight {
  groupId    String   @map("group_id") @db.VarChar(32)
  task       String   @map("task") @db.VarChar(512)
  modifiedOn DateTime @default(now()) @map("modified_on") @db.Timestamp(0)
  modifiedBy String   @map("modified_by") @db.VarChar(32)

  group UserGroup @relation(fields: [groupId], references: [groupId])

  @@unique([groupId, task])
  @@map("group_rights")
}

model Server {
  serverId   String    @id @map("server_id") @db.VarChar(32)
  name       String    @unique @map("name") @db.VarChar(512)
  nameHash   String    @unique @map("name_hash") @db.VarChar(64)
  dbAddress  String?   @map("db_address") @db.VarChar(512)
  dbPort     String?   @map("db_port") @db.VarChar(512)
  dbUser     String?   @map("db_user") @db.VarChar(512)
  dbPass     String?   @map("db_pass") @db.VarChar(512)
  createdOn  DateTime  @default(now()) @map("created_on") @db.Timestamp(0)
  createdBy  String    @map("created_by") @db.VarChar(32)
  modifiedOn DateTime? @map("modified_on") @db.Timestamp(0)
  modifiedBy String?   @map("modified_by") @db.VarChar(32)
  status     String    @map("status") @db.VarChar(64)

  @@map("servers")
}

model Client {
  clientId        String    @id @map("client_id") @db.VarChar(32)
  contactName     String    @map("contact_name") @db.VarChar(512)
  contactEmail    String    @map("contact_email") @db.VarChar(512)
  contactPosition String    @map("contact_position") @db.VarChar(512)
  contactPhone    String    @map("contact_phone") @db.VarChar(512)
  name            String    @unique @map("name") @db.VarChar(512)
  nameHash        String    @unique @map("name_hash") @db.VarChar(64)
  industry        String    @map("industry") @db.VarChar(512)
  employees       String    @map("employees") @db.VarChar(512)
  emailAddress    String    @unique @map("email_address") @db.VarChar(512)
  emailHash       String    @unique @map("email_hash") @db.VarChar(64)
  phoneNumber     String    @map("phone_number") @db.VarChar(512)
  physicalAddress String?   @map("physical_address") @db.VarChar(512)
  website         String?   @map("website") @db.VarChar(512)
  country         String    @map("country") @db.VarChar(512)
  devices         String?   @map("devices") @db.VarChar(512)
  logo            String?   @map("logo") @db.VarChar(512)
  hash            String?   @map("hash") @db.VarChar(32)
  createdOn       DateTime  @default(now()) @map("created_on") @db.Timestamp(0)
  createdBy       String    @map("created_by") @db.VarChar(32)
  modifiedOn      DateTime? @map("modified_on") @db.Timestamp(0)
  modifiedBy      String?   @map("modified_by") @db.VarChar(32)
  status          String    @map("status") @db.VarChar(64)

  branches Branch[]
  services ClientService[]

  @@map("clients")
}

model Branch {
  branchId   String    @id @map("branch_id") @db.VarChar(32)
  clientId   String    @map("client_id") @db.VarChar(32)
  branchCode String    @map("branch_code") @db.VarChar(512)
  branch     String    @map("branch") @db.VarChar(512)
  name       String    @map("name") @db.VarChar(512)
  location   String    @map("location") @db.VarChar(512)
  address    String?   @map("address") @db.VarChar(512)
  createdOn  DateTime  @default(now()) @map("created_on") @db.Timestamp(0)
  createdBy  String    @map("created_by") @db.VarChar(32)
  modifiedOn DateTime? @map("modified_on") @db.Timestamp(0)
  modifiedBy String?   @map("modified_by") @db.VarChar(32)
  status     String    @map("status") @db.VarChar(64)

  client Client @relation(fields: [clientId], references: [clientId])

  @@unique([clientId, branchCode])
  @@unique([clientId, branch])
  @@map("branches")
}

model ClientConnection {
  connId     String    @id @map("conn_id") @db.VarChar(32)
  serviceId  String    @map("service_id") @db.VarChar(32)
  branchId   String    @map("branch_id") @db.VarChar(32)
  serverId   String?   @map("server_id") @db.VarChar(32)
  apiUrl     String?   @map("api_url") @db.VarChar(512)
  dbAddress  String    @map("db_address") @db.VarChar(512)
  dbPort     String    @map("db_port") @db.VarChar(512)
  dbName     String    @map("db_name") @db.VarChar(512)
  dbUser     String    @map("db_user") @db.VarChar(512)
  dbPass     String?   @map("db_pass") @db.VarChar(512)
  rootUser   String    @map("root_user") @db.VarChar(512)
  rootPass   String?   @map("root_pass") @db.VarChar(512)
  createdOn  DateTime  @default(now()) @map("created_on") @db.Timestamp(0)
  createdBy  String    @map("created_by") @db.VarChar(32)
  modifiedOn DateTime? @map("modified_on") @db.Timestamp(0)
  modifiedBy String?   @map("modified_by") @db.VarChar(32)
  status     String    @map("status") @db.VarChar(64)

  service ClientService? @relation(fields: [serviceId], references: [serviceId])

  @@unique([serviceId, branchId])
  @@map("client_connections")
}

model ClientService {
  serviceId   String    @id @map("service_id") @db.VarChar(32)
  clientId    String    @map("client_id") @db.VarChar(32)
  licenseCode String    @unique @map("license_code") @db.VarChar(512)
  licenseHash String    @unique @map("license_hash") @db.VarChar(64)
  name        String    @map("name") @db.VarChar(512)
  comments    String?   @map("comments") @db.VarChar(1024)
  fixedBranch String    @map("fixed_branch") @db.VarChar(64)
  validFrom   String?   @map("valid_from") @db.VarChar(512)
  validTo     String?   @map("valid_to") @db.VarChar(512)
  createdOn   DateTime  @default(now()) @map("created_on") @db.Timestamp(0)
  createdBy   String    @map("created_by") @db.VarChar(32)
  modifiedOn  DateTime? @map("modified_on") @db.Timestamp(0)
  modifiedBy  String?   @map("modified_by") @db.VarChar(32)
  status      String    @map("status") @db.VarChar(64)

  client      Client             @relation(fields: [clientId], references: [clientId])
  renewals    Renewal[]
  domains     Domain[]
  connections ClientConnection[]

  @@map("client_services")
}

model Renewal {
  renewalId  String    @id @map("renewal_id") @db.VarChar(32)
  serviceId  String    @map("service_id") @db.VarChar(32)
  startDate  BigInt    @map("start_date")
  endDate    BigInt    @map("end_date")
  comments   String?   @map("comments") @db.VarChar(512)
  paidAmount String?   @map("paid_amount") @db.VarChar(512)
  paidOn     BigInt?   @map("paid_on")
  reference  String?   @map("reference") @db.VarChar(512)
  createdOn  DateTime  @default(now()) @map("created_on") @db.Timestamp(0)
  createdBy  String    @map("created_by") @db.VarChar(32)
  modifiedOn DateTime? @map("modified_on") @db.Timestamp(0)
  modifiedBy String?   @map("modified_by") @db.VarChar(32)
  status     String    @map("status") @db.VarChar(64)

  service ClientService @relation(fields: [serviceId], references: [serviceId])

  @@map("renewals")
}

model Domain {
  domainId   String    @id @map("domain_id") @db.VarChar(32)
  serviceId  String    @map("service_id") @db.VarChar(32)
  domainName String    @unique @map("domain_name") @db.VarChar(512)
  domainHash String    @unique @map("domain_hash") @db.VarChar(64)
  createdOn  DateTime  @default(now()) @map("created_on") @db.Timestamp(0)
  createdBy  String    @map("created_by") @db.VarChar(32)
  modifiedOn DateTime? @map("modified_on") @db.Timestamp(0)
  modifiedBy String?   @map("modified_by") @db.VarChar(32)
  status     String    @map("status") @db.VarChar(64)

  service ClientService @relation(fields: [serviceId], references: [serviceId])

  @@map("client_domains")
}

model ContactUs {
  contactId     String    @id @map("contact_id") @db.VarChar(32)
  serviceType   String    @map("service_type") @db.VarChar(512)
  talk_to       String    @map("talk_to") @db.VarChar(512)
  contactName   String    @map("contact_name") @db.VarChar(512)
  emailAddress  String    @map("email_address") @db.VarChar(512)
  phoneNumber   String    @map("phone_number") @db.VarChar(512)
  companyName   String    @map("company_name") @db.VarChar(512)
  title         String    @map("title") @db.VarChar(512)
  message       String    @map("message") @db.VarChar(2048)
  assignedTo    String?   @map("assigned_to") @db.VarChar(32)
  priority      String    @unique @map("priority") @db.VarChar(64)
  source        String?   @map("source") @db.VarChar(512)
  ipAddress     String?   @map("ip_address") @db.VarChar(512)
  userAgent     String?   @map("user_agent") @db.VarChar(512)
  lastContacted DateTime? @map("last_contacted") @db.Timestamp(0)
  followUpOn    DateTime? @map("follow_up_on") @db.Timestamp(0)
  resolvedOn    DateTime? @map("resolved_on") @db.Timestamp(0)
  createdOn     DateTime  @default(now()) @map("created_on") @db.Timestamp(0)
  modifiedOn    DateTime? @map("modified_on") @db.Timestamp(0)
  modifiedBy    String?   @map("modified_by") @db.VarChar(32)
  status        String    @map("status") @db.VarChar(64)

  activities ContactUsActivity[]

  @@map("contact_us")
}

model ContactUsActivity {
  activityId   String   @id @map("activity_id") @db.VarChar(32)
  contactId    String   @map("contact_id") @db.VarChar(32)
  activityType String   @map("activity_type") @db.VarChar(256)
  comments     String   @map("description") @db.VarChar(2048)
  createdOn    DateTime @default(now()) @map("created_on") @db.Timestamp(0)
  createdBy    String   @map("created_by") @db.VarChar(32)

  contact ContactUs @relation(fields: [contactId], references: [contactId])

  @@map("contact_us_activities")
}

model BookDemo {
  demoId        String    @id @map("demo_id") @db.VarChar(32)
  contactName   String    @map("contact_name") @db.VarChar(512)
  companyName   String    @map("company_name") @db.VarChar(512)
  emailAddress  String    @map("email_address") @db.VarChar(512)
  phoneNumber   String    @map("phone_number") @db.VarChar(512)
  title         String    @map("title") @db.VarChar(512)
  industry      String    @map("industry") @db.VarChar(512)
  employees     String    @map("employees") @db.VarChar(512)
  comments      String    @map("comments") @db.VarChar(2048)
  assignedTo    String?   @map("assigned_to") @db.VarChar(32)
  lastContacted DateTime? @map("last_contacted") @db.Timestamp(0)
  followUpOn    DateTime? @map("follow_up_on") @db.Timestamp(0)
  modifiedOn    DateTime? @map("modified_on") @db.Timestamp(0)
  modifiedBy    String?   @map("modified_by") @db.VarChar(32)
  status        String    @map("status") @db.VarChar(64)

  @@map("demo_bookings")
}
