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