Inbound

테이블 (8)

Approval(입고승인) (Untitled4)

  • approval_id — int — 기본 키 — NOT NULL
  • approval_date — date
  • approver — varchar(20)
  • approval_status — varchar(10)
  • request_id (request_id2) — int — 외래 키 → InboundRequest(입고요청).request_id — NOT NULL — Auto_increment

InboundRequest(입고요청) (Untitled)

  • request_id — int — 기본 키 — NOT NULL — Auto_increment
  • request_date — Date
  • status — varchar(50)
  • member_id — varchar(15) — 외래 키 → Member.member_id — NOT NULL

InboundRequestItem(입고요청품목) (Untitled2)

  • item_id — int — 기본 키 — NOT NULL — Auto_increment
  • quantity — int
  • received_quantity — int
  • instpection_status — varchar(50)
  • request_id — int — 외래 키 → InboundRequest(입고요청).request_id — NOT NULL — Auto_increment
  • product_id (product_id2) — int — 외래 키 → Product(제품/품목).product_id — NOT NULL

Inspection( 검수) (Untitled3)

  • inspection_id — int — 기본 키 — NOT NULL
  • inspection_date — Date
  • inspector — varchar(20)
  • inspection_result — varchar(50)
  • request_id (request_id2) — int — 외래 키 → InboundRequest(입고요청).request_id — NOT NULL — Auto_increment

Inventory(재고) (Untitled5)

  • inventory_id — int — 기본 키 — NOT NULL
  • quantity — int
  • location — varchar(50)
  • product_id (product_id2) — varchar(10) — 외래 키 → Product(제품/품목).product_id — NOT NULL
  • warehouse_id (warehouse_id2) — int — 외래 키 → Warehous(창고).warehouse_id — NOT NULL

Member (Untitled6)

  • member_id — varchar(15) — 기본 키 — NOT NULL
  • Field
  • Field2

Product(제품/품목) (Untitled8)

  • product_id — varchar(10) — 기본 키 — NOT NULL
  • product_name — varchar(30)
  • price — int
  • brand — varchar(30)
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

Warehous(창고) (Untitled7)

  • warehouse_id — int — 기본 키 — NOT NULL
  • location — varhcar(20)