weldbeing I WPQ

Tables (21)

company (회사)

  • id (ID) — Primary key — NOT NULL

docs_info (문서)

  • Key — Primary key — NOT NULL

user (사용자)

  • id (ID) — Primary key — NOT NULL

welder (용접사 정보)

  • id — Primary key — NOT NULL
  • company_id (company id) — Foreign key → company.id — NOT NULL
  • user_id (user id) — Foreign key → user.id — NOT NULL
  • photo_file_id (용접사 사진 파일 id)
  • name (용접사 이름)
  • birth (생년월일)
  • gender (성별)
  • phone (연락처)
  • email (이메일)
  • company_name (기업명)
  • division (부서)
  • tenure_start_date (재직기간(시작))
  • tenure_end_date (재직기간(끝))
  • welding_code_cd (ASME/AWS/ISO)
  • welder_symbol (용접사 id)

wpq (WPQ/WOPQ)

  • id — Primary key — NOT NULL
  • welder_id (welder id) — Foreign key → welder.id — NOT NULL
  • docs_info_id (wps id) — Foreign key → docs_info.Key — NOT NULL
  • wpq_plan_id (wpq_plan id) — Foreign key → wpq_plan.id — NOT NULL
  • record_no (문서번호)
  • type (wpq or wopq)
  • standard_cd (standard code)
  • unit_cd (unit code)
  • writing_status_cd (작성상태)
  • qualified_method_cd (인정시험 종류)
  • weld_type_cd (weld_type code)
  • is_backing (backing 유무)
  • visual_test_result_cd (visual_examination)

wpq_approval (WPQ 승인 내역)

  • id — Primary key — NOT NULL
  • wpq_id (wpq id) — Foreign key → wpq.id — NOT NULL
  • approval_type (승인 타입)
  • approval_date (승인 일자)
  • user_name (승인자)
  • sign_file_id (사인 파일 id)

wpq_base_metal (WPQ 모재)

  • id — Primary key — NOT NULL
  • wpq_id (wpq id) — Foreign key → wpq.id — NOT NULL
  • base_material_id (base_material id)
  • similar_type (0, 1, 2)
  • product_type_cd (plate or pipe)
  • thickness
  • diameter

wpq_certification_history (WPQ 자격 내역)

  • id — Primary key — NOT NULL
  • wpq_id (wpq id) — Foreign key → wpq.id — NOT NULL
  • wpq_certification_type_cd (WPQ 자격 승인 타입)
  • start_date (자격 시작일)
  • end_date (자격 종료일)
  • proof_file_id (증빙 파일 id)

wpq_note (WPQ note)

  • id — Primary key — NOT NULL
  • wpq_id (wpq id) — Foreign key → wpq.id — NOT NULL
  • wpq_section_cd
  • note

wpq_plan (WPQ Plan)

  • id — Primary key — NOT NULL
  • docs_info_id (wps id) — Foreign key → docs_info.Key — NOT NULL
  • record_no (문서번호)
  • is_observe (입회여부)
  • standard_cd (standard code)
  • unit_cd (unit code)
  • writing_status_cd (작성상태)

wpq_plan_approval (WPQ Plan 승인 내역)

  • id — Primary key — NOT NULL
  • wpq_plan_id (wpq_plan id) — Foreign key → wpq_plan.id — NOT NULL
  • approval_type (승인 타입)
  • approval_date (승인 일자)
  • user_name (승인자)
  • sign_file_id (사인 파일 id)

wpq_plan_base_metal (WPQ Plan 테이블 모재)

  • id — Primary key — NOT NULL
  • wpq_plan_table_id (wpq_plan_table id) — Foreign key → wpq_plan_table.id — NOT NULL
  • base_material_id (base_material id)
  • similar_type (0, 1, 2)
  • product_type_cd (plate or pipe)
  • thickness (t)
  • width (w) — l
  • length (l)

wpq_plan_date (WPQ Plan date)

  • id — Primary key — NOT NULL
  • wpq_plan_id (wpq_plan id) — Foreign key → wpq_plan.id — NOT NULL
  • wpqt_date (WPQT 실행일)

wpq_plan_note (WPQ Plan note)

  • id — Primary key — NOT NULL
  • wpq_plan_id (wpq_plan id) — Foreign key → wpq_plan.id — NOT NULL
  • note

wpq_plan_process (WPQ Plan 테이블 Process)

  • id — Primary key — NOT NULL
  • wpq_plan_table_id (wpq_plan_table id) — Foreign key → wpq_plan_table.id — NOT NULL
  • process_cd (process type)

wpq_plan_process_position (WPQ Plan 테이블 Process Position)

  • id — Primary key — NOT NULL
  • wpq_plan_process_id (wpq_plan_process id) — Foreign key → wpq_plan_process.id — NOT NULL
  • position_cd (position type)

wpq_plan_table (WPQ Plan 테이블)

  • id — Primary key — NOT NULL
  • wpq_plan_id (wpq_plan id) — Foreign key → wpq_plan.id — NOT NULL
  • welder_id (welder id) — Foreign key → welder.id — NOT NULL
  • weld_type_cd (weld type)

wpq_process (WPQ Process)

  • id — Primary key — NOT NULL
  • wpq_id (wpq id) — Foreign key → wpq.id — NOT NULL
  • process_cd (process type)
  • filler_material_id (filler_material id)
  • filler_product_form_cd (filler_product_form code)
  • consumable_insert
  • is_over_three_layers (3 layers minimun)
  • deposit_weld_metal_thickness (deposit_weld_metal thickness)
  • is_using_backing_gas (backing gas 사용 여부)
  • cp_type_cd (cp_type code)
  • transfer_mode_cd (transfer_mode code)
  • single_or_multi_pass_cd (single_or_multi_pass code)
  • visual_control_type_cd (Direct or Remote Visual Control)
  • is_auto_arc_volt_control (Automatic Arc Voltage Control)
  • is_auto_joint_tracking (Automatic Joint Tracking)
  • progression_cd (welding progression)

wpq_process_position (WPQ Process Position)

  • id — Primary key — NOT NULL
  • wpq_process_id (wpq_process id) — Foreign key → wpq_process.id — NOT NULL
  • position_cd (position type)

wpq_test_guided_bend_row (WPQ Guided Bend Test Data)

  • id — Primary key — NOT NULL
  • wpq_test_master_id (wpq_test_master id) — Foreign key → wpq_test_master.id — NOT NULL
  • bend_test_type_cd (bend_test_type code)
  • figure_no
  • test_result_cd (test_result code)
  • result_value (result value)

wpq_test_master (WPQ test)

  • id — Primary key — NOT NULL
  • wpq_id (wpq id) — Foreign key → wpq.id — NOT NULL
  • test_type_cd (test_type code)
  • test_result_cd (test_result code)
  • report_no
  • alternative_volumetric_type
  • length_of_defects (length of defects(mm))
  • percent_of_defects (percent of defects(%))
  • fillet_width (fillet width)
  • fillet_height (fillet height)
  • flexural_cd (concavity code)
  • flexural_size (convexity size)