vtorio/prisma/schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model File {
  id        String   @id @default(cuid())
  filename  String
  mimetype  String
  size      Int
  data      Bytes    // PostgreSQL ByteA type for blob storage
  userId    String?   // Kinde user ID that uploaded the file
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model User {
  id        Int      @id @default(autoincrement())
  name      String
  username  String
  email     String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  @@map("users")
}

model LayoutConfiguration {
  id        Int            @id @default(autoincrement())
  name      String
  sections  LayoutSection[]
  imports   Import[]
  createdAt DateTime       @default(now())
  updatedAt DateTime       @updatedAt

  @@map("layout_configurations")
}

model LayoutSection {
  id               Int                  @id @default(autoincrement())
  configurationId  Int
  name             String
  type             String
  sheetName        String
  startingRow      Int?
  endingRow        Int?
  tableName        String
  fields           LayoutSectionField[]
  layoutConfiguration LayoutConfiguration @relation(fields: [configurationId], references: [id], onDelete: Cascade)
  createdAt        DateTime             @default(now())
  updatedAt        DateTime             @updatedAt

  @@map("layout_sections")
}

model LayoutSectionField {
  id                    Int          @id @default(autoincrement())
  layoutSectionId       Int
  cellPosition          String
  name                  String
  dataType              String
  dataTypeFormat        String?
  importTableColumnName String
  importColumnOrderNumber Int
  layoutSection         LayoutSection @relation(fields: [layoutSectionId], references: [id], onDelete: Cascade)
  createdAt             DateTime      @default(now())
  updatedAt             DateTime      @updatedAt

  @@map("layout_section_fields")
}

model Import {
  id         Int      @id @default(autoincrement())
  name       String
  importDate DateTime @default(now())
  layoutId   Int
  layout     LayoutConfiguration @relation(fields: [layoutId], references: [id])
  fileId     String?
  createdAt  DateTime @default(now())
  updatedAt  DateTime @updatedAt

  cintasSummaries      CintasSummary[]
  cintasInstallCalendar CintasInstallCalendar[]

  @@map("imports")
}

model CintasSummary {
  id            Int    @id @default(autoincrement())
  importId      Int
  import        Import  @relation(fields: [importId], references: [id], onDelete: Cascade)
  week          String
  trrTotal      Int
  fourWkAverages Int
  trrPlus4Wk    Int
  powerAdds     Int
  weekId        Int
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt

  @@map("cintas_intall_calendar_summary")
}

model CintasInstallCalendar {
  id                 Int      @id @default(autoincrement())
  importId           Int
  import             Import   @relation(fields: [importId], references: [id], onDelete: Cascade)
  opportunityStatus  String?  @map("opportunity_status") @db.VarChar(4000)
  week               String?  @db.VarChar(4000)
  qtr                String?  @db.VarChar(4000)
  installDate        String?  @map("install_date") @db.VarChar(4000)
  accountName        String?  @map("account_name") @db.VarChar(4000)
  zipCode            String?  @map("zip_code") @db.VarChar(4000)
  soldToNumber       String?  @map("sold_to_number") @db.VarChar(4000)
  sortNumber         String?  @map("sort_number") @db.VarChar(4000)
  type               String?  @db.VarChar(4000)
  route              String?  @db.VarChar(4000)
  day                String?  @db.VarChar(4000)
  trr                String?  @db.VarChar(4000)
  paperChemWk1       String?  @map("paper_chem_wk1") @db.VarChar(4000)
  paperChemWk2       String?  @map("paper_chem_wk2") @db.VarChar(4000)
  paperChemWk3       String?  @map("paper_chem_wk3") @db.VarChar(4000)
  paperChemWk4       String?  @map("paper_chem_wk4") @db.VarChar(4000)
  sanis              String?  @db.VarChar(4000)
  powerAdd           String?  @map("power_add") @db.VarChar(4000)
  createdAt          DateTime @default(now())
  updatedAt          DateTime @updatedAt

  @@map("cintas_install_calendar")
}

model SiteInformation {
  id              Int      @id @default(autoincrement())
  companyName     String   @map("company_name") @db.VarChar(1000)
  phoneNumber     String   @map("phone_number") @db.VarChar(1000)
  facilityName    String   @map("facility_name") @db.VarChar(1000)
  companyContact  String   @map("company_contact") @db.VarChar(1000)
  createdAt       DateTime @default(now())
  updatedAt       DateTime @updatedAt

  @@map("siteinfo_siteinformation")
}

model SiteInfoLeakSummary {
  id              Int      @id @default(autoincrement())
  valveLeaks      String?  @map("valve_leaks") @db.VarChar(1000)
  valveTaggedLeaks String? @map("valve_tagged_leaks") @db.VarChar(1000)
  connectorLeaks  String?  @map("connector_leaks") @db.VarChar(1000)
  connectorTaggedLeaks String? @map("connector_tagged_leaks") @db.VarChar(1000)
  createdAt       DateTime @default(now())
  updatedAt       DateTime @updatedAt

  @@map("siteinfo_leaksummary")
}

model SiteInfoLeakComponents {
  id                      Int      @id @default(autoincrement())
  componentId             String?  @map("component_id") @db.VarChar(1000)
  componentTypeLocation   String?  @map("component_type_location") @db.VarChar(1000)
  monitoringMethod        String?  @map("monitoring_method") @db.VarChar(1000)
  opgalVideoId            String?  @map("opgal_video_id") @db.VarChar(1000)
  successfulRepairDate    String?  @map("successful_repair_date") @db.VarChar(1000)
  createdAt               DateTime @default(now())
  updatedAt               DateTime @updatedAt

  @@map("siteinfo_leakcomponents")
}

model GowFacId {
  id            Int      @id @default(autoincrement())
  importId      Int      @map("import_id")
  corpId        String?  @map("corp_id") @db.VarChar(1000)
  odeqFacId     String?  @map("odeq_fac_id") @db.VarChar(1000)
  odeqFacilityName String? @map("odeq_facility_name") @db.VarChar(1000)
  corpId2       String?  @map("corp_id_2") @db.VarChar(1000)
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt

  @@map("gow_fac_id")
}

model GowData {
  id               Int      @id @default(autoincrement())
  importId         Int      @map("import_id")
  wellName         String?  @map("well_name") @db.VarChar(1000)
  month            String?  @db.VarChar(1000)
  corpId           String?  @db.VarChar(1000)
  completionType   String?  @map("completion_type") @db.VarChar(1000)
  state            String?  @db.VarChar(1000)
  daysOn           String?  @map("days_on") @db.VarChar(1000)
  gasProduction    String?  @map("gas_production") @db.VarChar(1000)
  gasSales         String?  @map("gas_sales") @db.VarChar(1000)
  oilProduction    String?  @map("oil_production") @db.VarChar(1000)
  oilSales         String?  @map("oil_sales") @db.VarChar(1000)
  waterProduction  String?  @map("water_production") @db.VarChar(1000)
  operator         String?  @db.VarChar(1000)
  createdAt        DateTime @default(now())
  updatedAt        DateTime @updatedAt

  @@map("gow_data")
}

model GowCorpRef {
  id                   Int      @id @default(autoincrement())
  importId            Int      @map("import_id")
  wellName            String?  @map("well_name") @db.VarChar(1000)
  apiNo               String?  @map("api_no") @db.VarChar(1000)
  corporateId         String?  @map("corporate_id") @db.VarChar(1000)
  currentWellStatus   String?  @map("current_well_status") @db.VarChar(1000)
  countyParish        String?  @map("county_parish") @db.VarChar(1000)
  state               String?  @db.VarChar(1000)
  area                String?  @db.VarChar(1000)
  completionDate      String?  @map("completion_date") @db.VarChar(1000)
  popFirstProduction  String?  @map("pop_first_production") @db.VarChar(1000)
  operator            String?  @db.VarChar(1000)
  abandonDate         String?  @map("abandon_date") @db.VarChar(1000)
  battery             String?  @db.VarChar(1000)
  commonPadName       String?  @map("common_pad_name") @db.VarChar(1000)
  idWell              String?  @map("id_well") @db.VarChar(1000)
  leaseId             String?  @map("lease_id") @db.VarChar(1000)
  latitude            String?  @db.VarChar(1000)
  longitude           String?  @db.VarChar(1000)
  padCode             String?  @map("pad_code") @db.VarChar(1000)
  padName             String?  @map("pad_name") @db.VarChar(1000)
  permitNumber        String?  @map("permit_number") @db.VarChar(1000)
  wellSubStatus       String?  @map("well_sub_status") @db.VarChar(1000)
  shutInDate          String?  @map("shut_in_date") @db.VarChar(1000)
  createdAt           DateTime @default(now())
  updatedAt           DateTime @updatedAt

  @@map("gow_corp_ref")
}