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