Gokor
Gokor
PostsComments
BBuildShip
Created by Gokor on 11/18/2023 in #❓・buildship-help
Looking for paid long-term help with workflow automation
All the data currently is going to be saved in a single table. As we get more data in the future, we can split tables up but it is not necessary for now. Here is the current database structure: 
model documents {
  id                                 String             @id @db.Uuid
  version_code                       VersionCode
  version_number                     Int
  status                             DocumentStatus
  created_on                         DateTime
  repair_order_id                    String
  arrival_odometer_reading           Int
  departure_odometer_reading         Int?
  owner_last_name                    String
  owner_is_claimant                  Boolean?
  estimator                          String
  gross_total                        Float
  net_total                          Float
  supplemental_total                 Float?
  dropoff_phase_status               DropoffPhaseStatus @default(NotStarted)
  dropoff_phase_completed_on         DateTime?
  dropoff_phase_completed_by         String?
  blueprint_phase_alignment          Boolean            @default(false)
  blueprint_phase_prescan            Boolean            @default(false)
  blueprint_phase_insurance_approval Boolean            @default(false)
  blueprint_phase_completed_on       DateTime?
  blueprint_phase_completed_by       String?
  parts_phase_parts_received         Boolean            @default(false)
  parts_phase_completed_on           DateTime?
  parts_phase_completed_by           String?
  bodymech_phase_tasks_completed     Boolean            @default(false)
  bodymech_phase_completed_on        DateTime?
  bodymech_phase_completed_by        String?
  paint_phase_approval_received      Boolean            @default(false)
  paint_phase_completed_on           DateTime?
  paint_phase_completed_by           String?
  reassembly_phase_postscanned       Boolean            @default(false)
  reassembly_phase_completed_on      DateTime?
  reassembly_phase_completed_by      String?
  post_sublet_phase_completed_on     DateTime?
  post_sublet_phase_completed_by     String?
  qc_phase_completed_on              DateTime?
  qc_phase_completed_by              String?
  delivery_phase_completed_on        DateTime?
  delivery_phase_completed_by        String?
  delivery_phase_notes               String?
}
model documents {
  id                                 String             @id @db.Uuid
  version_code                       VersionCode
  version_number                     Int
  status                             DocumentStatus
  created_on                         DateTime
  repair_order_id                    String
  arrival_odometer_reading           Int
  departure_odometer_reading         Int?
  owner_last_name                    String
  owner_is_claimant                  Boolean?
  estimator                          String
  gross_total                        Float
  net_total                          Float
  supplemental_total                 Float?
  dropoff_phase_status               DropoffPhaseStatus @default(NotStarted)
  dropoff_phase_completed_on         DateTime?
  dropoff_phase_completed_by         String?
  blueprint_phase_alignment          Boolean            @default(false)
  blueprint_phase_prescan            Boolean            @default(false)
  blueprint_phase_insurance_approval Boolean            @default(false)
  blueprint_phase_completed_on       DateTime?
  blueprint_phase_completed_by       String?
  parts_phase_parts_received         Boolean            @default(false)
  parts_phase_completed_on           DateTime?
  parts_phase_completed_by           String?
  bodymech_phase_tasks_completed     Boolean            @default(false)
  bodymech_phase_completed_on        DateTime?
  bodymech_phase_completed_by        String?
  paint_phase_approval_received      Boolean            @default(false)
  paint_phase_completed_on           DateTime?
  paint_phase_completed_by           String?
  reassembly_phase_postscanned       Boolean            @default(false)
  reassembly_phase_completed_on      DateTime?
  reassembly_phase_completed_by      String?
  post_sublet_phase_completed_on     DateTime?
  post_sublet_phase_completed_by     String?
  qc_phase_completed_on              DateTime?
  qc_phase_completed_by              String?
  delivery_phase_completed_on        DateTime?
  delivery_phase_completed_by        String?
  delivery_phase_notes               String?
}
10 replies
BBuildShip
Created by Gokor on 11/18/2023 in #❓・buildship-help
Looking for paid long-term help with workflow automation
@harini
10 replies
BBuildShip
Created by Gokor on 11/18/2023 in #❓・buildship-help
Looking for paid long-term help with workflow automation
To give details on my project, I am developing a workflow solution for my automotive repair company. We repair anywhere from 30-40 cars on a weekly basis, and I want to track how long vehicles are spending in each phase of the repair process. Attached is a PDF with more information on the individual phases. Each vehicle is represented by a workfile with an "RO Number", for example one vehicle is RO 4993. The database on appsheets contains all the information about the workfile, and information will be provided either by my company's employee's, or via API that is uploaded directly to the PostgresSQL database (this doesn't involve you). To complete each phase, there are certain requirements; checkboxes, signatures that must be signed, surveys that must be completed, and more.
10 replies
BBuildShip
Created by Gokor on 11/18/2023 in #❓・buildship-help
Looking for paid long-term help with workflow automation
Our workflow is currently: Vercel Backend -> PostgresSQL Database -> Google Appsheet
10 replies
BBuildShip
Created by Gokor on 11/18/2023 in #❓・buildship-help
Looking for paid long-term help with workflow automation
I searched "low code" in the Discord discovery server when joining here haha. I don't need any backend API, although Buildship's tools look very convenient!
10 replies
BBuildShip
Created by Gokor on 11/18/2023 in #❓・buildship-help
Looking for paid long-term help with workflow automation
May I ask what buildship is?
10 replies