KPO_HDBMS

Tables (6)

Group_measure (Untitled)

  • ID — Serial — Primary key — NOT NULL
  • group_name — varchar — Primary key — NOT NULL
  • pcb_id (pcb_id2) — Foreign key → total_measure.pcb_id — NOT NULL
  • date (date2) — Foreign key → total_measure.date — NOT NULL
  • time (time2) — Foreign key → total_measure.time — NOT NULL
  • idx — Foreign key → total_measure.idx — NOT NULL
  • area_usl
  • height_usl
  • volume_usl
  • height_lsl
  • volume_lsl
  • offset_rmse_x
  • offset_rmse_y
  • offset_rmse_xy
  • area_cpk
  • area_cp
  • area_avg
  • area_std
  • area_min
  • area_max
  • height_cpk
  • height_std
  • height_min
  • height_max
  • height_cp
  • volume_cpk
  • volume_cp
  • volume_avg
  • volume_std
  • volume_min
  • volume_max
  • priority

base_job (Untitled4)

  • id — Foreign key → task_uuid.idx — NOT NULL
  • cambarcode — json
  • coplanarity — json
  • fiducialInfo — json
  • land — json
  • shape — json
  • undefinedshape — json

pad_grouping (Untitled5)

  • group_type — Primary key — NOT NULL
  • id — Foreign key → task_uuid.idx — NOT NULL
  • pad_group — json

task_uuid (Untitled3)

  • idx — Primary key — NOT NULL
  • DB_UUID — str
  • taskdir_name
  • PCBlenth
  • PCBMaskHeight
  • PCBName
  • Land_cd
  • Vender_name
  • createat

total_measure (Untitled2)

  • pcb_id — Primary key — NOT NULL
  • date — Primary key — NOT NULL
  • time — Primary key — NOT NULL
  • idx — Foreign key → task_uuid.idx — NOT NULL
  • lane
  • task_id
  • area_usl
  • area_lsl
  • height_usl
  • height_lsl
  • volume_usl
  • offset_rmse_x
  • offset_rmse_y
  • area_cpk
  • area_cp
  • area_avg
  • area_std
  • area_min
  • area_max
  • height_cpk
  • height_cp
  • height_avg
  • height_std
  • height_min
  • height_max
  • volume_cpk
  • volume_cp
  • volume_std
  • volume_avg
  • volume_min
  • volume_max
  • volume_cv
  • integrated_cpk
  • integrated_cp
  • volume_cpmk
  • volume_weightcpk
  • mse
  • cntdefect1-12
  • cntwarning1-12
  • cntdefect
  • cntwarning
  • spi_barcode
  • print_barcode
  • printing_time
  • direction
  • cleaning_cycle
  • cleaning_age
  • trigger_anomaly
  • trigger_status
  • po_retry_notification
  • offset_x
  • offset_y
  • offset_t
  • printing_speed
  • separation_speed
  • temperature
  • humidity
  • ticket

trial_optimization

  • trial — Primary key — NOT NULL
  • id — Foreign key → task_uuid.idx — NOT NULL
  • task_id
  • job_name
  • lane
  • offset_x_unit
  • offset_y_unit
  • offset_t_unit
  • ps_unit
  • pp_unit
  • ss_unit
  • selected
  • pp_lower_limit
  • pp_upper_limit
  • ps_lower_limit
  • ps_upper_limit
  • ss_lower_limit
  • ss_upper_limit
  • p_pp_lower_limit_F2R
  • p_pp_lower_limit_R2F
  • p_pp_upper_limit_F2R
  • p_pp_upper_limit_R2F
  • p_ps_lower_limit_F2R
  • p_ps_lower_limit_R2F
  • p_ps_upper_limit_F2R
  • p_ps_upper_limit_R2F
  • p_ss_lower_limit_F2R
  • p_ss_lower_limit_R2F
  • p_ss_upper_limit_F2R
  • p_ss_upper_limit_R2F
  • start_pcb_id
  • end_pcb_id
  • start_date
  • end_date
  • start_time
  • is_envchanged
  • is_kpogroup (is_kpo_group)
  • is_autogroup
  • kpogroup_uuid
  • autogroup_uuid
  • search_objective
  • selected_po_algorithm
  • group_selected
  • env
  • count
  • ticket