YEOUN

Tables (76)

Untitled

    alarm

    • alarm_id — NUMBER(19) — Primary key — NOT NULL
    • alarm_link — VARCHAR2(255 CHAR)
    • alarm_message — VARCHAR2(255 CHAR) — NOT NULL
    • alarm_status — VARCHAR2(255 CHAR) — NOT NULL
    • created_date — TIMESTAMP
    • emp_id — VARCHAR2(255 CHAR) — NOT NULL

    annual_leave

    • leave_id — NUMBER(19) — Primary key — NOT NULL
    • period_end — DATE
    • period_start — DATE
    • remain_days — FLOAT(53) — NOT NULL
    • total_days — FLOAT(53) — NOT NULL
    • use_year — NUMBER(10) — NOT NULL
    • used_days — FLOAT(53) — NOT NULL
    • emp_id — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • updated_date — TIMESTAMP
    • reason — VARCHAR2(255 CHAR)
    • updated_user — VARCHAR2(255 CHAR)

    annual_leave_history

    • leave_hist_id — NUMBER(19) — Primary key — NOT NULL
    • end_date — DATE — NOT NULL
    • start_date — DATE — NOT NULL
    • used_days — NUMBER(10) — NOT NULL
    • emp_id — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • approval_id — NUMBER(19)
    • leave_id — NUMBER(19) — Foreign key → annual_leave.leave_id — NOT NULL
    • dept_id — VARCHAR2(10 CHAR) — Foreign key → dept.dept_id — NOT NULL
    • leave_type — VARCHAR2(255 CHAR) — NOT NULL
    • reason — VARCHAR2(255 CHAR) — NOT NULL

    approval_doc

    • approval_id — NUMBER(19) — Primary key — NOT NULL
    • created_date — DATE
    • end_date — DATE
    • finish_date — DATE
    • start_date — DATE
    • approval_title — VARCHAR2(255 CHAR)
    • approver — VARCHAR2(255 CHAR)
    • doc_status — VARCHAR2(255 CHAR)
    • emp_id — VARCHAR2(255 CHAR)
    • expnd_type — VARCHAR2(255 CHAR)
    • form_type — VARCHAR2(255 CHAR)
    • leave_type — VARCHAR2(255 CHAR)
    • to_dept_id — VARCHAR2(255 CHAR)
    • to_pos_code — VARCHAR2(255 CHAR)
    • reason — VARCHAR2(255 CHAR)

    approval_form

    • form_code — VARCHAR2(255 CHAR) — Primary key — NOT NULL
    • approver_1 — VARCHAR2(255 CHAR)
    • approver_2 — VARCHAR2(255 CHAR)
    • approver_3 — VARCHAR2(255 CHAR)
    • dept_id — VARCHAR2(255 CHAR)
    • form_name — VARCHAR2(255 CHAR)

    approver

    • approval_id — NUMBER(19) — Primary key — NOT NULL
    • emp_id — VARCHAR2(255 CHAR) — Primary key — NOT NULL
    • approval_status — NUMBER(1)
    • delegate_status — VARCHAR2(255 CHAR)
    • order_approvers — VARCHAR2(255 CHAR)
    • viewing — VARCHAR2(255 CHAR)

    attendance

    • attendance_id — NUMBER(19) — Primary key — NOT NULL
    • work_date — DATE — NOT NULL
    • work_duration — NUMBER(10)
    • work_in — TIMESTAMP
    • work_out — TIMESTAMP
    • created_user — VARCHAR2(7 CHAR)
    • emp_id — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • updated_user — VARCHAR2(7 CHAR)
    • created_date — TIMESTAMP
    • updated_date — TIMESTAMP
    • remark — VARCHAR2(255 CHAR)
    • status_code — VARCHAR2(255 CHAR)

    bom_hdr

    • bom_hdr_id — VARCHAR2(50 CHAR) — Primary key — NOT NULL — BOM
    • bom_id — VARCHAR2(50 CHAR) — BOM
    • bom_hdr_name — VARCHAR2(100 CHAR) — BOM
    • bom_hdr_type — VARCHAR2(50 CHAR) — BOM
    • use_yn — VARCHAR2(1 CHAR) — BOM
    • created_date — DATE
    • updated_date — DATE
    • bom_hdr_date — TIMESTAMP
    • created_id — VARCHAR2(7 BYTE)
    • updated_id — VARCHAR2(7 BYTE)

    bom_mst

    • prd_id — VARCHAR2(50 BYTE) — Primary key — NOT NULL
    • mat_id — VARCHAR2(50 BYTE) — Primary key — NOT NULL
    • bom_id — VARCHAR2(50 CHAR) — NOT NULL
    • mat_qty — NUMBER(10, 3) — NOT NULL
    • mat_unit — VARCHAR2(20 BYTE)
    • bom_seq_no — NUMBER
    • created_id — VARCHAR2(7 BYTE)
    • created_date — DATE
    • updated_id — VARCHAR2(7 BYTE)
    • updated_date — DATE
    • use_yn — VARCHAR2(1 CHAR) — NOT NULL

    client

    • client_id — VARCHAR2(20 CHAR) — Primary key — NOT NULL — 시스템에서
    • account_name — VARCHAR2(20 CHAR) — 거래처
    • account_number — VARCHAR2(30 CHAR) — 거래처
    • addr — VARCHAR2(100 CHAR) — 거래처
    • addr_detail — VARCHAR2(100 CHAR) — 거래처
    • bank_name — VARCHAR2(20 CHAR) — 거래처
    • business_no — VARCHAR2(20 CHAR) — 사업자
    • ceo_name — VARCHAR2(50 CHAR) — 거래처
    • client_name — VARCHAR2(30 CHAR) — NOT NULL — 거래처(회사)
    • client_type — VARCHAR2(20 CHAR) — NOT NULL — 거래처의
    • created_by — VARCHAR2(20 CHAR) — 거래처
    • created_date — TIMESTAMP — 거래처
    • fax_number — VARCHAR2(30 CHAR) — 거래처
    • manager_dept — VARCHAR2(50 CHAR) — 담당자(구매자)의
    • manager_email — VARCHAR2(100 CHAR) — 담당자
    • manager_name — VARCHAR2(50 CHAR) — 우리
    • post_code — VARCHAR2(10 CHAR) — 거래처
    • status_code — VARCHAR2(10 CHAR) — NOT NULL — 거래처
    • updated_by — VARCHAR2(20 CHAR) — 마지막으로
    • updated_date — TIMESTAMP — 거래처
    • created_at — TIMESTAMP
    • manager_tel — VARCHAR2(20 CHAR)
    • updated_at — TIMESTAMP
    • biz_item — VARCHAR2(255 CHAR) — 업종
    • biz_type — VARCHAR2(255 CHAR)

    client_item

    • item_id — NUMBER(19) — Primary key — NOT NULL — 공급품목
    • client_id — VARCHAR2(20 CHAR) — NOT NULL — 해당
    • created_at — TIMESTAMP — 공급품목
    • created_by — VARCHAR2(20 CHAR) — 공급품목
    • lead_days — NUMBER(10) — NOT NULL — 발주
    • material_id — VARCHAR2(30 CHAR) — NOT NULL — 공급
    • min_order_qty — NUMBER(18, 4) — 최소
    • order_unit — NUMBER(18, 4) — 발주단위
    • supply_available — VARCHAR2(1 CHAR) — NOT NULL — 공급
    • unit — VARCHAR2(20 CHAR) — NOT NULL — 해당
    • unit_price — NUMBER(18, 2) — NOT NULL — 거래처로부터
    • updated_at — TIMESTAMP — 공급품목
    • updated_by — VARCHAR2(20 CHAR) — 공급품목
    • conv_to_base — NUMBER(18, 6)
    • pack_qty — NUMBER(18, 4)

    common_code

    • code_id — VARCHAR2(50 CHAR) — Primary key — NOT NULL
    • code_seq — NUMBER(10)
    • level_no — NUMBER(10)
    • use_yn — VARCHAR2(1 CHAR)
    • created_user — VARCHAR2(7 CHAR)
    • updated_user — VARCHAR2(7 CHAR)
    • created_date — TIMESTAMP
    • updated_date — TIMESTAMP
    • sys_type — VARCHAR2(30 CHAR)
    • parent_code_id — VARCHAR2(50 CHAR) — Foreign key → common_code.code_id
    • code_desc — VARCHAR2(100 CHAR)
    • code_name — VARCHAR2(100 CHAR) — NOT NULL

    dept

    • dept_id — VARCHAR2(10 CHAR) — Primary key — NOT NULL
    • use_yn — VARCHAR2(1 CHAR) — NOT NULL
    • head_emp_id — VARCHAR2(7 CHAR)
    • created_date — TIMESTAMP — NOT NULL
    • parent_id — VARCHAR2(10 CHAR)
    • dept_abbr — VARCHAR2(20 CHAR)
    • dept_name — VARCHAR2(50 CHAR) — NOT NULL

    dispose

    • dispose_id — NUMBER(19) — Primary key — NOT NULL
    • created_date — TIMESTAMP
    • dispose_amount — NUMBER(19) — NOT NULL
    • dispose_reason — VARCHAR2(255 CHAR)
    • emp_id — VARCHAR2(255 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • item_id — VARCHAR2(255 CHAR) — NOT NULL
    • lot_no — VARCHAR2(255 CHAR) — NOT NULL
    • work_type — VARCHAR2(255 CHAR) — NOT NULL

    emp

    • emp_id — VARCHAR2(7 CHAR) — Primary key — NOT NULL
    • gender — VARCHAR2(1 CHAR)
    • hire_date — DATE
    • retire_date — DATE
    • created_date — TIMESTAMP
    • last_login — TIMESTAMP
    • photo_file_id — NUMBER(19)
    • dept_id — VARCHAR2(10 CHAR) — Foreign key → dept.dept_id — NOT NULL
    • pos_code — VARCHAR2(10 CHAR) — Foreign key → position.pos_code — NOT NULL
    • post_code — VARCHAR2(10 CHAR)
    • status — VARCHAR2(10 CHAR) — NOT NULL
    • rrn — VARCHAR2(14 CHAR)
    • mobile — VARCHAR2(20 CHAR)
    • emp_name — VARCHAR2(50 CHAR) — NOT NULL
    • email — VARCHAR2(100 CHAR)
    • address1 — VARCHAR2(200 CHAR)
    • address2 — VARCHAR2(200 CHAR)
    • emp_pwd — VARCHAR2(200 CHAR) — NOT NULL
    • pwd_change_req — VARCHAR2(1 CHAR)

    emp_bank

    • bank_id — NUMBER(19) — Primary key — NOT NULL
    • emp_id — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • created_date — TIMESTAMP — NOT NULL
    • file_id — NUMBER(19) — Foreign key → file_attach.file_id
    • account_no — VARCHAR2(30 CHAR) — NOT NULL
    • bank_code — VARCHAR2(30 CHAR) — Foreign key → common_code.code_id — NOT NULL
    • holder — VARCHAR2(30 CHAR) — NOT NULL

    emp_pay_item

    • item_id — NUMBER(19) — Primary key — NOT NULL
    • amount — NUMBER(15, 2)
    • sort_no — NUMBER(10)
    • emp_pay_id — NUMBER(19) — Foreign key → payroll_payslip.payslip_id
    • item_type — VARCHAR2(20 CHAR) — NOT NULL
    • item_code — VARCHAR2(30 CHAR)
    • item_name — VARCHAR2(60 CHAR)

    emp_role

    • id — NUMBER(19) — Primary key — NOT NULL
    • emp_id — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • role_code — VARCHAR2(20 CHAR) — Foreign key — NOT NULL

    equip_downtime

    • down_id — NUMBER(19) — Primary key — NOT NULL
    • down_reason — VARCHAR2(255 CHAR) — NOT NULL
    • end_time — TIMESTAMP
    • remark — VARCHAR2(255 CHAR)
    • start_time — TIMESTAMP — NOT NULL
    • equip_id — NUMBER(10) — Foreign key — NOT NULL

    equipment

    • equip_id — VARCHAR2(255 CHAR) — Primary key — NOT NULL
    • created_date — TIMESTAMP — NOT NULL
    • equip_name — VARCHAR2(255 CHAR) — NOT NULL
    • updated_date — TIMESTAMP
    • ko_name — VARCHAR2(255 CHAR) — NOT NULL
    • remark — VARCHAR2(500 CHAR)
    • use_yn — CHAR(1 BYTE) — NOT NULL
    • process_id — VARCHAR2(20 CHAR) — Foreign key → process_mst.process_id

    file_attach

    • file_id — NUMBER(19) — Primary key — NOT NULL
    • created_date — DATE
    • file_size — NUMBER(19) — NOT NULL
    • ref_id — NUMBER(19) — NOT NULL
    • ref_table — VARCHAR2(30 CHAR) — NOT NULL
    • file_path — VARCHAR2(400 CHAR) — NOT NULL
    • category — VARCHAR2(255 CHAR)
    • file_name — VARCHAR2(255 CHAR) — NOT NULL
    • origin_file_name — VARCHAR2(255 CHAR) — NOT NULL

    hr_action

    • action_id — NUMBER(19) — Primary key — NOT NULL
    • applied_date — DATE
    • effective_date — DATE
    • leave_end_date — DATE
    • created_user — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • emp_id — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • approval_id — NUMBER(19)
    • created_date — TIMESTAMP
    • from_dept_id — VARCHAR2(10 CHAR) — Foreign key → dept.dept_id
    • from_pos_code — VARCHAR2(10 CHAR) — Foreign key → position.pos_code
    • status — VARCHAR2(10 CHAR) — NOT NULL
    • to_dept_id — VARCHAR2(10 CHAR) — Foreign key → dept.dept_id
    • to_pos_code — VARCHAR2(10 CHAR) — Foreign key → position.pos_code
    • action_type — VARCHAR2(20 CHAR) — NOT NULL
    • reason — VARCHAR2(200 CHAR)
    • applied_yn — VARCHAR2(255 CHAR) — NOT NULL

    hte_emp_role

    • rn_ — NUMBER(10) — Primary key — NOT NULL
    • emp_id — VARCHAR2(7 CHAR)
    • id — NUMBER(19)
    • role_code — VARCHAR2(20 CHAR)

    hte_notice

    • rn_ — NUMBER(10) — Primary key — NOT NULL
    • deleteyn — VARCHAR2(1 CHAR)
    • noticeyn — VARCHAR2(1 CHAR)
    • created_user — VARCHAR2(7 CHAR)
    • updated_user — VARCHAR2(7 CHAR)
    • created_date — TIMESTAMP
    • notice_id — NUMBER(19)
    • updated_date — TIMESTAMP
    • notice_content — VARCHAR2(255 CHAR)
    • notice_title — VARCHAR2(255 CHAR)

    inbound

    • inbound_id — VARCHAR2(255 CHAR) — Primary key — NOT NULL
    • created_date — TIMESTAMP
    • emp_id — VARCHAR2(255 CHAR)
    • expect_arrival_date — TIMESTAMP — NOT NULL
    • inbound_status — VARCHAR2(255 CHAR) — NOT NULL
    • material_id — VARCHAR2(255 CHAR)
    • prod_id — VARCHAR2(255 CHAR)
    • inbound_type — VARCHAR2(255 CHAR)

    inbound_item

    • inbound_item_id — NUMBER(19) — Primary key — NOT NULL
    • dispose_amount — NUMBER(19)
    • expiration_date — TIMESTAMP
    • inbound_amount — NUMBER(19)
    • inbound_id — VARCHAR2(255 CHAR) — Foreign key → inbound.inbound_id — NOT NULL
    • item_id — VARCHAR2(255 CHAR) — NOT NULL
    • item_type — VARCHAR2(255 CHAR) — NOT NULL
    • location_id — VARCHAR2(255 CHAR)
    • lot_no — VARCHAR2(255 CHAR)
    • manufacture_date — TIMESTAMP — NOT NULL
    • request_amount — NUMBER(19) — NOT NULL

    inventory

    • iv_id — NUMBER(19) — Primary key — NOT NULL
    • expiration_date — TIMESTAMP
    • ib_date — TIMESTAMP — NOT NULL
    • item_id — VARCHAR2(255 CHAR) — NOT NULL
    • iv_amount — NUMBER(19) — NOT NULL
    • location_id — VARCHAR2(255 CHAR) — Foreign key — NOT NULL
    • lot_no — VARCHAR2(255 CHAR) — NOT NULL
    • manufacture_date — TIMESTAMP — NOT NULL
    • expect_ob_amount — NUMBER(19) — NOT NULL
    • iv_status — VARCHAR2(255 CHAR) — NOT NULL
    • item_type — VARCHAR2(255 BYTE)

    inventory_history

    • iv_history_id — NUMBER(19) — Primary key — NOT NULL
    • created_date — TIMESTAMP
    • current_location_id — VARCHAR2(255 CHAR) — Foreign key
    • emp_id — VARCHAR2(255 CHAR) — NOT NULL
    • lot_no — VARCHAR2(255 CHAR) — NOT NULL
    • prev_location_id — VARCHAR2(255 CHAR) — Foreign key
    • reason — VARCHAR2(255 CHAR)
    • work_type — VARCHAR2(255 CHAR) — NOT NULL
    • item_name — VARCHAR2(255 CHAR) — NOT NULL
    • current_amount — NUMBER(19)
    • prev_amount — NUMBER(19)
    • move_amount — NUMBER(19)

    lot_history

    • hist_id — NUMBER(19) — Primary key — NOT NULL
    • created_date — DATE — NOT NULL
    • defect_qty — NUMBER(10)
    • end_time — TIMESTAMP
    • event_type — VARCHAR2(20 CHAR)
    • good_qty — NUMBER(10)
    • location_id — VARCHAR2(255 CHAR)
    • location_type — VARCHAR2(50 CHAR)
    • order_id — VARCHAR2(16 CHAR)
    • quantity — NUMBER(10)
    • start_time — TIMESTAMP
    • status — VARCHAR2(50 CHAR)
    • lot_no — VARCHAR2(50 CHAR) — Foreign key → lot_master.lot_no — NOT NULL
    • process_id — VARCHAR2(20 CHAR) — Foreign key → process_mst.process_id
    • worker_id — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id

    lot_master

    • lot_no — VARCHAR2(50 CHAR) — Primary key — NOT NULL
    • lot_type — VARCHAR2(10 CHAR)
    • order_id — VARCHAR2(16 CHAR)
    • prd_id — VARCHAR2(255 CHAR)
    • created_date — TIMESTAMP
    • current_loc_id — VARCHAR2(255 CHAR)
    • current_loc_type — VARCHAR2(50 CHAR)
    • current_status — VARCHAR2(50 CHAR)
    • quantity — NUMBER(10)
    • status_change_date — TIMESTAMP

    lot_relationship

    • rel_id — NUMBER(19) — Primary key — NOT NULL
    • created_date — DATE — NOT NULL
    • used_qty — NUMBER(10)
    • input_lot_no — VARCHAR2(50 CHAR) — Foreign key → lot_master.lot_no — NOT NULL
    • output_lot_no — VARCHAR2(50 CHAR) — Foreign key → lot_master.lot_no — NOT NULL

    material_mst

    • mat_id — VARCHAR2(50 CHAR) — Primary key — NOT NULL
    • mat_name — VARCHAR2(100 CHAR) — NOT NULL
    • mat_type — VARCHAR2(50 CHAR)
    • mat_unit — VARCHAR2(20 CHAR)
    • mat_desc — VARCHAR2(255 BYTE)
    • created_id — VARCHAR2(7 BYTE)
    • created_date — DATE
    • updated_id — VARCHAR2(7 BYTE)
    • updated_date — DATE
    • use_yn — VARCHAR2(1 CHAR) — NOT NULL
    • effective_date — NUMBER

    material_order

    • order_id — VARCHAR2(255 CHAR) — Primary key — NOT NULL
    • client_id — VARCHAR2(255 CHAR) — NOT NULL
    • created_date — TIMESTAMP
    • due_date — VARCHAR2(255 CHAR) — NOT NULL
    • emp_id — VARCHAR2(255 CHAR) — NOT NULL
    • status — VARCHAR2(255 CHAR) — NOT NULL
    • total_amount — VARCHAR2(255 CHAR) — NOT NULL
    • plan_id — VARCHAR2(255 CHAR)

    material_order_item

    • order_item_id — NUMBER(19) — Primary key — NOT NULL
    • vat — NUMBER(19) — NOT NULL
    • item_id — NUMBER(19) — NOT NULL
    • order_amount — NUMBER(19) — NOT NULL
    • supply_amount — NUMBER(19) — NOT NULL
    • total_price — NUMBER(19) — NOT NULL
    • unit_price — NUMBER(19) — NOT NULL
    • order_id — VARCHAR2(255 CHAR) — Foreign key → material_order.order_id

    msg_favorite

    • fv_user — VARCHAR2(255 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • emp_id — VARCHAR2(255 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • created_date — TIMESTAMP — NOT NULL

    msg_message

    • msg_id — NUMBER(19) — Primary key — NOT NULL
    • sender_id — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • room_id — NUMBER(19) — Foreign key → msg_room.room_id — NOT NULL
    • sent_date — TIMESTAMP — NOT NULL
    • msg_type — VARCHAR2(20 CHAR) — NOT NULL
    • file_id — VARCHAR2(255 CHAR)
    • remark — VARCHAR2(255 CHAR)
    • msg_content — CLOB

    msg_relation

    • relation_id — NUMBER(19) — Primary key — NOT NULL
    • emp_id — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • active_date — TIMESTAMP — NOT NULL
    • join_date — TIMESTAMP — NOT NULL
    • last_read_id — NUMBER(19)
    • pinned_date — TIMESTAMP
    • room_id — NUMBER(19) — Foreign key → msg_room.room_id — NOT NULL
    • participant_yn — CHAR(1 BYTE) — NOT NULL
    • pinned_yn — CHAR(1 BYTE) — NOT NULL
    • remark — VARCHAR2(255 CHAR)

    msg_room

    • room_id — NUMBER(19) — Primary key — NOT NULL
    • updated_user — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id
    • created_date — TIMESTAMP — NOT NULL
    • updated_date — TIMESTAMP
    • group_name — VARCHAR2(50 CHAR)
    • group_yn — CHAR(1 BYTE) — NOT NULL

    msg_status

    • emp_id — VARCHAR2(7 CHAR) — Primary key — NOT NULL
    • msg_profile — NUMBER(10) — NOT NULL
    • online_yn — VARCHAR2(1 CHAR) — NOT NULL
    • avlb_updated — TIMESTAMP
    • last_login — TIMESTAMP
    • work_stat_updated — TIMESTAMP — NOT NULL
    • manual_work_stat — VARCHAR2(20 CHAR)
    • work_stat_source — VARCHAR2(20 CHAR) — NOT NULL
    • auto_work_stat — VARCHAR2(20 BYTE) — NOT NULL
    • avlb_stat — VARCHAR2(20 BYTE) — NOT NULL
    • remark — VARCHAR2(255 CHAR)

    notice

    • notice_id — NUMBER(19) — Primary key — NOT NULL
    • deleteyn — VARCHAR2(1 CHAR) — NOT NULL
    • noticeyn — VARCHAR2(1 CHAR) — NOT NULL
    • created_user — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • updated_user — VARCHAR2(7 CHAR) — Foreign key → emp.emp_id
    • created_date — TIMESTAMP
    • updated_date — TIMESTAMP
    • notice_content — VARCHAR2(255 CHAR) — NOT NULL
    • notice_title — VARCHAR2(255 CHAR) — NOT NULL

    order_item

    • order_item_id — NUMBER(19) — Primary key — NOT NULL — 수주
    • created_at — TIMESTAMP — 데이터
    • item_memo — VARCHAR2(2000 CHAR) — 품목
    • item_status — VARCHAR2(50 CHAR) — 품목
    • order_id — VARCHAR2(30 CHAR) — Foreign key → orders.order_id — NOT NULL — 수주
    • order_qty — NUMBER(18, 2) — NOT NULL — 주문한
    • prd_id — VARCHAR2(30 CHAR) — Foreign key — NOT NULL — 주문한
    • total_price — NUMBER(18, 2) — NOT NULL — 수주
    • unit_price — NUMBER(18, 2) — NOT NULL — 제품
    • updated_at — TIMESTAMP — 데이터

    orders

    • order_id — VARCHAR2(30 CHAR) — Primary key — NOT NULL — 수주(주문)
    • client_id — VARCHAR2(20 CHAR) — Foreign key → client.client_id — NOT NULL — 주문을
    • created_at — TIMESTAMP — 데이터
    • created_by — VARCHAR2(30 CHAR) — 최초
    • delivery_date — DATE — 고객이
    • order_date — DATE — 수주가
    • order_memo — VARCHAR2(2000 CHAR) — 주문에
    • order_num — VARCHAR2(30 CHAR) — 외부에서
    • order_status — VARCHAR2(20 CHAR) — NOT NULL — 수주
    • emp_id — VARCHAR2(30 CHAR) — NOT NULL
    • manager_email — VARCHAR2(100 CHAR)
    • manager_name — VARCHAR2(100 CHAR)
    • manager_tel — VARCHAR2(50 CHAR)
    • addr — VARCHAR2(255 CHAR)
    • addr_detail — VARCHAR2(2000 CHAR)
    • postcode — VARCHAR2(20 CHAR)

    outbound

    • outbound_id — VARCHAR2(255 CHAR) — Primary key — NOT NULL
    • created_date — TIMESTAMP
    • expect_outbound_date — TIMESTAMP
    • outbound_date — TIMESTAMP
    • process_by — VARCHAR2(255 CHAR)
    • request_by — VARCHAR2(255 CHAR) — NOT NULL
    • shipment_id — VARCHAR2(255 CHAR)
    • status — VARCHAR2(255 CHAR) — NOT NULL
    • work_order_id — VARCHAR2(255 CHAR)

    outbound_item

    • outbound_item_id — NUMBER(19) — Primary key — NOT NULL
    • item_id — VARCHAR2(255 CHAR) — NOT NULL
    • item_type — VARCHAR2(255 CHAR) — NOT NULL
    • location_id — VARCHAR2(255 CHAR)
    • lot_no — VARCHAR2(255 CHAR) — NOT NULL
    • outbound_amount — NUMBER(19) — NOT NULL
    • outbound_id — VARCHAR2(255 CHAR) — Foreign key → outbound.outbound_id — NOT NULL
    • iv_id — NUMBER(19)

    pay_calc_rule

    • rule_id — NUMBER(19) — Primary key — NOT NULL — 규칙ID
    • end_date — DATE — 적용
    • priority — NUMBER(10) — 낮을수록
    • start_date — DATE — 적용
    • value_num — NUMBER(21, 6) — 정의/비율/금액
    • rule_type — VARCHAR2(10 CHAR) — NOT NULL — 계산
    • target_type — VARCHAR2(10 CHAR) — 대상
    • status — VARCHAR2(12 CHAR) — NOT NULL — 사용
    • item_code — VARCHAR2(20 CHAR) — Foreign key → pay_item_mst.item_code — NOT NULL — 적용될
    • target_code — VARCHAR2(30 CHAR) — 대상
    • remark — VARCHAR2(255 CHAR)
    • calc_formula — CLOB — 계산

    pay_item_mst

    • item_code — VARCHAR2(20 CHAR) — Primary key — NOT NULL — 급여
    • sort_no — NUMBER(10)
    • calc_method — VARCHAR2(20 CHAR) — NOT NULL — 급여
    • item_group — VARCHAR2(20 CHAR) — NOT NULL — 기본급/인센티브/공제액
    • item_type — VARCHAR2(20 CHAR) — NOT NULL — 수입/공제
    • item_name — VARCHAR2(60 CHAR) — NOT NULL — 화면/보고서
    • remark — VARCHAR2(200 CHAR)
    • taxable — CHAR(1 BYTE) — 과세
    • use_yn — CHAR(1 BYTE)

    pay_rule

    • rule_id — NUMBER(19) — Primary key — NOT NULL — 기준
    • base_amt — NUMBER(15, 2) — 기본금:
    • emp_rate — NUMBER(7, 4) — 고용보험
    • end_date — DATE — 적용
    • hlth_rate — NUMBER(7, 4) — 건강보험
    • meal_amt — NUMBER(15, 2) — 식대:
    • pay_day — NUMBER(10) — 지급일자(매월
    • pen_rate — NUMBER(7, 4) — 국민연금
    • start_date — DATE — NOT NULL — 적용
    • tax_rate — NUMBER(7, 4) — 소득세율(예:
    • trans_amt — NUMBER(15, 2) — 교통비:
    • created_date — TIMESTAMP — 생성일시
    • updated_date — TIMESTAMP — 수정일시
    • status — VARCHAR2(10 CHAR) — NOT NULL — 상태:
    • remark — CLOB — 비고(관리자

    payroll_payslip

    • payslip_id — NUMBER(19) — Primary key — NOT NULL
    • alw_amt — NUMBER(15, 2) — NOT NULL — 총
    • base_amt — NUMBER(15, 2) — NOT NULL — 기본금
    • ded_amt — NUMBER(15, 2) — NOT NULL — 총
    • inc_amt — NUMBER(15, 2) — NOT NULL — 인센티브
    • is_partial — VARCHAR2(1 CHAR) — NOT NULL — 부분
    • net_amt — NUMBER(15, 2) — NOT NULL — 실
    • tot_amt — NUMBER(15, 2) — NOT NULL — 총
    • pay_yymm — VARCHAR2(6 CHAR) — NOT NULL — 급여
    • calc_date — TIMESTAMP — NOT NULL — 계산일시
    • confirm_date — TIMESTAMP — 확정일시
    • job_id — NUMBER(19)
    • calc_status — VARCHAR2(20 CHAR) — NOT NULL — 계산
    • calc_type — VARCHAR2(20 CHAR) — NOT NULL — 계산유형
    • confirm_user — VARCHAR2(20 CHAR) — 확정자
    • dept_id — VARCHAR2(20 CHAR) — Foreign key → dept.dept_id
    • emp_id — VARCHAR2(20 CHAR) — Foreign key → emp.emp_id — NOT NULL
    • pdf_hash_id — VARCHAR2(40 CHAR)
    • pdf_path — VARCHAR2(255 CHAR)
    • remark — CLOB

    position

    • pos_code — VARCHAR2(10 CHAR) — Primary key — NOT NULL
    • is_executive — VARCHAR2(1 CHAR) — NOT NULL
    • rank_order — NUMBER(10) — NOT NULL
    • use_yn — VARCHAR2(1 CHAR) — NOT NULL
    • created_date — TIMESTAMP — NOT NULL
    • pos_name — VARCHAR2(30 CHAR) — NOT NULL

    process_mst

    • process_id — VARCHAR2(20 BYTE) — Primary key — NOT NULL
    • process_name — VARCHAR2(100 BYTE) — NOT NULL
    • process_type — VARCHAR2(20 BYTE) — NOT NULL
    • description — VARCHAR2(400 BYTE)
    • use_yn — VARCHAR2(1 CHAR) — NOT NULL
    • created_id — VARCHAR2(7 BYTE) — NOT NULL
    • created_date — TIMESTAMP
    • updated_id — VARCHAR2(7 BYTE)
    • updated_date — TIMESTAMP

    prod_equip

    • equip_id — NUMBER(10) — Primary key — NOT NULL
    • created_date — TIMESTAMP — NOT NULL
    • equip_name — VARCHAR2(255 CHAR) — NOT NULL
    • remark — VARCHAR2(255 CHAR)
    • status — VARCHAR2(255 CHAR) — NOT NULL
    • updated_date — TIMESTAMP
    • equip_code — VARCHAR2(255 CHAR) — NOT NULL
    • line_id — VARCHAR2(255 CHAR) — NOT NULL

    prod_line

    • line_id — VARCHAR2(255 CHAR) — Primary key — NOT NULL
    • line_name — VARCHAR2(255 CHAR) — NOT NULL
    • status — VARCHAR2(255 CHAR) — NOT NULL
    • remark — VARCHAR2(500 CHAR)
    • use_yn — CHAR(1 BYTE) — NOT NULL

    product_mst

    • prd_id — VARCHAR2(50 CHAR) — Primary key — NOT NULL
    • created_date — DATE
    • created_id — VARCHAR2(255 CHAR)
    • effective_date — NUMBER
    • prd_cat — VARCHAR2(50 CHAR)
    • prd_name — VARCHAR2(100 CHAR)
    • prd_spec — VARCHAR2(225 CHAR)
    • prd_status — VARCHAR2(20 CHAR)
    • updated_date — DATE
    • updated_id — VARCHAR2(255 CHAR)
    • item_name — VARCHAR2(50 BYTE)
    • prd_unit — VARCHAR2(20 CHAR)
    • min_qty — NUMBER(19)
    • unit_price — NUMBER(18, 2)
    • use_yn — VARCHAR2(1 CHAR) — NOT NULL

    production_plan

    • plan_id — VARCHAR2(20 CHAR) — Primary key — NOT NULL
    • created_at — TIMESTAMP
    • created_by — VARCHAR2(30 CHAR)
    • due_date — DATE — NOT NULL
    • plan_date — DATE — NOT NULL
    • plan_memo — VARCHAR2(1000 CHAR)
    • status — VARCHAR2(20 BYTE) — NOT NULL
    • updated_at — TIMESTAMP
    • prd_id — VARCHAR2(20 BYTE)
    • plan_qty — NUMBER
    • updated_by — VARCHAR2(30 BYTE)

    production_plan_item

    • plan_item_id — VARCHAR2(20 CHAR) — Primary key — NOT NULL
    • created_at — TIMESTAMP
    • created_by — VARCHAR2(30 CHAR)
    • item_memo — VARCHAR2(300 CHAR)
    • order_qty — NUMBER(10, 2) — NOT NULL
    • plan_id — VARCHAR2(20 CHAR) — NOT NULL
    • plan_qty — NUMBER(10, 2) — NOT NULL
    • prd_id — VARCHAR2(20 CHAR) — NOT NULL
    • updated_at — TIMESTAMP
    • partial_qty — FLOAT(53)
    • order_item_id — NUMBER(19)
    • bom_status — VARCHAR2(10 CHAR)
    • status — VARCHAR2(20 BYTE) — NOT NULL

    qc_item

    • qc_item_id — VARCHAR2(20 CHAR) — Primary key — NOT NULL
    • item_name — VARCHAR2(100 CHAR)
    • target_type — VARCHAR2(20 CHAR)
    • unit — VARCHAR2(20 CHAR)
    • std_text — VARCHAR2(200 CHAR)
    • min_value — NUMBER(10, 2)
    • max_value — NUMBER(10, 2)
    • use_yn — VARCHAR2(1 CHAR)
    • sort_order — NUMBER(5)
    • created_id — VARCHAR2(7 BYTE)
    • created_date — DATE
    • updated_id — VARCHAR2(7 BYTE)
    • updated_date — DATE
    • create_date — DATE

    qc_result

    • qc_result_id — NUMBER(19) — Primary key — NOT NULL
    • created_date — TIMESTAMP — NOT NULL
    • created_id — VARCHAR2(7 CHAR) — NOT NULL
    • defect_qty — NUMBER(10)
    • fail_reason — VARCHAR2(400 CHAR)
    • good_qty — NUMBER(10)
    • inspection_date — DATE
    • inspection_qty — NUMBER(10)
    • inspector_id — VARCHAR2(7 CHAR)
    • order_id — VARCHAR2(16 CHAR) — NOT NULL
    • overall_result — VARCHAR2(10 CHAR) — NOT NULL
    • remark — VARCHAR2(200 CHAR)
    • updated_id — VARCHAR2(7 CHAR)
    • updated_date — TIMESTAMP
    • lot_no — VARCHAR2(50 CHAR)

    qc_result_detail

    • qc_result_dtl_id — VARCHAR2(20 CHAR) — Primary key — NOT NULL
    • created_date — TIMESTAMP — NOT NULL
    • created_user — VARCHAR2(7 CHAR) — NOT NULL
    • measure_value — VARCHAR2(20 CHAR)
    • qc_item_id — VARCHAR2(20 CHAR) — NOT NULL
    • qc_result_id — VARCHAR2(20 CHAR) — NOT NULL
    • remark — VARCHAR2(200 CHAR)
    • result — VARCHAR2(10 CHAR)
    • updated_date — TIMESTAMP
    • updated_user — VARCHAR2(7 CHAR)

    role

    • role_code — VARCHAR2(20 CHAR) — Primary key — NOT NULL
    • use_yn — VARCHAR2(1 CHAR) — NOT NULL
    • created_date — TIMESTAMP — NOT NULL
    • role_name — VARCHAR2(50 CHAR) — NOT NULL
    • role_desc — VARCHAR2(200 CHAR)

    route_header

    • route_id — VARCHAR2(20 CHAR) — Primary key — NOT NULL
    • created_date — TIMESTAMP
    • created_id — VARCHAR2(7 CHAR) — NOT NULL
    • description — VARCHAR2(400 CHAR)
    • route_name — VARCHAR2(100 CHAR) — NOT NULL
    • updated_date — TIMESTAMP
    • updated_id — VARCHAR2(7 CHAR)
    • use_yn — VARCHAR2(1 CHAR) — NOT NULL
    • prd_id — VARCHAR2(50 CHAR) — NOT NULL

    route_step

    • route_step_id — VARCHAR2(20 BYTE) — Primary key — NOT NULL
    • route_id — VARCHAR2(20 BYTE) — NOT NULL
    • step_seq — NUMBER(5) — NOT NULL
    • process_id — VARCHAR2(20 BYTE) — NOT NULL
    • qc_point_yn — VARCHAR2(1 CHAR) — NOT NULL
    • remark — VARCHAR2(200 BYTE)
    • created_id — VARCHAR2(7 BYTE) — NOT NULL
    • created_date — TIMESTAMP
    • updated_id — VARCHAR2(7 BYTE)
    • updated_date — TIMESTAMP

    safety_stock

    • item_id — VARCHAR2(50 CHAR) — Primary key — NOT NULL
    • item_name — VARCHAR2(50 CHAR)
    • item_type — VARCHAR2(100 CHAR)
    • item_unit — VARCHAR2(255 CHAR)
    • policy_days — NUMBER(19)
    • policy_type — VARCHAR2(255 CHAR)
    • remark — VARCHAR2(255 CHAR)
    • safety_stock_qty — NUMBER(19)
    • safety_stock_qty_daily — NUMBER(19)
    • status — VARCHAR2(255 CHAR)
    • volume — NUMBER(19)
    • days_safety_stock_qty — NUMBER(19)

    schedule

    • schedule_id — NUMBER(19) — Primary key — NOT NULL
    • alldayyn — VARCHAR2(1 CHAR) — NOT NULL
    • created_user — VARCHAR2(7 CHAR) — NOT NULL
    • created_date — TIMESTAMP
    • schedule_finish — TIMESTAMP — NOT NULL
    • schedule_start — TIMESTAMP — NOT NULL
    • updated_date — TIMESTAMP
    • schedule_content — VARCHAR2(255 CHAR) — NOT NULL
    • schedule_title — VARCHAR2(255 CHAR) — NOT NULL
    • schedule_type — VARCHAR2(255 CHAR) — NOT NULL

    schedule_sharer

    • schedule_id — NUMBER(19) — Foreign key → schedule.schedule_id — NOT NULL
    • shared_emp_id — VARCHAR2(255 CHAR) — Foreign key — NOT NULL

    shipment

    • shipment_id — VARCHAR2(255 CHAR) — Primary key — NOT NULL
    • client_id — VARCHAR2(30 CHAR) — NOT NULL
    • client_name — VARCHAR2(200 CHAR)
    • created_at — TIMESTAMP
    • emp_id — VARCHAR2(20 CHAR) — NOT NULL
    • memo — VARCHAR2(2000 CHAR)
    • order_id — VARCHAR2(255 CHAR) — NOT NULL
    • shipment_date — DATE
    • shipment_status — VARCHAR2(255 CHAR) — NOT NULL
    • tracking_number — VARCHAR2(50 CHAR)
    • updated_at — TIMESTAMP

    shipment_item

    • shipment_item_id — NUMBER(19) — Primary key — NOT NULL
    • created_at — TIMESTAMP
    • lot_qty — NUMBER(18, 2) — NOT NULL
    • prd_id — VARCHAR2(30 CHAR) — NOT NULL
    • shipment_id — VARCHAR2(30 CHAR) — NOT NULL
    • updated_at — TIMESTAMP

    shipment_lot

    • shipment_lot_id — NUMBER(19) — Primary key — NOT NULL
    • created_at — TIMESTAMP
    • lot_no — VARCHAR2(50 CHAR) — NOT NULL
    • lot_qty — NUMBER(18, 2) — NOT NULL
    • shipment_id — NUMBER(19) — NOT NULL
    • updated_at — TIMESTAMP
    • prd_id — VARCHAR2(30 CHAR) — NOT NULL

    temp_bom_hdr_seq

    • bom_id — VARCHAR2(50 BYTE)
    • next_seq — NUMBER

    warehouse_location

    • location_id — VARCHAR2(255 CHAR) — Primary key — NOT NULL
    • rack — VARCHAR2(255 CHAR)
    • zone — VARCHAR2(255 CHAR)
    • rack_col — VARCHAR2(255 CHAR) — NOT NULL
    • rack_row — VARCHAR2(255 CHAR) — NOT NULL

    work_order

    • order_id — VARCHAR2(16 CHAR) — Primary key — NOT NULL
    • created_date — TIMESTAMP — NOT NULL
    • plan_qty — NUMBER(10) — NOT NULL
    • remark — VARCHAR2(255 CHAR)
    • status — VARCHAR2(255 CHAR) — NOT NULL
    • updated_date — TIMESTAMP
    • created_id — VARCHAR2(7 CHAR) — NOT NULL
    • line_id — VARCHAR2(255 CHAR) — NOT NULL
    • prd_id — VARCHAR2(50 CHAR) — NOT NULL
    • act_end_date — TIMESTAMP
    • act_start_date — TIMESTAMP
    • plan_id — VARCHAR2(255 CHAR)
    • process_id — VARCHAR2(255 CHAR)
    • plan_end_date — TIMESTAMP — NOT NULL
    • plan_start_date — TIMESTAMP — NOT NULL
    • route_id — VARCHAR2(255 CHAR)
    • outbound_yn — CHAR(1 BYTE) — NOT NULL

    work_order_process

    • wop_id — VARCHAR2(255 CHAR) — Primary key — NOT NULL
    • created_date — TIMESTAMP
    • created_id — VARCHAR2(7 CHAR) — NOT NULL
    • defect_qty — NUMBER(10)
    • end_time — TIMESTAMP
    • good_qty — NUMBER(10)
    • memo — VARCHAR2(400 CHAR)
    • order_id — VARCHAR2(16 CHAR) — NOT NULL
    • process_id — VARCHAR2(20 CHAR) — NOT NULL
    • route_step_id — VARCHAR2(20 CHAR) — NOT NULL
    • start_time — TIMESTAMP
    • status — VARCHAR2(20 CHAR) — NOT NULL
    • step_seq — NUMBER(10) — NOT NULL
    • updated_date — TIMESTAMP
    • updated_id — VARCHAR2(7 CHAR)
    • lot_no — VARCHAR2(50 CHAR)

    work_policy

    • policy_id — NUMBER(19) — Primary key — NOT NULL
    • created_date — DATE
    • late_limit — NUMBER(10) — NOT NULL
    • updated_date — DATE
    • in_time — VARCHAR2(5 CHAR) — NOT NULL
    • lunch_in — VARCHAR2(5 CHAR) — NOT NULL
    • lunch_out — VARCHAR2(5 CHAR) — NOT NULL
    • out_time — VARCHAR2(5 CHAR) — NOT NULL
    • annual_basis — VARCHAR2(10 CHAR) — NOT NULL

    work_schedule

    • schedule_id — NUMBER(19) — Primary key — NOT NULL
    • color_code — VARCHAR2(255 CHAR) — NOT NULL
    • end_date — TIMESTAMP — NOT NULL
    • remark — VARCHAR2(255 CHAR)
    • start_date — TIMESTAMP — NOT NULL
    • line_id — VARCHAR2(255 CHAR) — NOT NULL
    • work_id — VARCHAR2(16 CHAR) — NOT NULL

    worker_process

    • wp_id — NUMBER(19) — Primary key — NOT NULL
    • process_id — VARCHAR2(20 CHAR) — NOT NULL
    • schedule_id — NUMBER(19) — NOT NULL
    • worker_id — VARCHAR2(7 CHAR) — NOT NULL

    worker_schedule

    • ws_id — NUMBER(19) — Primary key — NOT NULL
    • equip_id — NUMBER(10) — NOT NULL
    • schedule_id — NUMBER(19) — NOT NULL
    • worker_id — VARCHAR2(7 CHAR) — NOT NULL