YEOUN
Tables (76)
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