TOC_재고관리

테이블 (4)

tbl_defect_product_log (부적합품 관리 테이블)

  • id — int — 기본 키 — NOT NULL
  • Release_Id (release_id) — int — 외래 키 → tbl_product_outbound.id — NOT NULL
  • Defect_Type (defect_type) — varchar
  • Defect_State (defect_state) — varchar
  • Re_Receiving_At (re_receiving_at) — date
  • Etc (etc) — varchar
  • Created_At (created_at) — timestamp

tbl_item (품목 테이블)

  • Id (id) — int — 기본 키 — NOT NULL
  • Item_Code (item_code) — varchar
  • Category (category) — varchar
  • Item_Name (item_name) — varchar

tbl_product_inbound (입고 테이블)

  • Id (id) — int — 기본 키 — NOT NULL
  • Item_Id (item_id) — int — 외래 키 → tbl_item.Id — NOT NULL
  • Product_Id (product_id) — varchar
  • Receiving_Group (receiving_group) — varchar
  • State (state) — varchar
  • Is_Reused (is_reused) — boolean
  • Receiving_At (receiving_at) — date
  • Created_At (created_at) — timestamp
  • Updated_At (updated_at) — timestamp

tbl_product_outbound (출고 테이블)

  • id — int — 기본 키 — NOT NULL
  • Delivered_Qty (delivered_qty) — int
  • Company (company) — varchar
  • Customer (customer) — varchar
  • Delivered_Group (delivered_group) — varchar
  • Released_At (released_at) — date
  • Update_At (update_at) — date
  • Created_At (created_at) — timestamp