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