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

  gowFacIds      GowFacId[]
  gowData        GowData[]
  gowCorpRefs    GowCorpRef[]
  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("importId")
  import           Import   @relation(fields: [importId], references: [id], onDelete: Cascade, onUpdate: Cascade)
  corpId           String?  @map("corp_id") @db.VarChar(4000)
  odeqFacId        String?  @map("odeq_fac_id") @db.VarChar(4000)
  odeqFacilityName String?  @map("odeq_facility_name") @db.VarChar(4000)
  corpId2          String?  @map("corp_id_2") @db.VarChar(4000)
  createdAt        DateTime @default(now()) @map("createdAt")
  updatedAt        DateTime @updatedAt @map("updatedAt")

  @@map("gow_fac_id")
}

model GowData {
  id              Int      @id @default(autoincrement())
  importId        Int      @map("importId")
  import          Import   @relation(fields: [importId], references: [id], onDelete: Cascade, onUpdate: Cascade)
  wellName        String?  @map("well_name") @db.VarChar(4000)
  month           String?  @db.VarChar(4000)
  corpId          String?  @map("corpId") @db.VarChar(4000)
  completionType  String?  @map("completion_type") @db.VarChar(4000)
  state           String?  @db.VarChar(4000)
  daysOn          String?  @map("days_on") @db.VarChar(4000)
  gasProduction   String?  @map("gas_production") @db.VarChar(4000)
  gasSales        String?  @map("gas_sales") @db.VarChar(4000)
  oilProduction   String?  @map("oil_production") @db.VarChar(4000)
  oilSales        String?  @map("oil_sales") @db.VarChar(4000)
  waterProduction String?  @map("water_production") @db.VarChar(4000)
  operator        String?  @db.VarChar(4000)
  createdAt       DateTime @default(now()) @map("createdAt")
  updatedAt       DateTime @updatedAt @map("updatedAt")

  @@map("gow_data")
}

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

  @@map("gow_corp_ref")
}