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