바텍
테이블 (6)
BASIC_INFO
- idx — INT(10) — 기본 키 — NOT NULL — 자동증가값
- item_code — VARCHAR(55)
- item_name — TEXT
- draw_no — VARCHAR(55)
- item_standard — VARCHAR(55)
- corp_delivery_idx — INT(11)
- packing — INT(11)
- item_buy_price — INT(11)
- rop — VARCHAR(55)
- safety_stock — VARCHAR(55)
- term — INT(11)
- use_rop — VARCHAR(55)
- ea — INT(11)
- item_month_use — INT(11)
- created_user — VARCHAR(55)
- created_at — DATETIME
- updated_user — VARCHAR(55)
- updated_at — DATETIME
- use_auto_order — INT(11)
- img_file — VARCHAR(55)
- iso — VARCHAR(100)
- display — ENUM('Y', 'N')
BASIC_STOCK_DELIVERY
- idx — INT(10) — 기본 키 — NOT NULL — 자동증가값
- invoice_no — VARCHAR(55)
- inout_type — VARCHAR(55)
- item_code — VARCHAR(55)
- sn — VARCHAR(55)
- QR_CODE — VARCHAR(55)
- packing — INT(11)
- from_location — VARCHAR(55)
- rack_info — VARCHAR(55)
- to_location — VARCHAR(55)
- comp_type — VARCHAR(50)
- created_user — VARCHAR(55)
- created_at — DATETIME
- updated_user — VARCHAR(55)
- updated_at — DATETIME
- reason — VARCHAR(200)
- process — INT(11)
BASIC_STOCK_DETAIL
- idx — INT(10) — 기본 키 — NOT NULL — 자동증가값
- use_yn — INT(11)
- type — VARCHAR(55)
- item_code — VARCHAR(55)
- sn — VARCHAR(55)
- QR_CODE — VARCHAR(55)
- packing — INT(11)
- cr_comp — VARCHAR(55)
- created_user — VARCHAR(55)
- created_at — DATETIME
- updated_user — VARCHAR(55)
- updated_at — DATETIME
- reason — VARCHAR(200)
- inv_det_idx — INT(11)
- ref_idx — INT(11)
- text — VARCHAR(100)
BASIC_STOCK_MASTER
- idx — INT(10) — 기본 키 — NOT NULL — 자동증가값
- use_yn — INT(11)
- item_code — VARCHAR(55)
- ea — INT(11)
- packing — INT(11) — NOT NULL
- created_user — VARCHAR(55)
- created_at — DATETIME
- updated_user — VARCHAR(55)
- updated_at — DATETIME
DEPARTMENT_INFO
- idx — INT(10) — 기본 키 — NOT NULL — 자동증가값
- type_idx — INT(11)
- department_code — VARCHAR(55)
- department_name — VARCHAR(55)
- department_officer — VARCHAR(50)
- user_idx — INT(11)
- created_user — VARCHAR(55)
- created_at — DATETIME
- updated_user — VARCHAR(55)
- updated_at — DATETIME
DEPARTMENT_TYPE_INFO
- idx — INT(10) — 기본 키 — NOT NULL — 자동증가값
- type_name — VARCHAR(55)
- business_idx — INT(11)
- created_user — VARCHAR(55)
- created_at — DATETIME
- updated_user — VARCHAR(55)
- updated_at — DATETIME