v1
테이블 (55)
TBM (company_tbm)
- tbm_id — varchar(50)
- site_id — varchar(50)
- company_code — varchar(50)
- construction — varchar(50)
- work_type — varchar(50)
- work_area — varchar(100)
- work_date — date — NOT NULL
- work_contents — text — NOT NULL
- work_plan_id — varchar(50)
- work_plan_use_yn — bpchar(1)
- accident_report_id — varchar(50)
- file_id — varchar(50)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
- edu_start_time — varchar(4)
- edu_end_time — varchar(4)
- edu_teacher_name — varchar(50)
TBM 공정, 작업 (company_tbm_construction_works)
- tbm_id — varchar(50)
- site_id — varchar(50)
- construction — varchar(50)
- work_type — varchar(50)
- sort_order — int4
- create_id — varchar(50)
- create_date — timestamp
- update_id — varchar(50)
- update_date — timestamp
TBM 참석자 company_tbm_workers (company_tbm_workers)
- tbm_id — varchar(50)
- site_id — varchar(50)
- worker_name — varchar(50)
- worker_phone — varchar(50)
- file_id — varchar(50)
- signature_date — timestamp
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
TBM점검항목 (company_tbm_check_list)
- tbm_id — varchar(50)
- tbm_check_list_id — varchar(50)
- action_comment — varchar(200) — archar(200) NUL
- check_yn — bpchar(1)
- use_yn — bpchar(1)
- update_date — timestamp — NOT NULL
- update_id — varchar(50)
- create_date — timestamp — NOT NULL
- create_id — varchar(50)
결재(1도큐먼트=1결재) (approve_master)
- approve_id — varchar(50) — 기본 키 — NOT NULL
- site_id — varchar(50) — NOT NULL
- document_id — varchar(50) — NOT NULL
- title — varchar(100)
- req_user_id — varchar(50)
- status — varchar(10)
- link_url — varchar(1000)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
결재선(결재자) (approve_user)
- approve_id — varchar(50) — 기본 키 — NOT NULL
- approve_seq — varchar(5) — 기본 키 — NOT NULL
- site_id — varchar(50) — NOT NULL
- company_user_id — varchar(50) — NOT NULL
- status — varchar(10) — NOT NULL
- comment — varchar(200)
- create_id — varchar(50) — NOT NULL
- create_date — timestamp — NOT NULL
- update_id — varchar(50) — NOT NULL
- update_date — timestamp — NOT NULL
- approve_id (approve_id2) — varchar(50) — 외래 키 → 결재(1도큐먼트=1결재).approve_id — NOT NULL
결재선(참조자) (approve_ref_user)
- approve_id — varchar(50) — 기본 키 — NOT NULL
- site_id — varchar(50) — NOT NULL
- company_user_id — varchar(50) — NOT NULL
- create_id — varchar(50) — NOT NULL
- create_date — timestamp — NOT NULL
- update_id — varchar(50) — NOT NULL
- update_date — timestamp — NOT NULL
- approve_id (approve_id2) — varchar(50) — 외래 키 → 결재(1도큐먼트=1결재).approve_id — NOT NULL
공정(공종) (site_cnst)
- label_id — varchar(50) — 기본 키 — NOT NULL
- construction — varchar(50) — 기본 키 — NOT NULL
- site_id — varchar(50) — 기본 키 — NOT NULL
- construction_name — varchar(50) — NOT NULL
- sort_order — int4 — NOT NULL
- use_yn — varchar(1) — NOT NULL
- create_date — timestamp — NOT NULL
- create_id — varchar(50) — NOT NULL
- update_date — timestamp — NOT NULL
- update_id — varchar(50) — NOT NULL
공종별작업 (site_cnst_work)
- label_id — varchar(50) — 기본 키 — NOT NULL
- construction — varchar(50) — 기본 키 — NOT NULL
- work_type — varchar(50) — 기본 키 — NOT NULL
- site_id — varchar(50) — 기본 키 — NOT NULL
- work_type_name — varchar(50) — NOT NULL
- sort_order — int4 — NOT NULL
- use_yn — varchar(1) — NOT NULL
- create_date — timestamp — NOT NULL
- create_id — varchar(50) — NOT NULL
- update_date — timestamp — NOT NULL
- update_id — varchar(50) — NOT NULL
공지사항 - 안쓰므로 폐기 site_notice (site_notice)
- site_notice_id — varchar(50)
- site_id — varchar(50)
- title — varchar(100)
- notice_content — varchar
- file_id — varchar(50)
- read_cnt — int8 — NOT NULL
- use_yn — bpchar(1)
- notice_yn — bpchar(1)
- create_date — timestamp — NOT NULL
- create_id — varchar(50)
- update_date — timestamp — NOT NULL
- update_id — varchar(50)
데이터 없는 쓰레기 - 알람읽음상태 (alarm_read_status)
- company_user_id — varchar(50)
- site_id — varchar(50)
- alarm_type — varchar(50)
- parent_document_id — varchar(50)
- document_id — varchar(50)
- document_seq — varchar(50)
- create_date — timestamp — NOT NULL
- alarm_target — varchar(10)
데이터 없는 쓰레기 - 푸쉬세팅 (push_setting)
- company_user_id — varchar(50) — NOT NULL
- site_id — varchar(50) — NOT NULL
- category — varchar(10) — NOT NULL
- push_type_code — varchar — NOT NULL
- parent_push_type_code — varchar — NOT NULL
- push_alarm_yn — bpchar(1) — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp — NOT NULL
데이터 없음 - 무슨테이블인지 불명site_risks_eval_history (site_risks_eval_history)
- three_type_eval_id — varchar(50)
- origin_three_type_eval_id — varchar(50)
- site_id — varchar(50)
- create_date — timestamp — NOT NULL
- create_id — varchar(50)
데이터 없음 쓰레기 - site_risk_attributes (site_risk_attributes)
- site_id — varchar(100)
- attribute_id — varchar(50)
- attribute_code — varchar(50)
- variable_id — varchar(50)
- attribute_name — varchar(200)
- influence_value — numeric(10, 4)
- risk_value — numeric(10, 4)
- possibility_count — int4 — NOT NULL
- possibility_value — numeric(10, 4)
- importance_count — int4 — NOT NULL
- importance_value — numeric(10, 4)
- start_range — numeric(30, 1)
- end_range — numeric(30, 1)
- sort_order — int4 — NOT NULL
- use_yn — bpchar(1)
- update_date — timestamp — NOT NULL
- update_id — varchar(50)
- create_date — timestamp — NOT NULL
- create_id — varchar(50)
데이터 없음 쓰레기 - site_risks (site_risks)
- site_id — varchar(100)
- variable_id — varchar(50)
- variable_code — varchar(50)
- variable_name — varchar(50)
- weight — varchar(200)
- priority — varchar(100)
- division_count — varchar(20)
- division_min — varchar(20)
- division_max — varchar(20)
- code_type — varchar(20)
- use_yn — bpchar(1)
- sort_order — int4
- update_date — timestamp — NOT NULL
- update_id — varchar(50)
- create_date — timestamp — NOT NULL
- create_id — varchar(50)
데이터 없음 쓰레기 -site_risk_marks (site_risk_marks)
- site_id — varchar(50)
- variable_id — varchar(50)
- variable_name — varchar(50)
- index_color — varchar(10)
- use_yn — bpchar(1)
- display_yn — bpchar(1)
- update_date — timestamp — NOT NULL
- update_id — varchar(50)
- create_date — timestamp — NOT NULL
- create_id — varchar(50)
- sort_order — int4 — NOT NULL
- index_min_value — int4 — NOT NULL
- index_max_value — int4 — NOT NULL
로그인이력 (company_user_login_log)
- company_user_log_id — varchar(50)
- company_user_id — varchar(50) — NOT NULL
- ip_address — varchar(50)
- user_agent — varchar(256)
- login_type — varchar(10)
- login_date — timestamp
- logout_date — timestamp
- create_date — timestamp — NOT NULL
- company_code — varchar(50)
비상연락망 (site_contact)
- site_contact_id — varchar(50)
- company_code — varchar(50)
- site_id — varchar(50)
- company_name — varchar(50)
- contact_type — varchar(10)
- company_user_id — varchar(50)
- upper_group — varchar(50)
- lower_group — varchar(50)
- dept_name — varchar(50)
- position_name — varchar(50)
- rank_name — varchar(50)
- user_name — varchar(50)
- phone — varchar(15)
- email — varchar(50)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
사업장 (site)
- site_id — varchar(50) — 기본 키 — NOT NULL
- site_name — varchar(50)
- site_detail — varchar(50)
- site_address — varchar(50)
- site_lat — float4
- site_lng — float4
- site_stn_id — varchar(5)
- site_start_date — varchar(10)
- site_end_date — varchar(10)
- site_type — varchar(50)
- site_const_price — varchar(20)
- site_size — varchar(10)
- site_process_rate — varchar(4)
- site_const_size — varchar(10)
- site_order_comp — varchar(50)
- site_build_comp — varchar(50)
- site_cm — varchar(50)
- site_zoom_level — varchar(50)
- site_map_type — varchar(50)
- site_scale — varchar(50)
- img_file_id — varchar(50)
- nx — int4
- ny — int4
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
- site_manager_name — varchar(20)
- site_manager_phone — varchar(50)
- partner_name — varchar(200)
- work_contents — text
- if_key — varchar(50)
산업분류 (site_cct)
- label_id — varchar(50) — 기본 키 — NOT NULL
- label_name — varchar(50) — NOT NULL
상시위험성평가 (site_risks_eval)
- three_type_eval_id — varchar(50)
- site_id — varchar(50)
- eval_start_date — varchar(8)
- eval_end_date — varchar(8)
- invite_user_name — text
- create_date — timestamp — NOT NULL
- create_id — varchar(50)
- update_date — timestamp — NOT NULL
- update_id — varchar(50)
- write_date — varchar(8)
상시위험성평가 - 위험요소 (site_risks_eval_const)
- three_type_eval_id — varchar(50)
- three_type_eval_seq — int2 — NOT NULL
- site_id — varchar(50)
- construction — varchar(50)
- work_type — varchar(50)
- harmful_risk_factors — varchar(300)
- eval_type — int2 — NOT NULL
- freq_val — int2 — NOT NULL
- str_val — int2 — NOT NULL
- preventive_measures — varchar(300)
- inspection_due_date — varchar(8)
- action_id — varchar(50)
- confirm_id — varchar(50)
- create_date — timestamp — NOT NULL
- create_id — varchar(50)
- update_date — timestamp — NOT NULL
- update_id — varchar(50)
쓰레기 site_risks_conference_users (site_risks_conference_users)
- site_risks_conference_id — varchar(50)
- company_user_id — varchar(50)
- file_id — varchar(50)
- signature_date — timestamp
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
쓰레기 site_risks_conference_workers (site_risks_conference_workers)
- site_risks_conference_id — varchar(50)
- company_worker_id — varchar(50)
- file_id — varchar(50)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
안전보건경영방침 (site_safety_rule)
- safety_rule_id (Field) — varchar(50)
- site_id (Field2) — varchar(50)
- safe_name (Field3) — varchar(50)
- safe_sign (Field4) — varchar(200)
- file_id (Field5) — varchar(50)
- use_yn (Field6) — bpchar(1)
- safe_type (Field7) — varchar(1)
- reg_date (Field8) — varchar(10)
- create_id (Field9) — varchar(50)
- create_date (Field10) — timestamp
- update_id (Field11) — varchar(50)
- update_date (Field12) — timestamp
안전보건관리문서 (site_data)
- site_data_id — varchar(50)
- site_id — varchar(50)
- data_type — varchar(50)
- title — varchar(200)
- data_content — text
- file_id — varchar(50)
- use_yn — bpchar(1)
- notice_yn — bpchar(1)
- create_date — timestamp — NOT NULL
- create_id — varchar(50)
- update_date — timestamp — NOT NULL
- update_id — varchar(50)
안전보건교육 (site_safety_health_edu)
- safety_health_edu_id — varchar(50)
- site_id — varchar(50)
- edu_curriculum — varchar(50)
- edu_target — varchar(50)
- person_cnt — int4
- edu_date — varchar(8)
- edu_start_time — varchar(4)
- edu_end_time — varchar(4)
- edu_location — varchar(50)
- edu_teacher_name — varchar(50)
- edu_content — text — NOT NULL
- edu_file_id — varchar(50)
- person_sign_id — varchar(50)
- attach_file_id — varchar(50)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
안전보건교육 참석자 (site_safety_health_edu_attendees)
- safety_health_edu_id — varchar(50)
- attendee_name — varchar(50)
- attendee_phone — varchar(50)
- file_id — varchar(50)
- signature_date — timestamp
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
안전점검(신호수,표지판) (site_safety_inspection)
- safety_inspection_id (regular_safety_inspection_id) — varchar(50)
- safety_inspection_type (Field) — varchar(50)
- site_id — varchar(50)
- title — varchar(200)
- check_date — date — NOT NULL
- file_id — varchar(50)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
안전점검(일일) (site_regular_safety_inspection)
- regular_safety_inspection_id — varchar(50)
- site_id — varchar(50)
- title — varchar(200)
- check_date — date — NOT NULL
- file_id — varchar(50)
- complete_yn — bpchar(1)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
안전점검(일일) 조치사항 (site_regular_safety_inspection_action)
- regular_safety_inspection_id — varchar(50)
- regular_safety_inspection_check_id — varchar(50)
- regular_safety_inspection_action_seq — int4 — NOT NULL
- site_id — varchar(50)
- action_status — varchar(50)
- action_content — varchar(200)
- action_date — date
- action_before_file_id — varchar(50)
- action_after_file_id — varchar(50)
- action_reply — varchar(200)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
안전점검(일일) 체크리스트 (site_regular_safety_inspection_check)
- regular_safety_inspection_id — varchar(50)
- regular_safety_inspection_check_id — varchar(50)
- regular_safety_inspection_check_seq — int4 — NOT NULL
- site_id — varchar(50)
- action_id — varchar(50)
- check_content — text — NOT NULL
- check_status — varchar(50)
- process_status — varchar(50)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
안전조직도 (site_safety_organization)
- site_id (safety_organization_mapping_id) — varchar(50)
- organization_type (company_user_id) — varchar(50)
- file_id (site_id) — varchar(50)
- use_yn — bpchar(1)
- update_date — timestamp — NOT NULL
- update_id — varchar(50)
- create_date — timestamp — NOT NULL
- create_id — varchar(50)
안전조직도-구성원 (company_user_safety_organization_mapping)
- safety_organization_mapping_id — varchar(50)
- company_user_id — varchar(50)
- site_id — varchar(50)
- organization_type — varchar(50)
- organization_code — varchar(50)
- use_yn — bpchar(1)
- update_date — timestamp — NOT NULL
- update_id — varchar(50)
- create_date — timestamp — NOT NULL
- create_id — varchar(50)
- proxy_company_user_id — varchar(50)
운영데이터 없음 - 쓰레기 site_safety_health_edu_templete (site_safety_health_edu_templete)
- safety_health_edu_temp_id — varchar(50)
- site_id — varchar(50)
- templete_title — varchar(50)
- edu_curriculum — varchar(50)
- edu_target — varchar(50)
- edu_content — text — NOT NULL
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
- edu_teacher_name — varchar(50)
위험성 감소대책 이행 (site_risks_inspection)
- three_type_eval_id — varchar(50)
- three_type_eval_seq — int2 — NOT NULL
- site_id — varchar(50)
- inspection_status — varchar(50)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
위험성 감소대책 이행 조치 (site_risks_inspection_action)
- three_type_eval_id — varchar(50)
- three_type_eval_seq — int4 — NOT NULL
- three_type_inspection_action_seq — int2 — NOT NULL
- site_id — varchar(50)
- action_status — varchar(50)
- action_content — text — NOT NULL
- action_date — date
- action_before_file_id — varchar(50)
- action_after_file_id — varchar(50)
- action_reply — varchar(200)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
위험성평가회의 (site_risks_conference)
- site_risks_conference_id — varchar(50)
- site_id — varchar(50)
- conference_name — varchar(200)
- risk_assessment_period_type — varchar(100)
- conference_start_date — timestamp
- conference_end_date — timestamp
- conference_area — varchar(200)
- conference_content — text
- conference_file_id — varchar(50)
- attach_file_id — varchar(50)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
- three_type_eval_id — varchar(50)
- worker_opinion — varchar(500)
- risk_assessment_result — varchar(500)
위험성평가회의 참석자 (site_risks_conference_attendees)
- site_risks_conference_id — varchar(50)
- attendee_name — varchar(50)
- attendee_phone — varchar(50)
- file_id — varchar(50)
- signature_date — timestamp
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
유저 (스키마.company_users) (스키마.company_users)
- company_code — varchar(50) — 기본 키 — NOT NULL
- company_user_id — varchar(50) — 기본 키 — NOT NULL
- user_name — varchar(50)
- user_phone — varchar(50)
- dept_id — varchar(50)
- position_id — varchar(50)
- img_file_id — varchar(50)
- rank_id — varchar(50)
- user_type — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
유저 common.company_users (company_users)
- company_code — varchar(50) — 기본 키 — NOT NULL
- company_user_id — varchar(50) — 기본 키 — NOT NULL
- user_name — varchar(50)
- user_phone — varchar(50)
- email — varchar(50)
- img_file_id — varchar(50)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
- login_fail_count — int4 — NOT NULL
- device_token — varchar(255)
- password — varchar(64)
- password_salt — varchar(50)
유저&사업장 (company_user_site_mapping)
- site_id — varchar(50) — 기본 키 — NOT NULL
- company_user_id — varchar(50) — 기본 키 — NOT NULL
- use_yn — bpchar(1) — NOT NULL
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
작업위험요소 (site_cnst_work_risk)
- label_id — varchar(50) — 기본 키 — NOT NULL
- construction — varchar(50) — 기본 키 — NOT NULL
- work_type — varchar(50) — 기본 키 — NOT NULL
- risk_id — varchar(50) — 기본 키 — NOT NULL
- site_id — varchar(50) — 기본 키 — NOT NULL
- harmful_risk_factors — varchar(300) — NOT NULL
- eval_type — int2 — NOT NULL
- freq_val — int2 — NOT NULL
- str_val — int2 — NOT NULL
- preventive_measures — varchar(300)
- create_date — timestamp — NOT NULL
- create_id — varchar(50) — NOT NULL
- update_date — timestamp — NOT NULL
- update_id — varchar(50) — NOT NULL
점검보고서 (inspection_report)
- inspection_report_id — varchar(50)
- site_id — varchar(50)
- inspection_report_start_date — date — NOT NULL
- inspection_report_end_date — date — NOT NULL
- title — varchar(500)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
점검보고서 상세내용 (inspection_report_item)
- inspection_report_id — varchar(50)
- inspection_report_item_id — varchar(50)
- site_id — varchar(50)
- inspection_report_item_type — varchar(50)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
점검항목마스터(TBM,일일안전점검) (check_list)
- check_id — varchar(10) — 기본 키 — NOT NULL
- check_type_cd — varchar(10) — NOT NULL
- check_item — varchar — NOT NULL
- sort_order — int2 — NOT NULL
- use_yn — varchar(1) — NOT NULL
- update_date — timestamp — NOT NULL
- update_id — varchar(50) — NOT NULL
- create_date — timestamp — NOT NULL
- create_id — varchar(50) — NOT NULL
최초위험성평가 (site_risks_first)
- key — varchar(50)
- site_id — varchar — NOT NULL
- label_id — varchar(50)
- construction — varchar — NOT NULL
- work_type — varchar — NOT NULL
- harmful_risk_factors — varchar(300)
- eval_type — int2
- freq_val — int2 — NOT NULL
- str_val — int2 — NOT NULL
- preventive_measures — varchar(300)
- memo — varchar(500)
- create_date — timestamp — NOT NULL
- create_id — varchar — NOT NULL
- update_date — timestamp
- update_id — varchar
핸드폰인증번호발송 (certification_number)
- id — varchar(200) — 기본 키 — NOT NULL
- countrycode — int4 — NOT NULL
- telno — varchar(50) — NOT NULL
- certnum — varchar(10)
- ischecked — bool — NOT NULL
- create_date — timestamp — NOT NULL
- create_id — varchar(50) — NOT NULL
회사 (company)
- company_code — varchar(50) — 기본 키 — NOT NULL
- company_name — varchar(50) — NOT NULL
- company_type — varchar(50) — NOT NULL
- company_owner_name — varchar(50)
- company_license — varchar(50)
- company_phone — varchar(50)
- owner_yn — varchar(1) — NOT NULL
- use_yn — varchar(1) — NOT NULL
- create_date — timestamp — NOT NULL
- create_id — varchar(50) — NOT NULL
- update_date — timestamp — NOT NULL
- update_id — varchar(50) — NOT NULL
- if_key — varchar(50)
회사 구분 코드 (tb_company_role)
- role_code — varchar(50) — 기본 키 — NOT NULL
- role_name — varchar(50) — NOT NULL
- create_id — varchar(50) — NOT NULL
- create_date — varchar(50) — NOT NULL
- update_id — varchar(50) — NOT NULL
- update_date — timestamp — NOT NULL
- use_yn — varchar(1)
회사&사업장 (company_site_mapping)
- company_code — varchar(50) — 기본 키 — NOT NULL
- site_id — varchar(50) — 기본 키 — NOT NULL
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
회사-공종 매핑 (company_constructions)
- company_code — varchar(50) — NOT NULL
- site_id — varchar(50) — NOT NULL
- construction — varchar(50) — NOT NULL
- construction_name — varchar(50)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
회사부서 (company_dept)
- dept_id — varchar(50) — 기본 키 — NOT NULL
- company_code — varchar(50) — 기본 키 — NOT NULL
- dept_name — varchar(50)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
회사직급 (company_rank)
- rank_id — varchar(50) — 기본 키 — NOT NULL
- company_code — varchar(50) — 기본 키 — NOT NULL
- rank_name — varchar(50)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL
회사직책 (company_position)
- position_id — varchar(50) — 기본 키 — NOT NULL
- company_code — varchar(50) — 기본 키 — NOT NULL
- position_name — varchar(50)
- use_yn — bpchar(1)
- create_id — varchar(50)
- create_date — timestamp — NOT NULL
- update_id — varchar(50)
- update_date — timestamp — NOT NULL