dpsm

테이블 (30)

attach

  • id — INT — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • file_content_type — VARCHAR
  • file_name — VARCHAR
  • file_path — VARCHAR
  • file_size — BIGINT
  • image_height — INT
  • image_width — INT

code

  • id — VARCHAR — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • code_group_id — VARCHAR
  • name — VARCHAR
  • value — VARCHAR

sample

  • id — VARCHAR — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • page_id — VARCHAR
  • contents — MEDIUMTEXT
  • desc — VARCHAR

sys_log

  • id — BIGINT — 기본 키
  • log_date — DATETIME
  • remote_ip — VARCHAR
  • message — VARCHAR
  • type — VARCHAR
  • uri — VARCHAR
  • username — VARCHAR

가동전점검 (commissioning)

  • id — INT — 기본 키
  • manage_change_id — INT — 외래 키 → 변경요소관리.id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • check_list — VARCHAR
  • check_report — VARCHAR
  • check_date — DATETIME
  • next_check_date — DATETIME
  • punch_report — VARCHAR
  • desc — VARCHAR
  • condition_code — VARCHAR
  • user_id — INT
  • period_code — VARCHAR
  • facility_id — INT

공장 (factory)

  • id — INT — 기본 키
  • company_id — INT — 외래 키 → 사업장.id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • factory_no — VARCHAR
  • factory_name — VARCHAR
  • factory_owner — VARCHAR
  • zip_code — VARCHAR
  • zip_addr — VARCHAR
  • zip_addr_detail — VARCHAR
  • tel — VARCHAR
  • fax — VARCHAR
  • regist_date — DATETIME
  • start_date — DATETIME
  • rent_yn — BIT
  • condition_code — VARCHAR
  • sectors — VARCHAR
  • gross_size — FLOAT
  • facility_size — FLOAT
  • ancillary_size — FLOAT
  • desc — VARCHAR
  • worker_average — INT

공정도면 (drawing)

  • id — INT — 기본 키
  • company_id — INT — 외래 키 → 공장.company_id
  • factory_id — INT — 외래 키 → 공장.id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • desc — MEDIUMTEXT
  • psm_yn — BIT
  • type_code — VARCHAR
  • drawing_code — VARCHAR
  • id (id2) — INT — 외래 키 → 공정위험성평가.id
  • id (id3) — INT — 외래 키 → 작업위험성평가.id
  • id (id22) — INT — 외래 키 → 공정위험성평가.manage_change_id
  • id (id23) — INT — 외래 키 → 작업위험성평가.manage_change_id

공정사고 (incidents)

  • id — INT — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • occur_date — DATETIME
  • place — DATETIME
  • start_date — DATETIME
  • end_date — DATETIME
  • report_date — DATETIME
  • report — MEDIUMTEXT
  • contractor_id — INT
  • user_id — INT
  • division_code — VARCHAR
  • type_code — VARCHAR
  • factory_code — VARCHAR
  • factory_id — INT

공정위험성평가 (process_hazard)

  • id — INT — 기본 키
  • manage_change_id — INT — 외래 키 → 변경요소관리.id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • jra_yn — BIT
  • evaluation_date — DATETIME
  • evaluation_code — VARCHAR
  • drawing_id — INT

교육 (training)

  • id — INT — 기본 키
  • manage_change_id — INT — 외래 키 → 변경요소관리.id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • start_date — DATETIME
  • end_date — DATETIME
  • contents — VARCHAR
  • desc — VARCHAR
  • state_code — VARCHAR
  • facility_id — INT

교육계획항목 (training_plan)

  • id — INT — 기본 키
  • training_id — INT — 외래 키 → 교육.id
  • defalult (defalult1) — INT — 외래 키 → 교육.manage_change_id
  • plan_name — VARCHAR
  • target_cnt — INT
  • completion_cnt — INT
  • nonattendance — VARCHAR
  • teacher — VARCHAR
  • place — VARCHAR
  • start_date — DATETIME
  • end_date — DATETIME
  • expiration — DATETIME
  • contents — VARCHAR
  • report — VARCHAR
  • desc — VARCHAR
  • method_code — VARCHAR

교육대상자항목 (training_target)

  • id — INT — 기본 키
  • training_id — INT — 외래 키 → 교육.id
  • defalult — INT — 외래 키 → 교육.manage_change_id
  • start_date — DATETIME
  • end_date — DATETIME
  • point — INT
  • answer — VARCHAR
  • desc — VARCHAR
  • state_code — VARCHAR
  • user_id — INT

교육문제항목 (training_item)

  • id — INT — 기본 키
  • training_id — INT — 외래 키 → 교육.id
  • defalult (defalult1) — INT — 외래 키 → 교육.manage_change_id
  • created_by — VARCHAR
  • created_date — DATETIME
  • contents — VARCHAR
  • example_1 — VARCHAR
  • example_2 — VARCHAR
  • example_3 — VARCHAR
  • example_4 — VARCHAR
  • answer — VARCHAR
  • point — INT
  • division_code — VARCHAR
  • type_code — VARCHAR

기타자료 (etc)

  • id — INT — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • desc — VARCHAR
  • psm_yn — BIT
  • type_code — VARCHAR
  • division_code — VARCHAR
  • factory_id — INT
  • id (id2) — INT — 외래 키 → 변경요소관리.id

도급업체 (contractor)

  • id — INT — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • company_name — VARCHAR
  • company_no — VARCHAR
  • business_no — VARCHAR
  • ceo_name — VARCHAR
  • condition — VARCHAR
  • sectors — VARCHAR
  • product — VARCHAR
  • worker_average — INT
  • zip_code — VARCHAR
  • zip_addr — VARCHAR
  • zip_addr_detail — VARCHAR
  • tel — VARCHAR
  • fax — VARCHAR
  • desc — VARCHAR

도급업체작업 (contractor_work)

  • id — INT — 기본 키
  • contractor_id (id2) — INT — 외래 키 → 도급업체.id
  • work_permit_id — INT — 외래 키 → 안전작업허가.id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • start_date — DATETIME
  • end_date — DATETIME
  • work_cnt — INT
  • work_place — VARCHAR
  • work — VARCHAR
  • instruction — VARCHAR
  • hard_hat_yn — BIT
  • boots_yn — BIT
  • glasses_yn — BIT
  • gloves_yn — BIT
  • mask_yn — BIT
  • education_date — DATETIME
  • car_no — VARCHAR
  • responsible_nm — VARCHAR
  • phon_no — VARCHAR
  • submission_date — DATETIME
  • contents — VARCHAR
  • approval_start_date — DATETIME
  • approval_end_date — DATETIME
  • extension_start_date — DATETIME
  • extension_end_date — DATETIME
  • extension_reason — VARCHAR
  • change_cont — VARCHAR
  • change_before — VARCHAR
  • change_after — VARCHAR
  • price — INT
  • safety_plan — MEDIUMTEXT
  • rating — MEDIUMTEXT
  • proposal_code — VARCHAR
  • department_code — VARCHAR
  • state_code — VARCHAR
  • user_id — INT
  • factory_id — INT

변경요소검토항목 (manage_change_item)

  • id — INT — 기본 키
  • manage_change_id (id2) — INT — 외래 키 → 변경요소관리.id
  • inspect_date — DATETIME
  • inspect — VARCHAR
  • accept_yn — BIT
  • plan — VARCHAR
  • agree_yn — BIT
  • division_code — VARCHAR
  • inspect_user_id — INT

변경요소관리 (manage_change)

  • id — INT — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • problem — VARCHAR
  • contents — VARCHAR
  • request — VARCHAR
  • req_date — DATETIME
  • deadline_date — DATETIME
  • period — DATETIME
  • approval_date — DATETIME
  • approval_yn — BIT
  • pre_com_yn — BIT
  • guide_change_yn — BIT
  • low_permit_yn — BIT
  • save_req_yn — BIT
  • save_attch_yn — BIT
  • save_approval_yn — BIT
  • save_hazard_yn — BIT
  • save_work_yn — BIT
  • save_contractor_yn — BIT
  • save_commissioning_yn — BIT
  • save_guide_yn — BIT
  • save_check_yn — BIT
  • save_training_yn — BIT
  • state_code — VARCHAR
  • new_yn_code — VARCHAR
  • change_type_code — VARCHAR
  • rating_code — VARCHAR
  • req_part_code — VARCHAR
  • approval_part_code — VARCHAR
  • manage_user_id — INT

비상대응 (emergency)

  • id — INT — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • cause — VARCHAR
  • restore_time — VARCHAR
  • response — MEDIUMTEXT
  • promotion — MEDIUMTEXT
  • declaration — MEDIUMTEXT
  • type_code — VARCHAR
  • facility_id — INT

사업장 (company)

  • id — INT — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • company_name — VARCHAR
  • company_no — VARCHAR
  • business_no — VARCHAR
  • ceo_name — VARCHAR
  • condition — VARCHAR
  • sectors — VARCHAR
  • condition_code — VARCHAR
  • start_date — DATETIME
  • zip_code — VARCHAR
  • zip_addr — VARCHAR
  • zip_addr_detail — VARCHAR
  • tel — VARCHAR
  • fax — VARCHAR
  • worker_average — INT
  • desc — VARCHAR

사용자 (user)

  • id — INT — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • username — VARCHAR
  • password — VARCHAR
  • name — VARCHAR
  • enabled — BIT
  • locked — BIT
  • removable — BIT
  • removed — BIT
  • last_login_date — DATETIME
  • last_logout_date — DATETIME
  • phone_number — VARCHAR
  • email — VARCHAR
  • role_group_id — INT
  • department_code — VARCHAR
  • position_code — VARCHAR
  • id (id2) — INT — 외래 키 → 접근권한.id

설비점검 (facility_check)

  • id — INT — 기본 키
  • facility_id — INT — 외래 키 → 취급설비.factory_id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • check_list — VARCHAR
  • check_report — VARCHAR
  • check_date — DATETIME
  • next_check_date — DATETIME
  • stop_start_time — DATETIME
  • stop_end_time — DATETIME
  • check_time — INT
  • desc — VARCHAR
  • user_id — INT
  • type_code — VARCHAR

안전운전지침 (safety_procedure)

  • id — INT — 기본 키
  • manage_change_id — INT — 외래 키 → 변경요소관리.id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • education_yn — BIT
  • bypass_yn — BIT
  • contents — MEDIUMTEXT
  • interlock — TEXT
  • interlock_clear — TEXT
  • process_code — VARCHAR
  • factory_id — INT
  • drawing_id — INT
  • interlock_code — VARCHAR
  • id (id2) — INT — 외래 키 → 작업위험성평가.id
  • manage_change_id (manage_change_id2) — INT — 외래 키 → 작업위험성평가.manage_change_id

안전작업허가 (work_permit)

  • id — INT — 기본 키
  • manage_change_id — INT — 외래 키 → 변경요소관리.id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • req_date — DATETIME
  • approval_date — DATETIME
  • start_date — DATETIME
  • end_date — DATETIME
  • work_number — INT
  • work_place — VARCHAR
  • work_content — VARCHAR
  • etc_req — VARCHAR
  • req_fire_yn — BIT
  • req_limit_yn — BIT
  • req_equip_yn — BIT
  • req_excavation_yn — BIT
  • req_elec_yn — BIT
  • req_height_yn — BIT
  • req_radiation_yn — BIT
  • req_poison_yn — BIT
  • req_nomal_yn — BIT
  • req_close_yn — BIT
  • req_lift_yn — BIT
  • req_etc_yn — BIT
  • area_code — VARCHAR
  • division_code — VARCHAR
  • level_code — VARCHAR
  • contractor_id — INT
  • user_id — INT
  • approval_id — INT
  • check_id — INT
  • director_id — INT
  • facility_id — INT

자체감사 (Inspection)

  • id — INT — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • start_date — DATETIME
  • end_date — DATETIME
  • action_date — DATETIME
  • approval_date — DATETIME
  • rating_code — VARCHAR
  • division_code — VARCHAR
  • user_id — INT
  • department_code — VARCHAR
  • factory_id — INT

자체감사항목 (Inspection_item)

  • id — INT — 기본 키
  • Inspection_id — INT — 외래 키 → 자체감사.id
  • evaluation — VARCHAR
  • evidence — VARCHAR
  • type_code — VARCHAR
  • result_code — VARCHAR
  • user_id — INT

작업위험성평가 (work_hazard)

  • id — INT — 기본 키
  • manage_change_id — INT — 외래 키 → 변경요소관리.id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • evaluation_date — DATETIME
  • department_code — VARCHAR
  • evaluation_code — VARCHAR
  • drawing_id — INT

접근권한 (role_group)

  • id — INT — 기본 키
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • user_permission — VARCHAR
  • memo — VARCHAR
  • permission_name — VARCHAR
  • removable — BIT
  • user_end_point — VARCHAR

취급물질 (material)

  • id — INT — 기본 키
  • factory_id — INT — 외래 키 → 공장.company_id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • cas_no — VARCHAR
  • molecular — VARCHAR
  • top_limit — FLOAT
  • down_limit — FLOAT
  • exposure — VARCHAR
  • flash_point — FLOAT
  • fire_point — FLOAT
  • vapor_pressure — VARCHAR
  • causticity — BIT
  • toxicity — VARCHAR
  • adverse_reaction — BIT
  • daily_usage — FLOAT
  • storage — FLOAT
  • related_laws — VARCHAR
  • psm_yn — BIT
  • desc — VARCHAR
  • id (id2) — INT — 외래 키 → 변경요소관리.id

취급설비 (facility)

  • id — INT — 기본 키
  • company_id — INT — 외래 키 → 공정도면.company_id
  • factory_id — INT — 외래 키 → 공정도면.factory_id
  • drawing_id — INT — 외래 키 → 공정도면.id
  • created_by — VARCHAR
  • created_date — DATETIME
  • last_modified_by — VARCHAR
  • last_modified_date — DATETIME
  • manage_id — VARCHAR
  • manage_name — VARCHAR
  • maker_name — VARCHAR
  • make_date — DATETIME
  • serial_no — VARCHAR
  • buy_date — DATETIME
  • price — INT
  • buyer — VARCHAR
  • installation_date — DATETIME
  • life_time — INT
  • pnid_no — VARCHAR
  • desc — VARCHAR
  • psm_yn — BIT
  • pw_flux — VARCHAR
  • pw_discharge_pa — VARCHAR
  • pw_rpm — VARCHAR
  • pw_casing — VARCHAR
  • pw_impeller — VARCHAR
  • pw_shaft — VARCHAR
  • e_volume — VARCHAR
  • safe_type — VARCHAR
  • e_fluid — VARCHAR
  • e_capacity — VARCHAR
  • e_driving_pa — VARCHAR
  • e_design_pa — VARCHAR
  • e_driving_temp — VARCHAR
  • e_design_temp — VARCHAR
  • e_body_mat — VARCHAR
  • e_side_mat — VARCHAR
  • e_gaskit_mat — VARCHAR
  • e_welding_capa — VARCHAR
  • e_cal_thick — VARCHAR
  • e_corrosion — VARCHAR
  • e_use_thick — VARCHAR
  • e_treat_yn — VARCHAR
  • e_nondist_rating — VARCHAR
  • p_fluid — VARCHAR
  • p_mat — VARCHAR
  • v_state — VARCHAR
  • v_exhaust — VARCHAR
  • v_capacity — VARCHAR
  • v_in_size — VARCHAR
  • v_out_size — VARCHAR
  • v_ps_no — VARCHAR
  • v_driving_pa — VARCHAR
  • v_design_pa — VARCHAR
  • v_set_ps — VARCHAR
  • V_body_mat — VARCHAR
  • v_trim_mat — VARCHAR
  • v_precision — VARCHAR
  • v_connect — VARCHAR
  • v_cause — VARCHAR
  • … +5