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)