asd
Tables (3)
tbl_inbound
- id — int — Primary key — NOT NULL
- group_id — int — Foreign key → tbl_inbound.id — NOT NULL — 상위입고ID
- item_id — int — Foreign key → tbl_item.id — NOT NULL — 품목ID
- inbound_name — varchar — NOT NULL — 입고 표시 명
- inbound_date — date — NOT NULL — 입고일자
- inbound_qty — int — NOT NULL — 입고수량
- inbound_type — char — NOT NULL — 입고유형(N:신규,W:WS)
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- creator_id — int — NOT NULL
- updater_id — int
tbl_item
- id — int — Primary key — NOT NULL
- item_code — varchar — NOT NULL — 품목코드
- item_type — varchar — NOT NULL — 품목유형(카운터,터미널,브라켓,배터리,나사,...)
- item_name — varchar — NOT NULL — 품목명
- unit — int — NOT NULL — 품목 단위(ea, box, set,...)
- created_at — timestamp — NOT NULL
- creator_id — int — NOT NULL
tbl_outbound
- id — int — Primary key — NOT NULL
- inbound_id — int — Foreign key → tbl_inbound.id — NOT NULL — 입고ID
- outbound_qty — int — 출고수량
- oubound_date — date — 출고일자
- company — varchar — 고객사
- customer — varchar — 납품처
- created_at — timestamp — NOT NULL
- update_at — timestamp
- creator_id — int — NOT NULL
- updater_id — int